SQL Reporting Services Problem (SSRS)

[arnoldpinto84]

Can any one tell me if it is possible to get the page total in the body section of a report....not the footer...thanks in advance

[Mycroft Holmes]

I think you'll find that the page total is only produced AFTER the page is rendered therefore it is not available inside the actual page. Having said that I beleive you can assign it a variable and access the var from withing the page, this will reflect the current page - 1. Kludge but we have used it.

Never underestimate the power of human stupidity RAH

[arnoldpinto84]

The problem for me is not calculating the pg total. The main problem is that if the table is spanning multiple pages then how do i get a report item to appear on each page below the table so that i can display the total without using the page footer. i cant use the table footer and cause it to repeat on every page because the table footer is processed only once at the end of the table