SQL Server Reporting Reset Page count

[b][red]This message was edited by bubberz at 2005-9-22 9:24:5[/red][/b][hr]
I have a SQL Server RS report that will come back as 20 pages.

What the user wants is on the beginning of another unique ID, which causes a new page to be started, to have the page count restart to 1.

So, if I have 3 UniqueIDs for all 20 pages, and the first, IDAA, is 10 pages long, the second, IDBB, is 4 pages long, and the third, IDCC, is 6 pages long, then the page numbering would be as:
1-10 for IDAA
1-4 for IDBB
1-6 for IDCC

I've been told to set a cursor in a SP that determines what page I'm on and then passses this to the result set as a column. This is then set in a group to control page breaks. How could I do this? I'm not very familiar with SPROC cursors.

I know how to do this scenario in Crystal Reports, but am trying to figure it out here with either a page count formula, or some type of distinct count().


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!