Monday, March 26, 2012

Reporting Services rolling sub-total in report

Any ideas on how to add a rolling sub-total within a group of rows? Essentially I want a report to show the sum of one field up to that row.
From http://www.developmentnow.com/g/115_2005_1_0_20_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comJohn,
Try the runningvalue function in SSRS. The 3 parameters for the
function are expression, aggregate function, and scope. You ought to be
able to use this to create a running sum column, either for the report
or within your groups.
-Josh
John Marcus wrote:
> Any ideas on how to add a rolling sub-total within a group of rows? Essentially I want a report to show the sum of one field up to that row.
>
> From http://www.developmentnow.com/g/115_2005_1_0_20_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.comsql

No comments:

Post a Comment