Showing posts with label sum. Show all posts
Showing posts with label sum. Show all posts

Wednesday, March 7, 2012

my value doesnt reset when i used sum(field, scope)

pls help what seems to be the problem? my sum doesnt restart as the group changes. instead it accumulates the sum? thanks.

use

RunningValue(Fields, Sum, scope)

my value doesnt reset when i used sum(field, scope)

pls help what seems to be the problem? my sum doesnt restart as the group changes. instead it accumulates the sum? thanks.

use

RunningValue(Fields, Sum, scope)

My store procedure returns 2 grids HELP

How do I access the 2nd grid/table in my report?
Basically I have a SP that has a SUM in one grid. The second grid
cotains the data I want to display in RS. Is there a way to get to the
2nd grid without altering the store procedure(Its being used on another
report)?
regards,
Stas K.I just found a similar topic where it says I cannot do this.
Any ideas?|||No, RS can only take a single resultset.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1136923749.664965.81380@.z14g2000cwz.googlegroups.com...
> How do I access the 2nd grid/table in my report?
> Basically I have a SP that has a SUM in one grid. The second grid
> cotains the data I want to display in RS. Is there a way to get to the
> 2nd grid without altering the store procedure(Its being used on another
> report)?
> regards,
> Stas K.
>