Skip to Content
avatar image
Former Member

How to suppress row if record similar to previous

Hi,

I have searched this forum and various others but I am unable to find the solution I need for my issue.

I have a report that consist of just one report field 'USERID', which is placed within the details section.

This field contains records that are not necessarily duplicated but are related to the previous record. For instance...

USERID

AADMIN

AADUMMY

AAPPLE

AAPPLE1

AAPPLE2

AAPPLE3

AATKIN

AAUSTIN

....

....

....

In this particular scenario I would like like to suppress 'AAPPLE1', 'AAPPLE2', & 'AAPPLE3'.

I would appreciate any assistance with this.

Kind regards

Gary

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 13, 2015 at 11:51 AM

    Hi Gary,

    If two or more rows are related to each other, would the second (or subsequent rows) be suffixed with an incrementing number?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Abhilash Kumar

      That worked perfectly! I did try with the grouping solution but it didn't quite seem to work (more than likely user error). However the second option is exactly what I am after.

      Thank you so much!