Topic: Suppress a section based on suppression of followi Posted: 01 May 2018 at 8:46am
I have the following group setup.
GH#2a Contains lines and text as a title for Special Notes
GH#2b Contains subreport for PO Notes
GH#2c Contains subreport for Supplier Notes
Both GH#2b and GH#2c are set to “Suppress Blank Section”.
I need to be able to Suppress Section GH#2a when both GH#2b and GH#2c are suppressed.
Is this possible to do?
How do I build the Suppression Formula for this?
Thank you for any assistance you can provide.
-Kristen Lott
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 02 May 2018 at 3:22am
you would likely need to create 3 other group headers above these GHs where you execute your two sub-reports and return shared variable of a count of records from the sub reports and use that to conditionally suppress what you now think of as GH2a. This of course is very resource intensive forcing you to double up on all the sub report executions.
Thank you for the response. I was hoping it would be something a bit more simplistic.
Need to find out just how important it is that the title doesn't show if there are no notes.
Thanks again.
-Kristen Lott
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 02 May 2018 at 6:24am
with the sub reports it tends to get a little more difficult. values from sub reports can not be queried in the main report and if you pass a shared variable back to the main report to use in a query it can only be used in sections below/after where it is returned to.
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
IP Logged
