sql server reporting services: RowNumber reset at start of each grouping -- sql server reporting services

RowNumber reset at start of each grouping

Colin
8/16/2006 12:13:13 PM

sql server reporting services:

I'm creating a report where I'd like to list out the lines of the report. I
deceided to use RowNumber function but it is keeping a running total when I
use it like this: RowNumber(Nothing)

I used the report wizard to create a report and used the page grouping to
seperate pages by "team". How do I find the scope to tell RowNumber to
startover for each team?

Colin

RE: RowNumber reset at start of each grouping

Jim
8/16/2006 8:15:01 PM

You can set the scope of RowNumber by replacing Nothing with the name of the
group where you want the reset to occur. If your group name is Team then you
would use RowNumber("Team").

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