Current Status
Not Enrolled
Enroll in this course to get access
Price
$2,387.00
Get Started
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
Introduction
2 Topics
You don't currently have access to this content
Chapter 1: SQR Basics
19 Topics
You don't currently have access to this content
Lesson Content
0% Complete
0/19 Steps
Chapter 2: SQL Selects in SQR
15 Topics
You don't currently have access to this content
Lesson Content
0% Complete
0/15 Steps
Chapter 3: Flow Control Commands
14 Topics
You don't currently have access to this content
Chapter 4: Variables
12 Topics
You don't currently have access to this content
Lesson Content
0% Complete
0/12 Steps
Chapter 5: Built-in Functions and Commands
15 Topics
You don't currently have access to this content
Lesson Content
0% Complete
0/15 Steps
Chapter 6: Print Commands
11 Topics
You don't currently have access to this content
Chapter 7: SQC
9 Topics
You don't currently have access to this content
Chapter 8: Global and Local Procedures
7 Topics
You don't currently have access to this content
Chapter 9: SQR Program Structure
13 Topics
You don't currently have access to this content
Lesson Content
0% Complete
0/13 Steps
Chapter 10: Running SQR Programs
13 Topics
You don't currently have access to this content
Lesson Content
0% Complete
0/13 Steps
Chapter 11: User Input & Report Parameters
6 Topics
You don't currently have access to this content
Lesson Content
0% Complete
0/6 Steps
Chapter 12: Debugging and Tracing
11 Topics
You don't currently have access to this content
Lesson Content
0% Complete
0/11 Steps
Chapter 13: Lookup Tables & Arrays
13 Topics
You don't currently have access to this content
Lesson Content
0% Complete
0/13 Steps
Chapter 14: Interfaces and Integration
11 Topics
You don't currently have access to this content
Lesson Content
0% Complete
0/11 Steps
Chapter 15: Using Graphics in SQR
11 Topics
You don't currently have access to this content
Lesson Content
0% Complete
0/11 Steps
Chapter 16: Online References
You don't currently have access to this content
Course Survey
You don't currently have access to this content