Skip to Content
author's profile photo Former Member
Former Member

How to suppress report details when the subreport is empty?

Dear all expert,

I had develop a report with a subreport insert in the group footer. But what I wish to do is, when the subreport is empty, the details of the main report is suppress. Kindly please advice.

Thank You.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 29, 2011 at 10:05 AM

    Hi Alex,

    Right Click on subreport and in Format menu option you found a check box(Supress Blank Report) Tick this option.After this save your report and check output.Blank Sub Report will be supress.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member


      If the subreport is placed in the header and if you wish to suppress this section when the subreport is blank, here's what you need to do:

      1) Right-click the subreport and select Format Subreport > Subreport tab > Check Suppress Blank Subreport

      2) Now, go to Section Expert and select the header section that holds the Subreport and check 'Suppress Blank Section


      Deepak Gupta

  • Posted on Dec 29, 2011 at 04:04 PM


    If the Subreport is placed in the Report Footer, you cannot suppress the Details section of the Main Report.

    Can you not place the Subreport on the Group Header? This way you can suppress the Details Section.


    Add a comment
    10|10000 characters needed characters exceeded

    • In the case that you can't put the sub-report in the header and you can only place it in the footer, what I've done is I've recreated the exact same subreport and placed it in the header but supressed all sections. I then tested to see if any records would be found and using shared variables I pass the information back to the main report. You can then suppress the main reports details if no records were found in the sub-report.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.