Format commands in SQR Poeplesoft


Format commands in SQR Poeplesoft



Most common Format commands in SQR:

CENTER: Center text
EDIT: uses masks to control the format of the output
FILL: fills the specified length with characters specified.
ON-BREAK: Allow you to specify an action/procedure in tabular reports when break occurs in the value of the field.
BEGIN-SETUP includes following commands:
Ask: Prompts the user for substitution variable.
BEGIN-SQL: Begins an SQL paragraph.
CREATE-ARRAY: Creates an array of fields to store and process data
DECLARE-CHART: Defines attributes of a chart.
DECLARE-IMAGE: Defines the type, size and source of an image.
DECLARE-LAYOUT: Defines attributes of a report layout.
DECLARE-PRINTER: Overrides the printer defaults.
DECLARE-PROCEDURE
DECLARE-REPORT: Defines reports and their attributes.
DECLARE-VARIABLE: Allows user to explicitly declare a variable name.
LOAD-LOOKUP: Loads columns into an internal array.
USE: Overrides default database (Sybase and MSSQLServer only)
SHARE

peoplesoft

  • Image
  • Image
  • Image
  • Image
  • Image
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Phaniraavi@gmail.com