Pagebreaks in SSRS

Posted on 2012-03-19
Last Modified: 2012-04-03
Hi Experts,

I need a page break that will reduce white space at the bottom, but break the end of the group. Right now either I am getting a lot of white space on the report or the group is breaking in the middle.
Question by:December2000
  • 3
  • 3
LVL 40

Assisted Solution

by:Kyle Abrahams
Kyle Abrahams earned 500 total points
ID: 37737633
At the end of the group put in a rectangle and say new page after.

Author Comment

ID: 37738784
Thank you,  I still have a lot of white space.... any ideas?
LVL 40

Expert Comment

by:Kyle Abrahams
ID: 37738900
well a page break is going to leave that white space.  You can not have any breaks and just add some manual lines to the report between groups.  What exactly are your requirements?
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.


Author Comment

ID: 37738916
What would the  manual lines do and how do you use them in this situation?

Author Comment

ID: 37738932
Working on an invoice with several sections/groupings depending on user selection
LVL 40

Accepted Solution

Kyle Abrahams earned 500 total points
ID: 37739065
so you're using the page break for seperation or does the user actually need it?

If you're using a matrix do this:

if you're not, remove the rectangle and then just leave some extra white space at the bottom of the group.  It should automatically space for the next group.

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Concatenating multiple comments into one row 16 46
while loop in html mail format 5 34
SQL Transaction logs 8 11
In or Between 2 0
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now