We need a way add a WORD style TOC to a report, an ideas out there...?Try a document map.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"mike" <michael.w.i@.gmail.com> wrote in message
news:dbd5909c.0411121733.623da7b3@.posting.google.com...
> We need a way add a WORD style TOC to a report, an ideas out there...?sql
Showing posts with label ideas. Show all posts
Showing posts with label ideas. Show all posts
Friday, March 30, 2012
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
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
Subscribe to:
Posts (Atom)