Hide table column Dynamically in SQL Server Reporting Services (SSRS)

Quite Straight forward:

Select the Column , Right Click -> Propoerties OR hit F4
Visibility -> Hidden -> Expression i.e. Click on Hidden under Visibility and select Expression from Drop Down
Write the expression e,g.

=IIF(Parameters!MonthlyOrYearly.Value.Equals("Monthly"),false,true)

Share This Post:
Short Url: http://wblo.gs/YuX

posted on Wednesday, August 19, 2009 4:10 PM

Feedback

# re: Hide table column Dynamically in SQL Server Reporting Services (SSRS) 10/27/2009 9:17 PM Mayur

Yes i got. Thanq very much Ahmad.

# re: Hide table column Dynamically in SQL Server Reporting Services (SSRS) 10/20/2011 8:48 AM anitha

thanks a lot dear really good idea.... but the col color is white as the column is based on groupby... and i want the color to be in blue !!!! can you tell me how

faizan ahmad

News

Archives

Post Categories

.NET

ASP.NET

Feedback