I have trouble regarding expression.
I have a report that has a calendar style. (Screenshot below)
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)
Here is the Design View :
Any solutions or suggestions? Thank you in advance, I will appreciate it very much.
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)