Link to home
Start Free TrialLog in
Avatar of Sonia Bowditch
Sonia BowditchFlag for Guernsey

asked on

Supress rows in SSRS table based on Like or Soundex

I had this question after viewing Suppressing duplicate data in SSRS.

I found the post extremely helpful as I was able to supress rows if the field matched the previous field.  I have been asked to add further suppression on two fields but they are not exactly the same as one contains a space.

The two fields are:

Field1 - 12345
Field2 - 12 345

I am not exactly sure how I can handle the differences.  I would like to put a Soundex on this field:

=IIF(Previous(Fields!Field3) = Fields!Field3 AND Previous(Fields!Field1) LIKE Fields2,true,false)

Thanks,
InfoSec36
ASKER CERTIFIED SOLUTION
Avatar of Chris Luttrell
Chris Luttrell
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sonia Bowditch

ASKER

Thanks Chris.