Avatar of 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
Avatar of Tone' Shelby
Tone' Shelby
Flag of United States of America image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Microsoft SQL Server 2005
Microsoft SQL Server 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo