Re: reports page numbering

From: Richard Senior <richard_at_milldam.com>
Date: 1 Aug 2001 07:46:17 GMT
Message-ID: <9k8c49$r70$1_at_gate.local>


[Quoted] [Quoted] In article <3b66b5d0$1_at_news.norweb.net>,

        "Jacqui" <Jacqui.Spencer_at_its.lancscc.gov.uk> writes:

> I have a report where the logical page size is two panels long.
> The first panel (always one physical page) is a returnable slip and the
> second panel contains lots of repeating groups detailing payments and can
> spread to many physical pages.
> There is a repeating group (R1) spanning the whole logical page, this is the
> top group of the report. The report has a body section and margin only,
> no header or trailer. In the report properties max horizontal panels = 1
[Quoted] [Quoted] > and max vertical panels = 2. I'm using reports v3.

Are you sure you need logical pages?

> I want to number the pages in a "page # of # " fashion and reset the
> counting at R1.

<snip>

> This seems to work fine for every instance of the repeating frame, except
> the first one. In an example where the first instance of the repeating group [Quoted]
> is two physical pages long, the page numbers come out as "page 0 of 1" and
[Quoted] [Quoted] > "page 1 of 1". On subsequent groups the page numbers are correct though.

<snip>

If I understand correctly you have what is essentially a master-detail report, with the cover slip being the master and the backup material the detail. You want to have the cover slip on its own physical page and the related detail starting on the next page? Each group of cover-slip and detail should be numbered as a separate report?

I see this as a simple master-detail structure:

DATA MODEL LAYOUT MODEL

+-----+         
|  Q  |        

 +-----+
   |
 +-----+         +-R_1---------------+
[Quoted] [Quoted] | G_1 |   -->   v    Cover Slip     |
 +-----+         |                   |
   |            |                   |
 +-----+         | +-R_2-----------+ |
[Quoted] [Quoted] | G_2 |   -->   | v    Detail     | |
+-----+         | +---------------+ | 
                +-------------------+

To get the result you require, I think you need these properties, but stick with 1 physical page = 1 logical page:

R_1: Max Records Per Page = 1, Vertical Elasticity = Variable R_2: Page Break Before = Yes
Page Numbering Fields: Reset at G_1, use &Page Number and &Total Pages

Let me know if this works. I may have missed the reason behind logical pages ...

-- 
Regards,

Richard Senior
Mill Dam Consulting Ltd, London
Oracle Consulting & Training
Received on Wed Aug 01 2001 - 09:46:17 CEST

Original text of this message