Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

How to insert a page break on a matrix type report

Avatar of itatahh
itatahh asked on
DB Reporting ToolsMicrosoft SQL Server 2005
1 Comment1 Solution907 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Avatar of Tone' Shelby
Tone' ShelbyFlag of United States of America imageMicrosoft® Power BI, Power Apps & O365 Design, Development

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answers