Last post Apr 12, 2011 01:10 PM by codemihir1
Apr 08, 2011 08:22 AM|asma_wakeel|LINK
Hi, I have an rdlc file that has some text boxes. I have a flag value in my dataset. I want to check that flag if it is 1 then show the text box and if it is 0 then hide the text box. Any ideas??
Apr 12, 2011 01:10 PM|codemihir1|LINK
Right click on TextBox -> Text Box Properties --> Visibility -> radio button Show or hide based on an expression
You can show and hide items in a report using the visibility properties for the report item. In a data region such as a table, you can initially hide detail rows based on the value in an expression.
The following expression, when used for initial visibility of detail rows in a group, shows the detail rows for all sales exceeding 90 percent in the PctQuotafield:
=Iif(Fields!PctQuota.Value>.9, False, True)
The following expression, when set in the Hidden property of a table, shows the table only if it has more than 12 rows:
The following expression, when set in the Hidden property of a column, shows the column only if the field exists in the report dataset after the data is retrieved from the data source:
=IIF(Fields!Column_1.IsMissing, true, false)
see link for more info: http://msdn.microsoft.com/en-us/library/ms157328.aspx