Oracle PeopleSoft Query/Crystal Power Combo Rel 8.48

Product Description

The Query Basics portion of this course teaches you to create online reports using People Soft Query. Many users who need to retrieve the stored information are not comfortable with programming. With People Soft Query, you can extract the precise information that you're looking for using visual representations of the People Soft database without writing Structured Query Language (SQL) statements.

The Query Advanced portion of this course teaches you to create complex online reports using People Soft Query. Many users who need to retrieve the stored information are not comfortable with programming. With People Soft Query, you can extract the precise information that you're looking for using visual representations of the People Soft database without writing Structured Query Language (SQL) statements. Extend your knowledge of reporting by using the principles that you learn in Query Advanced. Learn advanced techniques for viewing the exact data that you need. Learn to use expressions that perform configurable online calculations. Learn to combine data from unrelated tables. Learn to use multiple queries to return one set of data.

The Crystal Basics portion of this course teaches you to design reports using Crystal Reports 9. Crystal Reports is a report formatting application that accesses queries that you create & store in People Soft applications. Once you create & save the report definitions, you can print reports in a variety of formats, including text files, HTML files, word processing documents, & spreadsheets.

• View data online
• Sort & group output
• Create & format reports
• Share public queries
• Create expressions & calculations
• Build sub queries

This training may be available onsite; please contact us if you are interested.