i want to show page total in all pages which is called running total in crystal report. the output will be like
Page 1
Employee Name Salary
------------- -------
keith 2000
Robin 4000
Mou 3000
Sub Total 9000
Page 2
Employee Name Salary
------------- -------
Markc 1000
Poll 2500
Sam 1500
Sub Total 5000
in this way sub total will come in all page. i am using table and tablix. i got a trick from stackoverflow.com web site to show page total in all pages like
In SSRS 2008, you have the Tablix control. It defaults to a Header row and a Data row. Right-click on the data row, and select Insert Row -> Outside Group - Below. Then you have a footer row that you can add to the same way was in SSRS 2005.
the url is http://stackoverflow.com/questions/1044219/ssrs-adding-a-footer-row-to-a-table-csv-output
please have a look and give me right solution to achieve my output. thanks
To achieve the above subtotal, first you need to break your page in fixed number of rows and for this you need to add a parent group in your tablix. Then goto expression of the that Group property and write the following "=Int((RowNumber(Nothing)-1)/50)"
before pressing ok goto Sorting property of your group and delete the expression there.
Now you fixed your page to 50 Rows per page, just add a Subtotal u described and you will get what you want.
Thanks
Nishant Gauraw
Please mark as Answer, if its help you.
Thanks
Nishant
Marked as answer by Ming Xu - MSFT on Feb 28, 2012 11:40 AM
mou_inn
Participant
780 Points
955 Posts
Show page total in all pages in SSRS
Feb 09, 2012 01:03 PM|LINK
i want to show page total in all pages which is called running total in crystal report. the output will be like
in this way sub total will come in all page. i am using table and tablix. i got a trick from stackoverflow.com web site to show page total in all pages like
In SSRS 2008, you have the Tablix control. It defaults to a Header row and a Data row. Right-click on the data row, and select Insert Row -> Outside Group - Below. Then you have a footer row that you can add to the same way was in SSRS 2005.
the url is http://stackoverflow.com/questions/1044219/ssrs-adding-a-footer-row-to-a-table-csv-output
please have a look and give me right solution to achieve my output. thanks
</div>Nishantg
Participant
1254 Points
277 Posts
Re: Show page total in all pages in SSRS
Feb 10, 2012 06:12 AM|LINK
Hi Mou,
To achieve the above subtotal, first you need to break your page in fixed number of rows and for this you need to add a parent group in your tablix. Then goto expression of the that Group property and write the following "=Int((RowNumber(Nothing)-1)/50)" before pressing ok goto Sorting property of your group and delete the expression there.
Now you fixed your page to 50 Rows per page, just add a Subtotal u described and you will get what you want.
Thanks
Nishant Gauraw
Thanks
Nishant