How to Hide More Than One Duplicate Data Element?

• sing4you

  SSCrazy

  Points: 2984

  More actions

  September 16, 2009 at 11:06 am

  #210826

  I have a table report and I know how to go to a text box and hide duplicates.

  How do I hide duplicates if I only want them hidden if the first 5 columns are duplicates?

  For example I want the report to look like this:

  County City State Name Condition Comments

  Travis Austin TX Bill Smith Symptomatic Comment1

  Comment2

  Edit: I just realized that all the formatting gets lost when messages get posted so this is not a picture of how I want the report to look. What I need is for the duplicate data to be suppressed only if the first 5 data points are duplicates. If one changes, then print them all again.

  Thanks for any help you can give.

• bendy1999

  SSC Eights!

  Points: 942

  More actions

  September 24, 2009 at 7:02 am

  #1057984

  Hi Sing4you

  How about grouping by all fields except comment?

  Please post some sample-data.