I have created a matrix style report that has the columns and rows from the data source. It then has some custom columns that serve a basic purpose of giving them a 7 day period from the date they selected with which they can document some medical client data on a daily basis for that week.
Now they have come to me and asked if I can make it so they can enter a date range and it will print the single sheet for the selected client for all of the weeks the date range covers.
I have replicated the data, on the SQL side - in the view, so every record can have a duplicate for each week they want to print.
Now the problem is that I cannot seem to find a way to get it to page break on the field that identifies the week and then reprint the same data that was on the first page, but with the seven day period covering the next week, and so-on for all of the weeks.
I have no code to enter from the SQL side, since it is giving me the correct data. I could copy or attach the .rdl file contents if that would help.