Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Hide columns if Null Expand / Collapse
Posted Wednesday, December 5, 2012 4:54 PM


Group: General Forum Members
Last Login: Tuesday, January 8, 2013 6:31 PM
Points: 10, Visits: 33
I have a report with parameters for 2011 and 2012, if I select 2011 the columns for 2012 are null (Blank)

so should I use. =IIF(Parameter!Year.value = 2012,True,False) or should I check for null and then Hide Column.
Post #1393271
Posted Thursday, December 6, 2012 12:25 AM



Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 15,509, Visits: 13,170
I would put a property on the visibility of the 2012 column that checks the parameter value.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1393349
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse