Trying to suppress section based off of a subreport
Posted on 2013-08-28
I have been working on a report and i am stumped at the moment. The report is a report for purchasing and each page is an overview of a part number that they would need to go buy for. If the inventory level is above 0 for all requirements on the books I want to suppress these pages and only show the pages that the purchasing team needs to go and buy.
I have to rely on a sub-report and shared variables to do the suppression because I have to use summaries to get the data so using the selection expert is out of the question. I have attached the report definition file for your reference.
The sections in the report I am utilizing are below. If something isn't included it is suppressed.
Page Header A, Page Header B, Group #1 (Headers 1a-1b, Footers 1a-1e), and the Report Footer.
The sub-report is located in Page Header A and only one shared variable is being passed to the main report from this sub-report. I have put the formula for the shared variable in Page Header B and it is returning the correct info. Next, I have used the section expert to suppress all the sections in Group #1 (Header 1a, 1b, Footer 1a, 1b, 1c, 1d, 1e) based on the shared variable.
Basically, I can suppress all of the sections in Group 1 except for 1a. If I put the suppression formula in 1a I get a 1 page report when it should be hundreds of pages. In lieu of a fix I have been suppressing the individual fields in Group Header 1a with the same suppression formula successfully. However, when I go to print/export/etc I get a blank pages (the pages I want gone) in between full pages (the pages I want). If I also tick the check box for suppress a blank section for Group Header 1a I get a 1 page report again.
Any help would be much appreciated, thanks!!