Re: reports page numbering

In article <3b681252$1_at_news.norweb.net>,

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

> 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 ?

I've had strange messages of this type too -- I've even had it referring to objects in another report! I think it occurs when a layout object straddles the boundary of a page and therefore the margin.

> 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 ?

Again, I may not have fully understood your layout but I still don't think you need logical pages. I am going to email you a simple report for the scott/tiger schema that simulates what I think you are trying to do. Briefly, the trick is to draw your cover slip covering the whole of the first page body, draw your repeating detail frame on a second page (avoiding straddling the page boundary) and have a collapsing anchor from the detail frame to a frame surrounding the cover slip.

Going back to the page numbering on logical pages though, I think it is a bug to report to Oracle Support. When you ask a page number to be reset at a repeating group, it doesn't seem to define the physical page number at all until the first instance of the repeating frame associated with the group is formatted.

-- 
Regards,

Richard Senior
Mill Dam Consulting Ltd, London
Oracle Consulting & Training