fbpx

+1 (509) 888-PROS

Find A Course

Log in

Please log in to continue.

Forgot your password? Click here to reset.

Not a member? Register Now. Registration is Free!

Register

Fantastic! Before you enroll, do you have an account with us? If so, please log in to continue. Otherwise, we have a simple three-step process:

① REGISTER
② Confirm your e-mail Address
③ Purchase this course

① REGISTER

Already a member? Log in.

A username may contain letters, numbers, spaces, underscores, hyphens, periods, and the @ symbol

Privacy Policy | Terms of Use

By clicking register, I agree to receive communications from JSMpros. I understand that I can opt-out of communications at any time and that opting out may result in missed notices regarding my account.

① LOG IN

Login

Forgot Password?
Register

② Confirm your e-mail Address

Check your e-mail (and spam/junk) for an e-mail from us asking you to confirm your e-mail address. After confirmation, return to this dialog to complete step 3: Enroll in this course.

③ Purchase this course

Check your e-mail (and spam/junk) for an e-mail from us asking you to confirm your e-mail address. After confirmation, return to this dialog to complete step 3: Enroll in this course.

Begin Purchase

SQR (Subscribers Only)

Current Status
Not Enrolled
Price
$2,387.00
Get Started
This course is currently closed

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

On-Demand

60-days access
$2,387 USD

Enroll

Live-Virtual

Three-day course
$3,531 USD

Subscribe

This course is included with
an annual subscription.

Upgrade Today!

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: The on-demand 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