Suppressing blank subreports.

[jimmyt]

I'm fairly new to Crystal.<br><br>I have a report with 5+ subreports. I would like to suppress the subreport entirely if it does not have records to print.<br><br>Currently when I print the report the text field titles from the sub reports print even though the select statement in the subreport returned 0 records. I tried &quot;Suppress Blank Section&quot; in both the subreport sections the section of the main report that the subreport is called from, but this didn't help.<br><br>Any ideas? <br>Thanks<br>Jim

 

[LindaC]

You can select your subreport on the main report and then right click.&nbsp;&nbsp;Select Format Subreport.&nbsp;&nbsp;Under to 'Common' Tab there is 'Supress'.&nbsp;&nbsp;There is a spot to enter a formula to selectivly supress the subreport. <p>LindaC<br><a href=mailto:lcastner@co.orange.ny.us>lcastner@co.orange.ny.us</a><br><a href= > </a><br>

 

[jimmyt]

I am familiar with the Suppress options, but what should the formula do/compare/calculate?<br><br>Thanks<br>Jim

 

[jflmeing]

Did you ever get a response to this? Or have you figured this out? I am trying to do the same thing.

Thank you,
Jennifer

 

[jimmyt]

I worked around it.

I put each subreport in it's own section in the main report. Then removed the report/page titles from the subreports, just leaving the data. In the main report I checked the suppress blank section option. When the subreport returns zero records, nothing is printed.

good luck,
jim