Link to home
Start Free TrialLog in
Avatar of PatrickK_W
PatrickK_WFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SSRS Pin Total row in a tablix to the bottom of a page

I am creating an rdcl file with a tablix to produce an invoice and the customer has requested that the total line appear at the bottom of the page rather than after the last line of data.  

I have seen some examples online of how to do this, for example by  calculation the height of the tablix from the number of rows and adding blank lines ,  but none that specifically meet my needs. Each invoice would have various number of row and no limit to the number of rows so the tablix could potentially spread over a number of pages (the total should appear at the bottom of the last page) . And the description of the item might increase the size of a row so each row could have various heights.  So I would not be able to calculate the size.

Are there other ways other than those I have already looked into as tho how can make the total of a tablix appear at the bottom of the last page of rows?
ASKER CERTIFIED SOLUTION
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of PatrickK_W

ASKER

Thank you Brian. This is perfect. I was obviously over complicating the issue.

Your help is very much appreciated.