Link to home
Start Free TrialLog in
Avatar of itatahh
itatahh

asked on

How to insert a page break on a matrix type report

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.

Any ideas?
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.

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Tone' Shelby
Tone' Shelby
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial