Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Suppress group header Post Reply Post New Topic
Author Message
rajlan
Newbie
Newbie


Joined: 24 Sep 2007
Online Status: Offline
Posts: 13
Quote rajlan Replybullet Topic: Suppress group header
    Posted: 12 Aug 2008 at 1:35pm

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

IP IP Logged
themessenger
Groupie
Groupie
Avatar

Joined: 15 Aug 2008
Location: United Kingdom
Online Status: Offline
Posts: 48
Quote themessenger Replybullet Posted: 15 Aug 2008 at 3:12am
If I am understanding you correctly - you could create a formula field like:

FORMULA_1
If var <> 0 then 1 else 0

place this on the detail section and hide it

then on the suppress header you could have something like:

if SUM(FORMULA_1) > 0 then false else true


Edited by themessenger - 15 Aug 2008 at 3:13am
Managing Director
www.allmymenus.com
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.016 seconds.