SQR in peoplesoft and other applications

From the fundamentals of SQR Page to the tricks of controlling multiple breaks in reports, from basic PeopleSoft objects to the intricacies of interacting with the Process Scheduler, its all here in one handy source.

What's Inside :

Reusable code examples SQR language from A Lo Z Pitfalls, shortcuts, effective methods Make your programs PeopleSoft API-aware Integrate SQR apps with PeopleSoft objects Effective-dated tables Complete SQR syntax reference

Contents

• Part 1 SQR basics 1
• Introducing SQR 3
• Structured Query Language 9
• Getting started
• SQR data elements and data manipulations
• Basics program structure
• Working with from a database
• Taking full advantage of SQL
• Loops and decision logic in SQR
• Enhancing your SQR report
• Part 2 Advanced features of SQR
• Using break logic in your SQR program
• Run-time and compile-time variables
• Working with arrays
• Creating multiple report
• Creating SQR Portable Files
• Generating letters
• Using graphics
• Working with flat files
• Interacting with operating systems and other applications
• Internet enabling
• Debugging techniques
• Good programming practices
• Part 3 SQR and People Soft
• Running SQR in PeopleSoft applications
• Attaching and SQR program to PeopleSoft objects
• Making an SQR program API Aware
• Accepting input parameters from PeopleSoft online panels
• Working with effective-dated tables