Solved

Pagebreaks in SSRS

Posted on 2012-03-19
6
355 Views
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.
0
Comment
Question by:December2000
[X]
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
6 Comments
 
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.
0
 

Author Comment

by:December2000
ID: 37738784
Thank you,  I still have a lot of white space.... any ideas?
0
 
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?
0
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 

Author Comment

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

Author Comment

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

Accepted Solution

by:
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:

http://msdn.microsoft.com/en-us/library/ms170712.aspx

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.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard 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, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

738 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