[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 944
  • Last Modified:

Extend a Table till the End of the Page; Dynamic Header & Footer in SSRS

I have an urgent requrement to print a invoice like report with a fixed height.  Since there is no way to place a dynamic header/footer information, I designed the entire report in the detail section of the report.  This works fine except the report height changes according to the number of rows in the report.  Is there any way I can fix the height of the table/list in this report?  Also please tell me if there is any way I can solve the dynamic header/footer issue as well.
Thanks for your help in advance.
0
jkochel
Asked:
jkochel
  • 2
  • 2
1 Solution
 
Auric1983Commented:
jkochel,

If you use Parameters you can put the parameter values in the header/footer, don't know if that will help?

As for the calculated height, this is a bit of a kludge but you could calculate out how many table records you can fit on a page.  I'd create multiple table footers and hide them progamatically based on the rowcount.  
0
 
jkochelAuthor Commented:
"If you use Parameters you can put the parameter values in the header/footer, don't know if that will help?"
This won't help in my situation, because all the header/footer information is from the dataset only and its dynamic to each group in the dataset.

"As for the calculated height, this is a bit of a kludge but you could calculate out how many table records you can fit on a page.  I'd create multiple table footers and hide them progamatically based on the rowcount."
I will try this little differently and let you know if that works.
0
 
Auric1983Commented:
jkochel,

Good luck!
0
 
jkochelAuthor Commented:
We ended up abandoning SSRS in favor of the DevExpress reporting tool.  RDL just isn't powerful enough yet.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now