Subreport on new page and blank page

Subreport on new page and blank page

Posted by: gabriel.bojan on 7 November 2018, 6:44 am EST

• 

  gabriel.bojan

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 November 2018, 6:44 am EST

  Hi!

  Let’s say my data source is a list of restaurants.

  The first/top part of the report (could be multiple pages) is a summary of all the restaurants sale, employee hours and so on. The second part of the report is a per restaurant details.
  
  For the details I use a sub report within a table and all works great.

  What I am having trouble with is to start each sub report on a new page. Currently at the top of the sub report I have a container and I set PageBreakAtStart to True.

  If the last page of the summary has white space at the bottom, the first sub report renders on the next page and all is good. If the last page of the summary is completely used I end up with a blank page before the first sub report. How can I get rid of the blank page?

  Thank you.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 11 November 2018, 6:57 pm EST

  Hello,

  Could you please try after setting the “ConsumeWhiteSpace” property of the report to “True”. If the issue is not resolved by the above solution, could you please share the sample report with us so that I can reproduce the issue at my end and provide the solution accordingly.

  Thanks

• 

  gabriel.bojan

  • Post Options:
  • Link
    Copy

  Posted 12 November 2018, 6:19 am EST

  Hi mohitg!
  
  I have tried your suggestion without any luck.
  
  Please see the attached reports and the data source.

  The table on “Summary.rdlx” has variable height content above (ie tables). To quickly simulate this table being pushed down by the above content I just changed the table’s top location.
  
  This is what I see:

  1. Location.Top = 5.125 Summary consumes the entire page, second page is blank. This blank page is the problem.
  2. Location.Top = 5.25 Summary consumes part of the second page. (shows the 4th record). Page 3 has the first detail row. This is working as expected.

  Note: “Container 1” on “Detail.rdlx” has “PageBreakAtStart” set to true.

  Also something that is not in the original question: How can I hide the “Summary Header” on “Detail.rdlx”? Each one of the reports should have its own header and not show both.

  Thank you!
  
  Summary.zip

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 12 November 2018, 6:18 pm EST

  Hello Gabriel,

  It is a designed behavior of the RDL report. Also, you cannot hide the PageHeader according to the subreport. However, you can use the subreport in the “PageReport” to achieve your requirement as a workaround. Could you please refer to the attached report for implementing the same.
  
  Note: I have used the “Grouping” in the table in the main report for “Page Break” instead container.

  Hope it helps.

  Thanks,
  
  Detail.zip