Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to remove repeated entries of Group level details?

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 Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question