Sonia Bowditch
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!Field 3) = Fields!Field3 AND Previous(Fields!Field1) LIKE Fields2,true,false)
Thanks,
InfoSec36
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!Field
Thanks,
InfoSec36
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER