Hide/Show a column based on enum parameter in an SSRS Report

(0) Share

Report

Posted on by skd

390

Hey team,

I want to hide a column based on the Parameter value. The Parameter name is "ReportLevel" which is an enum with values "Customer" ,"Project", "Estimate". If the Parameter selected value = "Customer" then hide the ProjectId and Project Name field.

I used this expression the column visibility expression of ProjectId , but every time I use write this expression in the column visibility the report gets deployed but I get an error on my front end "Something went wrong while generating the report. Please try again." and when I remove this condition it works normally. Please can you help me resolve this issue. I want to hide the column based on the selected parameter

=iif(Parameters!ProjectEstimateMain_Report_Level.Value=0,false,true)

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

huijij 19,811 on at

Like (0)

Report

Hi skd,

Did you try this expression: =IIF(Parameters!ProjectEstimateMain_Report_Level.Value="Customer",false,true)

regards

Was this reply helpful? Yes No
skd 390 on at

Like (0)

Report

Yes, I tried but there is no change it does not hide the column.

Was this reply helpful? Yes No
skd 390 on at

Like (0)

Report

HEy Judy Jee,

It started working. Thank you!!!

Was this reply helpful? Yes No
huijij 19,811 on at

Like (0)

Report

Hi skd,

You're welcome!! Have a nice day!!!

regards

Was this reply helpful? Yes No