SUMMARY SQL*ReportWriter seeding &PAGE variable (Repost)

> For those who asked me to summarize, here is a summary as to how I
> initialized page numbering in SQL*ReportWriter. (This has probably been done
> before and there may even be an easier way).

THIS SHOULD BE A LITTLE CLEARER AND MORE SPECIFIC

1. Create a parameter variable "INDEX_PAGE_SEED" which is used to seed the starting page number.
2. Create a field variable "myPAGE" whose source is &PAGE
3. Create a field level variable INDEX_PAGE whose source is "&sql select :INDEX_PAGE_SEED+myPAGE - 1 into :INDEX_PAGE from dual"

> This will properly seed the starting page number and increment appropriately
> in subsequent pages.
Received on Thu Sep 24 1992 - 20:03:37 CEST