Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Pagebreaks in SSRS

Posted on 2012-03-19
6
Medium Priority
?
361 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
  • 3
  • 3
6 Comments
 
LVL 41

Assisted Solution

by:Kyle Abrahams
Kyle Abrahams earned 1500 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 41

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
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 

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 41

Accepted Solution

by:
Kyle Abrahams earned 1500 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

886 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