Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Reordering of Subreports at Run Time

Author  Topic 

boblarson
Starting Member

17 Posts

Posted - 2014-03-21 : 15:55:31
Is it possible to reorder subreports at run time? We have a set of reports that are necessary to create a pdf package for fund investors and we have certain times where we need the same set of reports but in a different order than for another time. The thought is to create a blank main report and have each of the reports as subreports in that main report so the user can do an export to PDF and capture the entire package.

We will be having a table which defines which reports are in which order for a fund.

Currently, in Access, we create PDF's of each report in the order that they are to appear and we keep track of the page counts including saving the report name and start page number to a table as we open each report to print to pdf and use that for creating the table of contents at the end of printing each report to PDF. There is then code which merges all of the printed PDF's to a single PDF file and including the Table of Contents which is an Access report which uses the table we have the report names in and the start page numbers.

I think we'll probably have to do some custom VB or C# coding to print each report to pdf and then do the merge similar to how we do it in Access but a colleague is wanting to try this single report method.

Thanks,

Bob Larson
   

- Advertisement -