Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SSRS Report with white space between body and footer

Posted on 2016-11-03
5
Medium Priority
?
155 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 32

Accepted Solution

by:
Pawan Kumar earned 2000 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 32

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

618 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