Description:-
Here we will see about how to
enable/disable column visibility in ssrs report. Here I have given sample
demonstration to enable/disable column visibility in ssrs report.
For example:-
In your table contain one Boolean
fields and you have set Boolean parameter for enable/disable column, so based
on that parameter and fields value you can enable/disable column visibility in
ssrs report.
While inserting data into your
table you have set Boolean fields value by default “No”
You have to set Column visibility
Expression on SSRS Report like below.
=IIF(TableFields
= ParameterField,True,False)
Select the column which one you
have to Enable/Disable in SSRS Report and set the Expression.
Thanks for comments.....