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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Reordering of Subreports at Run Time
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

17 Posts

Posted - 03/21/2014 :  15:55:31  Show Profile  Reply with Quote
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.


Bob Larson
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000