Engage
Enable
Enact
Entrust
Crystal Reports Advanced
What skills will the delegate gain?
This course will enable delegates to:
- Create running totals in a report.
- Build CrossTab reports.
- Add sub reports.
- Improve processing speed in reports.
- Apply and create templates.
- Present data on charts and maps.
- Report from Excel and Access data.
Prerequisites
Crystal Reports v11 Introduction or have equivalent knowledge.
COURSE CONTENT
Advanced formulae
Formula Workshop.
Custom functions.
Advanced functions.
Using Running Totals.
Variables and arrays.
Advanced Report Formatting
Applying a
Creating a template.
Workbench.
Dependency Checker.
Setting default Report Options.
Reporting on Excel and Access data
Review of Introductory Course
Summary drill-down reports
Hiding and suppressing sections.
Hiding / Displaying sections conditionally.
Formatting report sections
Section Expert.
Adding/Modifying sections.
Creating a Letter.
Underlaying Sections.
Subreports
Linked/Unlinked Subreports.
On-Demand Subreports.
Using variables within Subreports.
Advanced Report Processing
SQL Commands / Expression Fields.
Multi-pass reporting.
Speed of report processing.
Additional database options.
Charts & Maps
Creating a chart using the Chart Expert.
Formatting Charts.
Creating & formatting Maps.
Cross-Tabs
Adding Cross-tabs to a report.
Formatting Cross-tabs.
Charting on Cross-tabs.