How to remove repeated entries of Group level details?

[Former Member]

My Crystal reports has three groups and layout is:

GH1

GH2

GH3

Details

GF3

GF2

GF1

I'm listing details under GF3. Is there a way I can control repeated listing of GH1 and GH2 data in different lines?

e.g., my data column is: (zone, Bin, item name) and Zone is first level Group data, second level group data is at Bin level and third group is at item level.

some record are like:

(AZone, A1Bin, item1), (AZone, A1Bin, item2), (AZone, A2Bin, item3), by listing the details (zone, bin, Item) at GF3, my data is printed like this:

AZone A1Bin item1

AZone A1Bin item2

AZone A2Bin item2.

I want to print Zone and Bin level details only when these changes like:

AZone A1Bin item1

item2

A2Bin item3

Any help on how can I achieve this? I don't want to pring Zone or Bin level details in seperate rows, these should appear together as listed above, also for fulfiling other requirements, I need to out data in GF3 section only.

[former_member260594 · Accepted solution]

Neha,

You should be able to suppress the fields when they equal the previous value of that field. An example of the conditional suppression formula would be;

= previous( )

[Former Member · Accepted solution]

Sir, Couldn't get this really how?. I would appriciate if you can give more on details, like what would be the formula and where should I put it really.

[Former Member · Accepted solution]

I tried to place the above mentioned formula under "Format Fields->Common->Suppress check box" and checked this check box for this Zone Object. Nothing is printed on Page. Even first line doesn't print this Zone details. Am I missing something?

[Former Member · Accepted solution]

on that Common Tab it also has "Suppress if Duplicated",

however, you would be far better off to work this out by tweaking

the query (if you can) with joins and filters.

Hope this helps,

The Panda