With in the paginated report I am trying to display on each new page all the employees that closed in that month in the rows and then the columns the day of the month as well as the day of the week. I have come close with this but end up with a VERY wide report with all the months in the columns. If I currently remove the month from columns then the 1st of the months are on different day so under each 1st of the month I get for instance multiple days but only data in those that correspond to the row month.
How can I get it that each month has all the columns for day of month and day of week for that month only and then the rows show the month name and employee name. I want the data to be a simple Y or N for on time, which I have already calculated in my SLQ Statement.
It seems it really should be simple I just cannot get it to work. Please assist