Joined: 07 May 2015
Online Status: Offline
Posts: 1
Topic: Suppress based on total page count Posted: 23 Jun 2015 at 5:38am
I have a subreport with the following layout:
Report Header A
Report Header B
Report Header C
...
...
Report Header S
Group Header 1 (always suppressed)
Detail (suppressed if row count > x)
Group Footer 1 (text "SEE ATTACHED PAGE" - suppressed if row count < x)
Report Footer
Report Headers F thru Q could be blank and will suppress if blank. Because this is a subreport there is not a page footer available.
The number of detail records vary. I will only have 1 group per report and want to be able to make sure the report footer prints on page 1. If the details are too many and force multiple pages I want to display "See Attached Page" in place of the details, which I currently have in my group footer.
I have been able to do this based a row count of details, but would like to make it more dynamic. Is there a way to accomplish this with a total page count?
If total pages > 1 then print the group footer ("See Attached Page") which will then bring my report footer back to page 1 and result in a subreport that is only 1 page.
The details would then print as a secondary subreport so I would need to be able to trigger the print of that subreport from the original report.
Again, I was able to do this based on row counts of the details, but have run into situations where the fixed row count value does not work well.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum