Structured Query Reporting
Reporting and Batch Processing
- SQR Syntax and Semantics
- Understanding Page Layout
- Headers and Footers
- Program Structure
- Graphics and Fonts
- Hands-on Activities!
Learn the basics of PeopleSoft’s text-based reporting and batch processing tool
Live-Virtual
Three-day course
$3,531 USD
Topics Covered
- SQR Basics
- Text Editors
- Print Coordinates
- Headers and Footers
- SQL SELECT Statements
- Column Variables
- Conditional Statements
- Flow-control Statements
- Variables
- Substitution Variables
- Built-in Functions
- Print Commands
- Formatting
- Functions
- Edit Masks
- SQC Files
- Local and Global Procedures
- Run Control Pages and Records
- User Input and Parameters
- Debugging and Tracing
- Lookup Tables and Arrays
- Interfaces and Integration
- Graphics
Note: This course includes Two days of video content and four days of textual instructions and hands-on activities.
Who Should Attend?
- PeopleSoft Developers
- Report Writers
Course Content
Expand All
Introduction
2 Topics
Expand
Lesson Content
0% Complete
0/19 Steps
Lesson Content
0% Complete
0/15 Steps
Lesson Content
0% Complete
0/12 Steps
Lesson Content
0% Complete
0/15 Steps
Chapter 7: SQC
9 Topics
Expand
Lesson Content
0% Complete
0/13 Steps
Lesson Content
0% Complete
0/13 Steps
Lesson Content
0% Complete
0/6 Steps
Lesson Content
0% Complete
0/11 Steps
Lesson Content
0% Complete
0/13 Steps
Lesson Content
0% Complete
0/11 Steps
Lesson Content
0% Complete
0/11 Steps