Eliminating consecutive values in a report for 1 scenario

building reports crystal reports
1

Consider this scenario

userid eventtype

1 click
1 action
3 click
3 click
4 click

I need to design a report in such a way that any user id which has eventype click followed by action should be supressed

and remaining eventtypes other than that should be considered

rollings007 :poland: (BOB member since 2007-02-15)

2

Try to supress the details section using this formula


{Supress.EventType}="Action" and Previous({Supress.EventType}) = "Click"

cyberdude :india: (BOB member since 2007-02-05)