Suppress Items in Main Report-no records in SubRep
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22612
Printed Date: 02 May 2024 at 10:30pm
Topic: Suppress Items in Main Report-no records in SubRep
Posted By: msaeva
Subject: Suppress Items in Main Report-no records in SubRep
Date Posted: 31 May 2018 at 5:26am
Hello,
I've designed a report that pulls inventory data in the main report based on current orders delivery dates. In addition, there's a sub-report that pulls item's quantities from six different warehouses.
I've include a shared numbervar to pass the total w/h qty from the sub to the main. My idea was to suppress items on the main report where the sub-report total qty = 0.
Unfortunately, the main report has items included where the S/R total qty is equal to zero.
This is my 1st post, so I apologize in advance if important information to resolve is missing.
|
Replies:
Posted By: DBlank
Date Posted: 31 May 2018 at 7:09am
Shared variables passing to and from sub reports to main reports must evaluate after the sub report (E.g. Group footer a has the sub report and group footer b has the shared variable result)
Variable formula results cannot suppress items that are 'above' them in the report, so if you want a whole group suppressed you have to run the sub report in the GH1a and the result in GH1b and then you can suppress GH1c and below.
Suppressed sub reports don't execute so if you want to suppress GH!a anf GH1b you have to suppress all the items in the subreport and set GH1a to suppress if blank. Same for GH1b.
|
Posted By: msaeva
Date Posted: 31 May 2018 at 7:50am
DBlank,
Thank you for the information.
I'll reformat as you've suggested and let you know the outcome.
|
|