DB443 - Advanced Applications of Crystal Reports

Course Description

Learn to use parameters to insert or select data on the fly, write advanced formulas, and create subreports to include multiple reports within one report document. Find out how Crystal Reports uses SQL commands to select report data, and learn to write your own simple SQL statements to select data for your reports. Understand how to create cross-tab reports to group and summarize data in two directions.

By the end of this course, you will be able to: 

• Use parameters to insert or select data “on the fly.” 

• Modify join types and link options to control the data included in your reports. 

• Write formulas that use advanced programming constructs, like variables and select case statements. 

• Interpret the SQL statements that Crystal Reports uses to select report data, and write and edit simple SQL statements to select data on your own. 

• Create subreports, so you can include multiple reports in one document. 

• Produce cross-tab reports to summarize data in two dimensions—in a format similar to a spreadsheet. 

• Use alerts to notify users about information that requires special attention. 

Applies Towards the Following Certificates

• Database Technology Certificate : Electives