Creating paginated report where each page is a month in the range selected

  • 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

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Can you give some sample data and expected layout

    You may want to use a datetable in your dataset so that every day of the months is in your dataset on what you can tack on your grouping

    https://www.mssqltips.com/sqlservertip/4054/creating-a-date-dimension-or-calendar-table-in-sql-server/

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply