on 03-02-2017 9:27 PM
I have a subReport in the Report Footer section of my main report. I would like this subreport to appear on it's own page if and only if there is data in this subreport.
Currently I have the New Page Before checkbox checked in the Paging section of the Report Footer section. The result of this is I get the subreport to print on it's own page.
What I want to change is the suppressing of the blank page if there is no data to be displayed in the subreport.
Is there a way to write a formula that will check whether there are any records in the subreport from the main report ? I don't appear to have any access to the table being used in the subreport from the main report when I bring up the formula editor
Ian,
Thank you for responding to my question.
I'll give your suggestion a try.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Format Subreport to suppress blank subreport (see Subreport tab of format editor)
In section expert on main report, for section holding SR check suppress blank section.
Ian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.