PatrickK_W
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Your help is very much appreciated.