Page Total and Grand Total SSRS

[arnoldpinto84]

Hi, I have the foll prob.. I need to create a report which will have an a total at the end of each page followed by a grand total at th end of the report. There are no groupings in the data. i am able to achieve individual totals by placing the sum in the page footer but the prob is that on the last page the page total appears after the grand total... any help appreciated

[pmarfleet]

Haven't tried this myself, but you should be able to toggle the visibility of the page total textbox based on the result of an expression that checks whether the current page number is equal to the total number of pages in the report. If they are equal, hide the textbox. If they are not, show it. Paul

[arnoldpinto84]

Hi, Thanks for the reply...i'm able to do it like that the prob is that if i use that method the i need to keep another hidden field within the report so that i can get the total sum for the column...i was wondering if i could avoid that...bcos in case i have to take sum of more fields then the number of hidden fields will increase