Showing posts with label ideas. Show all posts
Showing posts with label ideas. Show all posts

Friday, March 30, 2012

reporting services TOC

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

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