Toggle column visibility - All columns or just 1 column based on parameter

• htilburgs

  Ten Centuries

  Points: 1117

  More actions

  April 22, 2009 at 9:14 am

  #208656

  Reporting Services 2008:

  I've a report with 3 columns. What I like to do is to toggle the visibility from the columns based on a parameter. Parameter Value can be C1, C2, C3, ALL.

  Showing only 1 column is posible with an expression for Column visibility =NOT(Parameters!P_Dienst.Value="C1") (or C2, or C3)

  But what I like is "ALL Columns" or "C1" (or C2, or C3)

  I've tried =NOT(Parameters!P_Dienst.Value="C1") or =NOT(Parameters!P_Dienst.Value="ALL"), but this results in no data.

  Anybody an idea how to solve this?

• htilburgs

  Ten Centuries

  Points: 1117

  More actions

  April 22, 2009 at 10:56 am

  #982350

  I've found the solution here in an article on SQL ServerCentral.

  I can use =IIF(Parameters!P_Dienst.Value="C1" or Parameters!P_Dienst.Value="ALL", False,True)

  If one of the values is there, then HIDDEN=False (The True value) otherwise HIDDEN=True (The False value)

  So I hope someone else can use this also.