Skip to Content

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

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

Former Member
replied

Another way to do this is to go to the Section Expert > highlight the details section > Click the formula button beside 'Suppress' and use this code:

stringvar s := {UserID};

Replace(s, totext(val(StrReverse(s)),0,""),"") = Replace(Previous({UserID}), totext(val(StrReverse(Previous({UserID}))),0,""),"")

-Abhilash

2 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question