Crystal Reports - Level 2

Enquire About This Course

• Delegates will learn how to create reports and interrogate data from the main database - creating lists of data, charts & summary reports.
• Crystal empowers the user and allows direct access to the data tables.  Where it was previously necessary to export to Excel & repetitively create PivotTables, chart, analysis - delegates will learn how to create Crystal Reports ONCE and simply REFRESH data and obtain the essential data.

COURSE CONTENT

Additional Formatting & File Options

• Changing file & default options

Section Formatting

• Creating a Summary report
• Using the Section Expert
• Summary/Drill-Down Reports

Linking

• Adding/removing databases from a report
• Join types
• Self joins
• PC database links
• SQL/ODBC database links
• Using the visual linking expert

Formula Basics

• Using formulas
• Using the Formula Editor
• Using basic calculations
• Using string manipulation
• Applying basic date calculations
• Applying If Then Else formulas
• Applying Boolean formulas

Basic Cross-Tabs

• What is a Cross-Tab?
• Using the Cross-Tab Expert
• Editing a Cross-Tab layout
• Additional Cross-Tab layout features

Conditional Reporting

• Using Conditional Formatting
• Using the Highlighting Expert

Charting

• Using the Graph/ChartExpert
• Graphing on Summary information
• Graphing Detail or Formula fields
• Drilling down on a graph
• Customising a graph 

Click here to download our Course Content:

Crystal Reports_Levels 1 & 2

Enquire About This Course