hi, http://myspeakonbi.blogspot.com/2011/07/running-total-at-page-footer.html Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/

Sir, I have a different scenario. I have a report which can have any number of page and any number or rows on one page. what i need to do is show page total at the end of the page and group total in the end. the scenario is like this: 1. Page 1 will contain the sum of column in page 1 2.Page 2 will contain the sum of page1+page2 and so on till the end of the group, and when the group ends it will automatically show the group total. is there any way to do that? i found a lot of pages showing how to show the page total but none of them were much of help.pls help me. chitra

Here is a link that talks about what you are trying to do http://www.ssrstips.com/carried-forward-page-totals Hope it helps