Solved

SSRS Report with white space between body and footer

Posted on 2016-11-03
5
67 Views
Last Modified: 2016-11-04
I have a SSRS report on which I need total rows. It is grouped on two fields. After the parent(first) group, I need to put the totals. The parent group is Gender and the child group is Job Title. I am counting Race.  I need totals to be shown at the Gender level but the total amounts for Race. I also have to count separately Race for a certain Job Title so I must use an expression for one total row to count only certain job titles. My report will end up with two Total rows. My problem is, if I try to put everything in the body, I can't sum up report items. Aggregate functions can only be in a footer or header. When I put a footer it works in display but when I print the report to PDF, there is a large amount of white space between the body and the footer. I have set the property  to consume the white space to true but it still does not work. How can I use the footer and get rid of the white space in PDF OR work with groups to get my totals in the body? I have thought of making subreports for the totals but wanted to ask for other solutions.

Thanks
0
Comment
Question by:LeLeBrown
[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
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
Pawan Kumar earned 500 total points
ID: 41872629
Try..

The margins have to be the right size. Ex-

Page = 8.5 x 11.....    Right and left margin .5" equals one inch. so the table or body of the report has to be smaller than 7.5" wide.

Also check on your table cells to see if the Text Box data is growing to much.
0
 

Author Comment

by:LeLeBrown
ID: 41874197
Hi. My report is landscape but is within the margins so it should be fine. It is just that the footer goes to the bottom of the page leaving a large white space between the body and the footer. I know the footer belongs at the bottom, but I can't do aggregate functions in the body on report items so I have to use a footer. I have done a total row but I need another total row for specific job titles and that is giving me issues.
0
 
LVL 28

Expert Comment

by:Pawan Kumar
ID: 41874205
Could you please provide the screen shot of the report designer -- tablix?
0
 

Author Comment

by:LeLeBrown
ID: 41874258
I actually got around it by adding an additional total row for my group and adjusted my query to add the fields I needed for that total row.

Thanks
0
 

Author Closing Comment

by:LeLeBrown
ID: 41874259
Thanks
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Suggested Solutions

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

740 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