views:

341

answers:

2

Hi,

I tried creating a report using a subreport. When i exported it to PDF i have noticed that there is extra blank pages in the PDF. I made it clear that body width + left margin+ right margin <=report width. But still it gives the blank page. subreport as individual working grt.

Also i am calling the subreport from with in a list in main report. i tried to set up a page break after list . but it looks like its not working.

i wanted to have the next list to be displayed in a new page.

How do i achive these.

Please help me with your ideas.

Thanks, San

A: 

A few things to look for:

  • Check the "parent" and subreport for any controls that are in your margins (or may grow into the margins). Setting the width doesn't necessarily force the controls to that width.
  • check for any controls that overlap. I've had strange things happen because of that (especially in SSRS 2005).
  • checking the "Print Layout" while previewing helps find most issues like this at design time (before exporting to PDF).
  • For the hard break with your list not sure what is goofy there. I usually use a table with groups and set the page breaks on the appropriate group. Depends on the data though.

    HTH

Mozy
A: 

When exporting to pdf and the report contains a sub report where the sub report is grouped on an item from parent report.

Do not use the list control in the parent report to group sub report. Use the table control.

The list control will cause blank pages while the table control does not

Svapneel