SQL Server Performance

Visibility controlled by parameter value

Discussion in 'SQL Server Reporting Services' started by jwong008, Jun 25, 2006.

  1. jwong008 New Member

    I try to put this expression but it comes out error: Before I input the hidden expression, the report works fine.

    =iif((Parameters!policy.Value)='2005',true,false)

    error msg:

    1. The hidden expression for the textbox contains an error: [BC30201] Expression expected
    2. The value expression for the textbox contains en error: Input string was not in a correct format

    please help
  2. smy New Member

    Place this at the textbox properties (Visibility -> Hidden and select Expression)

    =iif(Parameters!policy.Value="2005", true, false)


    On the textbox itself, right click Expression and place this in:

    =Parameters!policy.Value


    you can then test it out.
    In this case, if you enter 2005 on the Policy parameter, the textbox will be hidden, else will show.
  3. jwong008 New Member

Share This Page