SSRS Report fixed row position

[KatyM (Katy)]

I have an invoice originally created in crystal reports that I am trying to convert into SSRS.

With the crystal report the invoice totals have always been in a footer at bottom of the report in a fixed position.

I’m having issues replicating this in SSRS. If I add the totals to the footer, when the invoice is mass printed it will only show the total for the last invoice.

Then if I add the total to a row or footer on the table in the body then the row is unable to be in a fixed position at the bottom. It will appear after the last invoice line row, which depending on the amount of rows in the invoice could be in the middle of the page.

Does anyone have any solution to displaying the invoice totals at the bottom of the report in a fixed position?

[kananga (John K)]

Have you tried popping a table into a footer? It’s been a really long time since I’ve done this in particular and my memory’s fuzzy, but you might need to conditionally hide it if you have multiple pages and only want that on the last page.