Crystal Reports 2008 Sub Report Suppression

Posted on 2009-12-16
Last Modified: 2012-05-08
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.


Question by:nobile00
    LVL 4

    Expert Comment

    I assume you have set suppress blank section etc in the sub report as well as the main report??
    LVL 34

    Accepted Solution

    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.

    LVL 100

    Assisted Solution

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


    Author Closing Comment

    Thanks for the input all is now working correctly.

    Thanks again!  Sorry for the delay in responding.
    LVL 34

    Expert Comment

    You're welcome.  Glad I could help.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now