Re: reports page numbering
Date: Wed, 1 Aug 2001 12:09:09 +0100
Message-ID: <3b681252$1_at_news.norweb.net>
Richard,
Thanks very much for getting back to me. Your understanding of the report was spot on re the groups/frames.
[Quoted] I tried your suggestions, but the report didn't run. I got "rep 1212 object "margin" is not fully enclosed by it's enclosing object "cf_tot_net_payment". This confuses me because cf_tot_net_payment is a formula column I do not have a layout object called this so what does it think it's supposed to be enclosed by ?
[Quoted] In the past when I've done reports where drawing the layout takes up more than a single page height or width I've always had to set the max horizontal panels and max vertical panels to reflect how many pages my layout drawing takes up. If these figures haven't been set in this way I've always gotten these Rep 1212 errors. Until now though the page numbering has never had to be reset by group so I've gotten away with it. That's my reasoning for putting in the vertical panels = 2 property. Is there a way around this that I'm missing ?
Any more suggestions very welcome
Jacqui
"Richard Senior" <richard_at_milldam.com> wrote in message
news:9k8c49$r70$1_at_gate.local...
> 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
> > 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
> > is two physical pages long, the page numbers come out as "page 0 of 1"
and
> > "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---------------+>
> | G_1 | --> v Cover Slip |
+-----+ | |
> | | |
+-----+ | +-R_2-----------+ |
> | 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 - 13:09:09 CEST