Reset Page count or use distinctcount() for page number

Question

Reset Page count or use distinctcount() for page number

sol

SSCrazy

Points: 2294
More actions
September 21, 2005 at 12:46 pm

#165333

I have a 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 know how to do this with Crystal, but am trying to figure it out here with either a page count formula, or some type of distinct count().
Thanks!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Dave Klug SSCertifiable Points: 5811 More actions · Answer 1

MSRS does not currently support this unfortunately. To get around this, I've set a cursor in the 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.

it's not as elegant as I'd like but works until MS puts this into a build.

sol SSCrazy Points: 2294 More actions · Answer 2

David,

Can you send me an example?

I tried yesterday to play with fields from the dataset, but I guess MSRS doesn't allow data fields in the report footers.

Thanks!

sol SSCrazy Points: 2294 More actions · Answer 3

This is what I've tried so far, but it resets on every page.

So, each page is 1 even if the Unique ID spans 2-3 pages.

I only need it to reset on a new field grouping of the list object.

Here's the VB code for the report:

Shared offset As Integer

Public Function GetPN(reset As Boolean, pagenumber As Integer) As Integer

If reset

offset = pagenumber - 1

End If

Return pagenumber - offset

End Function

***************************

In the header, I have a textbox named "tag"

In the footer, I've got the following expression:

="Unique ID Page: " & Code.GetPN(Not(ReportItems!tag.Value Is Nothing),Globals!PageNumber)

sol SSCrazy Points: 2294 More actions · Answer 4

My fault...I had the textbox "tag" in the page header and not in the list object itself.

It works!

Thanks!