Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
ON PAGE Command
Collapse the table of content
Expand the table of content

ON PAGE Command

Specifies a command that executes when printed output reaches a specified line number in a report or when you issue EJECT PAGE.


ON PAGE   [AT LINE nLineNumber [Command]]

Parameters

AT LINE nLineNumber [Command]

Specifies the command to execute at the designated line number. The specified command executes when _PLINENO, the system variable that keeps track of the current line number in a report, becomes greater than the line number specified with nLineNumber. The command specified with ON PAGE also executes when you issue EJECT PAGE. For more information, see EJECT PAGE Command.

ON PAGE typically uses DO to execute a procedure for handling page breaks, headers, and footers.

Executing ON PAGE without the AT LINE clause clears the ON PAGE command.

Community Additions

ADD
Show:
© 2015 Microsoft