1

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.

interkey
  • 355
  • 5
  • 21

2 Answers2

0

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.

C Bell
  • 347
  • 1
  • 8
  • Hi Sir. It is correctly aligned. The day numbers are properly aligned, (May 2017). As shown in the picture, May 1, 2017 is aligned on monday (which is correct). It's just that when there should be empty spaces on the cell, it gets the number at the bottom part of the cell "May 7, 2017". I don't know why it behaves like that. – interkey May 08 '17 at 00:24
0

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)

interkey
  • 355
  • 5
  • 21