SSRS Report with white space between body and footer
Posted on 2016-11-03
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.