[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 674
  • Last Modified:

Crystal Reports 2008 Sub Report Suppression

I have a large report with several sub-reports.  I set all the sub-reports to suppress if blank by doing the following.

Format Sub-report and checked off Suppress Blank Sub-report in the Sub-Report tab.

For the section the sub-report is in I checked off Suppress Blank Section.

Also, I have Suppress Printing of no records checked in Report Options.

With all that done I have one sub-report that still is displaying a blank page.

Is there something else I can do to suppress this subreport if there are no records to display.

Any suggestions will be greatly appreciated.


2 Solutions
I assume you have set suppress blank section etc in the sub report as well as the main report??
Do you have any fields/sections in that subreport that are not suppressed, or maybe are conditionally suppressed and the conditions are not being met?

 If you're trying to use the "Suppress Printing If No Records" option to suppress the subreports, right-click the subreport, select "Edit Subreport", and then check the Report Options.  There are separate Report Options for the main report and each subreport.

ALso verify there is no NEW PAGE BEFORE OR AFTER set for that particular section or in the subreport.

nobile00Author Commented:
Thanks for the input all is now working correctly.

Thanks again!  Sorry for the delay in responding.
You're welcome.  Glad I could help.


Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now