Re: Reports 2.0 & PL/SQL question

simonp_at_ix.netcom.com (Simon Paul at Maverick) wrote:

>In Reports 2.0, how would I use PL/SQL in a Format Trigger to
>reference the value for the Logical Page Number and Total Logical
>Pages that reset on an invoice number? The invoice will have multiple
>lines which would wrap to multiple pages, and the entire print job
>would have multiple invoices. The function srw.get_page_num returns
>the current page number of the entire print job, not within the reset
>group.
 

>Rick Baker

Instead of using a trigger, for the fields that have a source of &logical page number and &total number of logical pages, open the field property sheet for each item, click the PAGE NUMBERING button and select the repeating frame that corresponds to each invoice as the RESET AT selection. See pg. 457 of the Oracle Reports Reference Manual Graphical User Interface Version 2.0 for additional help.

I hope this helps. If you need anything else, let me know.

Bill Lusk
Lusk Consulting Services
Houston, TX Received on Thu Apr 11 1996 - 00:00:00 CEST