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)
 Using subreports

Author  Topic 

jbphoenix
Yak Posting Veteran

68 Posts

Posted - 2010-10-28 : 09:43:36
I have a report that is going to use 6 or 7 subreports. I've done this many times in 2005. We are now using 2008 and I'm having issues.

To start off I created an rdl that hold all the subreports. On this main rdl I have 1 subreport. This subreport is basically a coverpage. When I run the subreport rdl on it's own it prints to 1 page in pdf. However when I run the main report with just the 1 coverpage subreport, it prints to 2 pages in pdf. The page settings are 11x8 and no margins. I can't figure out why the report is printing to 2 pages when it should only be 1.

Any ideas? Thanks.

jbphoenix
Yak Posting Veteran

68 Posts

Posted - 2010-10-28 : 11:17:43
I recreated the coverpage subreport and the main report in 2005. And they both work as expected. I transfered them to 2008 and ran the report and it works fine. Problem is I don't want to go back and recreate the other 7 rdl's in 2005 and then switch them to 2008.
Go to Top of Page

jbphoenix
Yak Posting Veteran

68 Posts

Posted - 2010-10-28 : 12:24:30
I changed the width of the main report to match the width of the subreport container and now each subreport prints on only 1 page. I don't understand why that works but it does now.
Go to Top of Page
   

- Advertisement -