how to reset the page number variable sql.pno

From: Laya Li <lli_at_sos.state.tx.us>
Date: 26 Mar 2003 13:36:57 -0800
Message-ID: <6fb217d.0303261336.18e58df4_at_posting.google.com>

Hi everyone,
I have a report that is generated with SQL and SQLPlus commands. I use BREAK and COMPUTE commands. However when I start a new page for the new group by BREAK, I want the page number in the Title to start at 1 again.

I have not found anyway to reset the page number variable (sql.pno) that I use in the Report Title.

Does anyone know a way to do this or possibly suggest another solution?

Laya Received on Wed Mar 26 2003 - 22:36:57 CET

This message: [ Message body ]
Next message: Sybrand Bakker: "Re: Get a DOS variable in Developer 2000(Forms 4.5)"
Previous message: MAL: "SQL Query Question - HELP!"
Next in thread: Laya Li: "Re: how to reset the page number variable sql.pno"
Reply: Laya Li: "Re: how to reset the page number variable sql.pno"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message