Dig Me Out (Resetting Report Page Numbers)

re: Dig Me Out (Resetting Report Page Numbers)

JStevens — Mon, 25 Jun 2007 22:02:18 GMT

The report I was working on required that the header for the group be shown for every page. So, after trying everything I said “Let’s group on the row number!” If we know how many rows are on a page we can calculate the page number and force a page break! For example you group by the customer ID and add a second grouping on the row number.

Group 1 Expression

=Fields!CustomerID.Value

Group 2 Expression

=(RowNumber("table1_Group1") - 1) \ 10 + 1

On the group properties set “Page break at end” to True

This gives us 10 records on a page. If we need to display the page number and total number of pages for this group we can use this expression in the group 2 header.

= “Page “ + (RowNumber("table1_Group1") - 1) \ 10 + 1

& " of " &

((Count( Fields!CustomerID.Value, "table1_Group1" )-1) \ 10 + 1)

re: Dig Me Out (Resetting Report Page Numbers)

danny — Thu, 17 May 2007 17:28:25 GMT

Is there a way to do reset the page range? So, if I have three invoices totalling 20 pages, it would be:

Invoice 1: Page x of 10

Invoice 2: Page x of 5

Invoice 3: Page x of 10

So, is there a way to get a total page count for a specific group?

re: Dig Me Out (Resetting Report Page Numbers)

James — Thu, 21 Dec 2006 01:25:04 GMT

This is all fine and wonderful, but I'm getting a blank page printing in front of every subreport - for two subreports which span seven pages, I'm getting seven content pages and two blank ones with page numbers on the bottom.

I know this is caused by the header printing in front of the subreport, but how do you get rid of it? Setting the header row's visibility to false makes the above code not work...

re: Dig Me Out (Resetting Report Page Numbers)

Sher — Fri, 17 Nov 2006 00:37:33 GMT

I have this working mostly in my report with the following exception:

- Body of the report prints but in the group footer there is a sub report that prints the notes. If this goes onto page # 2, the Page header still shows Page # 1.

Any ideas on this one?

Thanks

re: Dig Me Out (Resetting Report Page Numbers)

Tim — Fri, 20 Oct 2006 23:02:25 GMT

"If the same user runs the report more than once at the same time, they’d screw up their page numbers, but that’s probably not worth worrying about."

Running the report and then printing it has the effect of running it twice as the same user without resetting the shared offset. Seems pretty important to me...

re: Dig Me Out (Resetting Report Page Numbers)

muhsin — Tue, 18 Jul 2006 09:40:49 GMT

I want to use the total page count in the report body. Can you help me by writing its vb code or anything else useful? Thanks.

re: Dig Me Out (Resetting Report Page Numbers)

Ravin — Wed, 24 May 2006 18:33:38 GMT

This code gives error at the page header / footer level.
I am using sql 2005 reporting services.
I even used Brian Welcker's Weblog but that also gave error.
Is there any other way to reset the page numbers at the group data level in sql 2005 reporting services. I need for my batch job.

Thanks

re: Dig Me Out (Resetting Report Page Numbers)

CraigZello — Fri, 10 Mar 2006 19:03:36 GMT

Is there anything similiar for resetting page numbers for subreports?

re: Dig Me Out (Resetting Report Page Numbers)

Sher — Tue, 20 Sep 2005 21:51:49 GMT

I can't believe it is this hard. Thanks for this information as I couldn't find out how to do this anywhere.

Now, I need to suppress the footer on every page except for the last page for the group. Any ideas on that one?

Thanks!