Nav report rdlc hide data

paulolemungai

I have a nav report with a data item called code I want to hide some values populated from this data item only to have distinct ones.
As per the picture all the values come from data item called code i.e ADV-BONUS1','ADV-BONUS2','ADV-BONUS3','ADV-BONUS4','ADV-BONUS5','ADV-BONUS6 how can I hide them plus discription and the amounts they have.

Eroni

You can do it in many ways,
Use the row visibility, write IIF expression with your data which you want to hide, or I prefer a global variable with type boolean, and to write code on OnAfterGetRecord trigger to return true or false and then the boolean variable put on row visibility expression.