Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:01 PM
Points: 13,720, Visits: 10,675
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 LessThanDot.

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

Add to briefcase

Permissions Expand / Collapse