CODEWITHSUNDEEP
reporting-servicesaxaptadynamics-ax-2012ssrs-2012
AYETY
AYETY

Reputation: 710

SSRS report total fields

How to show the total of each page in SSRS report. What I exactly mean is if pageNumber = 1 total should be sum of amount on page 1, if pageNumber = 2 total should be sum of amount of page 2 + total from page 1, etc...

Upvotes: 0

Views: 496

Answers (1)

Ewan
Ewan

Reputation: 1087

.Have you tried using the running value function?

See https://msdn.microsoft.com/en-us/library/ms159136.aspx

You can also use ReportItems![CellName] to enable you to display the value in the report footer if required.

If this does not give what you require and you have a fixed page size eg A4 you can calculate the page totals and Page Numbers as a fields in your data set. This is more powerfull in settings where for example you want to print a set of customer statements in a single print run. Each customer statement would need its own page numbers and totals. Again you can use ReportItems to display these values in the relevant part of the report as they would appear at the detail level of the dataset. In this case you add a hidden field(s) containing the values you require on the detail line and pick them up using ReportItems. You can also force a page break at the end of each Page number group

To repeat the report Header / Footer on each page see this link http://bhushan.extreme-advice.com/repeat-table-header-on-each-page-in-ssrs/. To start with go to the footer properties and make sure repeat on first and last page is checked.

Upvotes: 1

Related Questions