Crystal Reports - Adv

Enquire About This Course

This course is for all delegates wishing to learn the advanced skills of Crystal Reports. It can be delivered at all versions of Crystal Reports, including 9,10, XI and CR2008.

Review

• Creating reports
• Formatting
• Grouping
• Summarizing
• ing records
• Summary Drill Down
• Linking
• Formulas
• CrossTabs

Advanced Formulas

• Creating multiple statement formulas
• Using variables
• Understanding two-pass reporting
• Using evaluation time functions
• Creating running totals
• Adding User Functions Libraries (UFLs)

Conditional Formatting

• Types of formatting
• Absolute formatting
• Conditional on/off formatting
• Conditional attribute formatting
• Using the highlighting feature

Multiple Sections

• Inserting sections
• Splitting Sections
• Moving sections
• Deleting sections
• Multiple section formats (underlay following sections)
• Example uses (watermark, shading every other record, creating different header/footers, different form letters, suppress blank lines

Parameter Fields

• Creating parameter fields
• Using parameter fields in record ion formula

Advanced CrossTabs

• Multiple rows, columns and summarised fields
• Formatting CrossTabs
• Using formulas, parameter fields in crosstabs
• Simulated CrossTabs
• What are subreports?
• Linked subreports
• Unlinked subreports
• On-demand subreports

Subreports

• What are subreports?
• Linked subreports
• Unlinked subreports
• On-demand subreports

SQL/ODBC Query Designer

• What is the SQL/ODBC?
• What is the Query Designer?
• What is an ODBC data source?
• SQL statement components
• Creating queries

Creating Data Sources

• Using Access files

Graphing

• Creating a graph on summary fields
• Graphing on multiple summary values
• Graphing on CrossTabs
• Editing and formatting graphs

Dictionaries

• What are Dictionaries?
• Using dictionaries to create reports
• Creating dictionaries

Reporting

• Crystal Web Report server installation
• Introduction to Web Reporting
• Viewing Crystal Reports on the Web

Click here to download:

Crystal Reports_Advanced

Enquire About This Course