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

DB Reporting ToolsMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
Tone' Shelby

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Tone' Shelby

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23