Paginated Report Subreport Visibility

Hello,

Here are a few suggestions:

• Use an expression on the table row (Row Visibility)
  This is what you are already doing, but you need to ensure that the expression returns True only when no data is to be displayed.
  • Example: =IIF(Fields!HasData.Value = False, True, False)
    However, this is not always sufficient if the subreport is still being evaluated.
    
    
• Using an expression in the subreport itself
  In the subreport, you can add a visibility condition to the main object (e.g. a table or data region) so that it does not generate anything if the data is empty.
  This prevents the subreport from generating empty content that takes up space.
  
  
• Using an expression in the NoRows property of the subreport
  You can define an empty message or a specific action when the subreport has no data
  =IIF(CountRows("DataSetName") = 0, "", "empty sub-report")
  
  
• Reduce the height of the line
  If you cannot avoid generating the line, you can try reducing its height to a minimum (e.g. 0.1 cm) when it is hidden, to prevent it from causing a new page.
  
  
• Use a rectangle around the subreport
  Place the subreport in a rectangle, then apply the visibility expression to the rectangle rather than to the subreport or line. This can sometimes manage space better.
  
  

• Check page breaks
  Ensure that:

  • There are no page breaks defined on the row or table.

  • The sub-report does not have any before/after page breaks in its properties.
    
    

Please feel free to give a kudo and mark this as the answer if it helped you.

Have a nice day,

Vivien