Solved

Pagebreaks in SSRS

Posted on 2012-03-19
6
354 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 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
MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

 

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
(sql serv16)ssis 2016 question/check 1 74
TSQL XML Namespaces 7 24
First Max value 3 32
install report service in sccm2012 3 19
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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.

820 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