sqlreporting-servicesssrs-2008visibilitysqlreportingservice

SSRS - Expression not working after putting Subreport


I have trouble regarding expression.

I have a report that has a calendar style. (Screenshot below) enter image description here

I have an expression on the Day Number on the top left of the calendar cell, and it works (Which is in the top box). Here is the expression :

=IIf(IsNothing(Fields!DayNumberOfMonth.Value), " ", Fields!DayNumberOfMonth.Value)

But when I added my sub-report which returns the list of employees and their schedule per date, the Expression is not working anymore. Some random number appears on the top left of the box, which is supposed to be blank. (Screenshot below)

enter image description here

Here is the Design View :

enter image description here

Any solutions or suggestions? Thank you in advance, I will appreciate it very much.


Solution

  • I figured it out. I set the visibility to "Show or hide based on an expression, then set the expression to : =IIf(IsNothing(Fields!empName.Value), True, False)