Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 05, 2008 at 07:38 PM

    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( )

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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