Which expression should you use?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report.

You create a report parameter named DisplayCol that contains the following properties:

Data Type: Integer Prompt: Display Column Available Values: Non-queried with the following Label/Value pairs:

oYes/1 oNo/0

Default Values: Null

The report parameter is used to control the visibility of the column.

You need to use the appropriate expression in the Hidden property for the column.

Which expression should you use?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report.

You create a report parameter named DisplayCol that contains the following properties:

Data Type: Integer Prompt: Display Column Available Values: Non-queried with the following Label/Value pairs:

oYes/1 oNo/0

Default Values: Null

The report parameter is used to control the visibility of the column.

You need to use the appropriate expression in the Hidden property for the column.

Which expression should you use?

A.
“=Parameters!DisplayCol.Value”

B.
“=Parameters!rc:DisplayCol.Value”

C.
“=Iif(Parameters!DisplayCol.Value=1,False,True)”

D.
“=Iif(Parameters!rc:DisplayCol.Value=1,False,True)”



Leave a Reply 0

Your email address will not be published. Required fields are marked *