Solved

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

Posted on 2009-05-19
4
907 Views
Last Modified: 2012-08-13
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
Comment
Question by:jkochel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 16

Expert Comment

by:Auric1983
ID: 24423086
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
 

Author Comment

by:jkochel
ID: 24423341
"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
 
LVL 16

Expert Comment

by:Auric1983
ID: 24423409
jkochel,

Good luck!
0
 

Accepted Solution

by:
jkochel earned 0 total points
ID: 24695008
We ended up abandoning SSRS in favor of the DevExpress reporting tool.  RDL just isn't powerful enough yet.
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question