Skip to Content
0

Adding a New Page Before a SubReport

Mar 02, 2017 at 09:27 PM

20

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ian Waterman Mar 03, 2017 at 08:51 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Lloyd Levine Mar 09, 2017 at 02:38 PM
0

Ian,

Thank you for responding to my question.

I'll give your suggestion a try.

Share
10 |10000 characters needed characters left characters exceeded