December 6, 2011 at 10:12 pm
Hi All,
I have a requirement to limit the no of pages in SSRS data driven subscription where the user wants top 5 or top 10 pages of reports instead of the entire no of pages.
Is there anyway i can acheive that.
Thanks
Subrat
January 9, 2012 at 10:05 am
Hi,
This depends on your report, if your report is simple and only consists of a single simple table and you can work out the number records in a page you may be able to achieve this. To do this you need to know how many records will be displayed on a page and then workout how many records need to be shown for 5 pages and 10 pages. Then you need to create a parameter which will filter the data based on the number of records. Then finally you will have to map the dds query for the users with the parameters.
This article will help with limiting the number of records on a page.
http://www.sqlservercentral.com/Forums/Topic490774-147-1.aspx
If the data in your report is such that you cannot work out with certainty how many records will be shown on a page then it would be quite difficult to achieve this as you are unable to use the globals.PageNumber value in the body of you report. These global pagenumber variables can only be used in the page header and footer, this is due to the way that the report rendered. The body of the report is rendered first and then the page header and footer are rendered.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply