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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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?
ClickHouse in a General Analytical Workload

We have mentioned ClickHouse in some recent posts, where it showed excellent results.

In this article on Experts Exchange, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.


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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

623 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