sql server reporting services: Grouping and summing -- sql server reporting services

Grouping and summing

Fab
10/30/2006 7:49:57 AM

sql server reporting services: HI,

I have a group on two fields (ie SalesPersonId and CustomerID). I want
to print a total after any of this values change (ie. If CustomerId
changes, a total line for the customerID will be printed but not for
the SalesPersonId). How Can I do it with running values ?

Best regards

Re: Grouping and summing

Topher
10/30/2006 2:30:58 PM

=runningvalue(sum, Fields!xxx.value, "CustomerID")

where "CustomerID" is the name for your customer group. I would make
sure to name your group something other than "table1_Group1" for
clarification purposes.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.