Re: SUMMARY SQL*ReportWriter seeding &PAGE variable

In article <1992Sep17.152316.2690_at_deepthought.uucp> Neil Greene <deepthought!neil_at_ms.uky.edu> 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 
	dual

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