sql server reporting services: Row Numbers for Groups -- sql server reporting services

You're in the

sql server reporting services

group:

Row Numbers for Groups

wbarron
8/25/2005 12:09:03 PM

sql server reporting services:

I am trying to number a group and I am using the following to do so:

=RunningValue(Fields!DBPROJECTID.Value, CountDistinct, Nothing)

However, I have one little problem. How do I clear out the value and start
over? This is what I want my report to look like:

Group 1 Header
1. Group 2 Header
Detail
2. Group 2 Header
Detail
Group 1 Header
1. Group 2 Header
Detail

Instead I get:

Group 1 Header
1. Group 2 Header
Detail
2. Group 2 Header
Detail
Group 1 Header
3. Group 2 Header
Detail

Any suggestions?

Re: Row Numbers for Groups

Robert Bruckner [MSFT]
8/25/2005 6:45:54 PM

Assuming your Group 1 is called "Group1", you can use a RunningValue with an
explicit scope specified:
=RunningValue(Fields!DBPROJECTID.Value, CountDistinct, "Group1")

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: Row Numbers for Groups

wbarron
8/26/2005 4:32:01 AM

Thanks! After I posted, it dawned on me that I needed to specify the scope.
Thanks for the response.

Wendy

[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.

home · blog · groups

Questions? Comments? Contact the dn