SSRS Report with white space between body and footer

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
LeLeBrownAsked:
Who is Participating?
 
Pawan KumarConnect With a Mentor Database ExpertCommented:
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
 
LeLeBrownAuthor Commented:
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
 
Pawan KumarDatabase ExpertCommented:
Could you please provide the screen shot of the report designer -- tablix?
0
 
LeLeBrownAuthor Commented:
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
 
LeLeBrownAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.