Skip to Main Content
Getting Started with SQR for PeopleSoft
SQR for PeopleSoft Overview
Understanding Transparent Application Failover for SQR
SQR for PeopleSoft Implementation
Other Sources of Information
Introducing a Sample Structured Query Report Program
Using This Guide
Setting Up the Sample Database
Considerations for DBX
Understanding the Sample Program for Printing a Text String
Creating and Running a Sample SQR Program
Viewing SQR Output
Creating Headings and Footings
Understanding SQR Pages
Creating Page Headings and Footings
Selecting Data from the Database
Understanding the Sample Program for Listing and Printing Data
Creating SQR Select Paragraphs
Using Column Variables
Using Column Variables in Conditions
Changing Column Variable Names
Using Break Logic
Understanding Break Logic
Using the ON-BREAK Option
Skipping Lines Between Groups
Arranging Multiple Break Columns
Using Break Processing Enhancements
Setting Break Procedures with BEFORE and AFTER Qualifiers
Controlling Page Breaks with Multiple ON-BREAK Columns
Saving a Value When a Break Occurs
Using ON-BREAK on a Hidden Column
Performing Break Processing on Numeric Values
Adding Declarations Using the SETUP Section
Understanding the SETUP Section
Creating a SETUP Section
Using the DECLARE-LAYOUT Command
Overriding Default Settings
Declaring a Page Orientation
Creating Master and Detail Reports
Understanding Master and Detail Reports
Understanding the Sample Program for Master and Detail Reports
Correlating Subqueries
Creating Cross-Tabular Reports
Understanding Cross-Tabular Reports
Using an Array
Creating an Array
Grouping by Category
Using Multiple Arrays
Printing Mailing Labels
Understanding Mailing Label Printing
Understanding the Sample Program for Printing Mailing Labels
Defining Columns and Rows
Running the Print Mailing Labels Program
Creating Form Letters
DOCUMENT Paragraph
Sample Program for Form Letters
Exporting Data to Other Applications
Understanding the Sample Program for Exporting Data
Creating an Export File
Using Graphics
Understanding the Sample Program for Simple Tabular Reports
Adding Graphics
Sharing Images Among Reports
Printing Bar Codes
Using Business Charts
Understanding Business Charts
Creating a Chart
Defining Charts
Printing Charts
Running the Program to Create Graphical Reports
Passing Data to Charts
Changing Fonts
Setting Fonts
Positioning Text
Using the WRAP Option
Writing Printer-Independent Reports
Understanding Printer-Independent Reports
Reviewing the Sample Program for Selecting the Printer Type at Runtime
Using Dynamic SQL and Error Checking
Using Variables in SQL
Using Dynamic SQL
Using SQL Error Checking
Using SQL and Substitution Variables
Using Procedures and Local Variables and Passing Arguments
Using Procedures
Using Local Variables
Passing Arguments
Creating Multiple Reports from One Program
Understanding How to Create Multiple Reports
Understanding the Sample Program for Multiple Reports
Defining Heading and Footing Sections
Defining Program Output
Using Additional SQL Statements with SQR
Using SQL Statements in SQR
Using the BEGIN-SQL Paragraph
Working with Dates
Understanding Dates and Date Arithmetic
Using Literal Date Formats
Using String-to-Date Conversions
Using Date-to-String Conversions
Using Dates with the INPUT Command
Using Date Edit Masks
Declaring Date Variables
Using National Language Support
Understanding Locales
Selecting Locales
Defining a Default Locale
Switching Locales
Modifying Locale Preferences
Specifying NUMBER, MONEY, and DATE Keywords
Using Interoperability Features
Calling SQR from Another Application
Invoking an SQR Program by Using the SQR API
Invoking an External Application API by Using the UFUNC.C Interface
Adding a User Function
Using UFUNC in Microsoft Windows
Implementing New User Functions in Microsoft Windows
Testing and Debugging
Using the Test Feature
Using the #DEBUG Command
Using Compiler Directives for Debugging
Avoiding Common Programming Errors
Increasing Performance and Tuning
Understanding SQR Performance and SQL Statements
Simplifying Complex Select Paragraphs
Using LOAD-LOOKUP to Simplify Joins
Improving SQL Performance with Dynamic SQL
Examining SQL Cursor Status
Avoiding Temporary Database Tables
Creating Multiple Reports in One Pass
Tuning SQR Numerics
Compiling SQR Programs and Using SQR Execute
Setting Processing Limits
Buffering Fetched Rows
Running Programs on the Database Server
Compiling Programs and Using SQR Execute
Understanding Compile Features
Compiling and Running an SQR Program
Printing with SQR
Specifying Output File Types by Using SQR Command-Line Flags
Using the DECLARE-PRINTER Command
Using the SQR Command Line
Understanding the SQR Command Line
Specifying Command-Line Arguments
Using Batch Mode
Generating and Publishing HTML from an SQR Program
Understanding SQR Capabilities That Are Available with HTML
Generating HTML Output
Using HTML Procedures in an SQR Program
Modifying an Existing SQR Program for HTML
Publishing a Report
Generating tagged PDF Output from SQR Program
Tagged PDF Overview
Sample Program to Create Tagged PDF
Tagged PDF in PeopleSoft Application
Using Accessibility Checkers
Generating XML Output from SQR Program
Generating XML Output
SQR Commands to Generate XML Output
Sample Program to Generate XML Output
Generating XML Output in PeopleSoft Applications
Creating a Table of Contents
Using the DECLARE-TOC Command
Using the TOC-ENTRY Command
Adding a Table of Contents to the CUST.SQR Sample Program