My report looks like this
RH
PH
GH1
GH2
GH3 rcvd sold var (var =rcvd-sold)
Details are suppressed completely by defaulat
GF3
GF2
GF1
RF
GH3 is suppressed if var = 0.
I need to suppress GH1 & GH2 if there are no records displayed at GH3. So I used the same condiotion if var at GH2 is 0 then suppress GH2. But this fails in the following example. Lets say,
Country1 (GH1)
Store1 (GH2)
Product1 50 50 0 (suppressed) GH3
product2 50 25 25 (displayed) GH3
product3 25 50 -25 (displayed) GH3
THe var at GH2(store1) is 0 and hence it is not displaying the gh2 (store1) even thought there are 2 records(product 2& 3) displayed at gh3.
What condition can I write in the GH2 suppress formula to supress GH2 only if there are no records at GH3?
Would appreciate any direction.
Thanks