Solved

SSRS Report with white space between body and footer

Posted on 2016-11-03
5
36 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
  • 3
  • 2
5 Comments
 
LVL 24

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 24

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

911 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now