Matrix Groups and Sums -- sql server reporting services

Darryl
3/4/2005 11:25:04 AM

I have what I thought was a pretty simple report, but have encountered two
issues.

I have three groups in this report.

1. When using sum on my detail row I am getting what appears to be a running
total in one of the columns. When I don't use sum then I get either the first
or last value for a detail record.

2. When using groups, the results are not what I would expect. It seems
almost impossible to get the grouping I would like. If I want to total on the
first group and then the second group and then a final total for all the
groups I can't. Am I missing something as this seems like it should be a
trivial effort.

If anybody can help I would appreciate it.
--

Wayne Snyder
3/4/2005 2:36:43 PM

Use Fields!fieldname.value (sounds like you are getting sum, first, and
last)... do not use a function at all..

Look at the sum documentation,, there is an additional parameter which
allows you to set the scope, Use a group name there and see if that helps...

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

[quoted text, click to view]

sql server reporting services : Matrix Groups and Sums