Alex Rivera | Logout

How do I set the visibility of a text box in SSRS using an expression?

Asked 2011-06-08T13:45:51.823
46

I have a subtotal field for a calculated column that I want to hide when my report has not run yet, because on days with no data, it shows up as NaN on the report.

I have tried two methods, but neither are working. I just don't know what is wrong with the expression.

I tried hiding if my dataset had no rows:

=IIf((CountRows("ScannerStatisticsData")=0),False,True)

I also tried making a calculation:

=iif((fields!Scans.Value / fields!numberOfCases.Value) = 0, False, True)

I also tried checking isnothing on one of the columns in the calculation

=iif(IsNothing(fields!Scans.Value), False, True)

What am I doing wrong?

reporting-services
Edit
Report

1 Answer

0

Visibility of the text box depends on the Hidden Value

As per the below example, if the internal condition satisfies then text box Hidden functionality will be True else if the condition fails then text box Hidden functionality will be False

=IIf((CountRows("ScannerStatisticsData") = 0), True, False)
answered 2013-04-19T12:48:26.003

Your Answer