Question on SSRS Sub Reports

Hi,

I am rewriting an existing infomaker report to use SSRS.  This report  has a couple sub reports in it.  The problem I am running into is one of the sub reports retrieves multiple rows, and the size of this sub report can vary in height because of this.  The main report ends up displaying an extra blank page when sub reports height is more than what is defined in the main report.  

Has anyone run into this or have any suggestions?

Thanks,

Jon

Parents
  • Hey Jon,

    I recently ran into this problem as well... It turned out the width of the sub report was slightly too wide for the print layout settings by just a little bit (the sub report doesn't scale down to fit the width of the sub-report object on the main report), which caused the extra blank pages.  After reducing the width of the sub-report a little, the blank pages went away.

    Kevin.

     

  • Thanks for the response.  I thought that was the issue as well.  But it turned out it was height with the sub report that was causing the premature page break.  I ended up removing all sub reports from this report, because I read somewhere there was an issue with sub reports causing the page to break early. 

    The report I had originally created had a list and with in the list were the sub reports.  I just moved all the data from the sub reports into the main data set for the list.  Then dropped a couple tables in the list and filtered each table by the row type in the data set. 

     

     

Reply
  • Thanks for the response.  I thought that was the issue as well.  But it turned out it was height with the sub report that was causing the premature page break.  I ended up removing all sub reports from this report, because I read somewhere there was an issue with sub reports causing the page to break early. 

    The report I had originally created had a list and with in the list were the sub reports.  I just moved all the data from the sub reports into the main data set for the list.  Then dropped a couple tables in the list and filtered each table by the row type in the data set. 

     

     

Children
No Data