Forum Discussion
Filtering Column in Paginated Report based on a Word
Hi Vishruti
For the SSRS report, you can add Expression as InStr(Fields!ProjectNames.Value, "Demo") and operator as greater than ">" and add Value as 0.Thanks!
Inogic Professional Service Division
An expert technical extension for your techno-functional business needs
Power Platform/Dynamics 365 CRM
Drop an email at [email protected]
Service: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
Hello Vishruti,
Instead of specifying a filter condition, you can use the visibility functionality.
1. Right click on the box below the column as shown in the below snapshot and go into textbox properties.2. Go into the Visibility tab and select the options as shown in the screenshot.
3. Write the expression as shown below(Replace the field names with the fields present in your dataset)
Expression:
=IIf(InStr(Fields!Project_Name.Value, "Demo")>0, True, False)Hit Ok and run the report, it should work.
Regards,
Sri.
Hello Vishruti,
Instead of specifying a filter condition, you can use the visibility functionality.
1. Right click on the box below the column as shown in the below snapshot and go into textbox properties.
2. Go into the Visibility tab and select the options as shown in the screenshot.
3. Write the expression as shown below(Replace the field names with the fields present in your dataset)
Expression:
=IIf(InStr(Fields!Project_Name.Value, "Demo")>0, True, False)Hit Ok and run the report, it should work.
Regards,
Sri.