|
|
 |
Retail Pro 9 - Customizing Reports  OVERVIEW: Equip yourself with the skills necessary to create custom reports by modifying and enhancing existing reports in Crystal Reports and by using PL/SQL Developer to create custom stored procedures for your reports. Register custom reports in Report Viewer so they can be categorized and viewed with all other Retail Pro 9 reports. Designed for both beginning report writers as well as more experienced users, you should leave this course with the know-how to start reporting immediately. Time to Complete: 24 hours
NOTE: this is a training course. Successful completion of this training course will entitle you to a certificate-of-completion. This course may also be used to help you prepare for a given certification exam. For more information about available Retail Pro certifications, please visit the certifications section of this website. TRAINING/CERTIFICATION METHOD:
Online: TOPICS:
- Course Overview
- Database Concepts / Understanding Database Concepts and Terminology
- Report Viewer / Understanding What it Can and Cannot Do
- Report Viewer / Understanding the Different Report Types
- Report Viewer / Updating the Delta Table
- Report Viewer / Viewing a Report
- Crystal Reports / Introducing Report Designer Components
- Crystal Reports / Adding Formatting Options (borders, fonts, images and more)
- Crystal Reports / Editing Text Objects (Labels)
- Crystal Reports / Adding and Removing Field Columns
- Crystal Reports / Moving and Resizing Objects
- Crystal Reports / Sorting, Grouping and Summarizing Records
- SQL / Understanding the Syntax of the SQL Select Statement
- SQL / Querying the Database to Create Ad-hoc Reports
- SQL / Understanding the Different Types of Table Joins
- PL/SQL / Adding Report Fields Not in Stored Procedures
- PL/SQL / Introducing PL/SQL Developer Tools
- PL/SQL / Activating a SQL Trace
- PL/SQL / Understanding PL/SQL Packages
- PL/SQL / Modifying and Testing Stored Procedures (Adding Fields and Joining Tables)
- PL/SQL / Referencing Modified Stored Procedures in Reports
|
