SSRS - Expression not working after putting Subreport

1
votes

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.

2
sqlreporting-servicesssrs-2008visibilitysqlreportingservice
and if you simply empty the cell that contains the subreport it works again? - Alan Schofield
@AlanSchofield Yes Sir. - interkey

2 Answers

0
votes

Is it possible that your week number from your subreport is not correctly aligning with the main report. It looks like it is using the number 7 from the next Sunday.

0
votes

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)