Re: SUMMARY SQL*ReportWriter seeding &PAGE variable

From: Neil Greene <deepthought!>
Date: Thu, 17 Sep 1992 16:41:42 GMT
Message-ID: <1992Sep17.164142.3352_at_deepthought.uucp>

In article <1992Sep17.152316.2690_at_deepthought.uucp> Neil Greene <deepthought!> writes:
> [stuff deleted]

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).

  1. Create a parameter variable to see the page number.
  2. Create a FIELD_1 whose source is &PAGE
  3. Create a FIED_2 whose source is:
	&sql select :PARAMETER_VARIABLE + :FIELD_VARIABLE-1 into FIELD_2 from 

This will properly seed the starting page number and increment appropriately in subsequent pages. Received on Thu Sep 17 1992 - 18:41:42 CEST

Original text of this message