Crystal Reports - Hide section if Subreport has no records

Posted on 2011-10-10
Last Modified: 2012-06-27
I have a Crystal report in VS2008 which has a sub-report. If the sub-report has no records I want to suppress the section that it is in.

Question by:etsellinc
    LVL 19

    Accepted Solution

    I don't use VS 2008 but here is the method I would use in CR XI

    In the subreport  -

    conditionally suppress all sections if no records are returned

    In main report -
    format subreport -> subreport tab -> suppress blank subreport
    go to selection expert -> check 'suppress blank section' for section containing the subreport


    Author Closing Comment

    Thanks very much. Works like a charm!


    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    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. …
    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    746 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

    15 Experts available now in Live!

    Get 1:1 Help Now