Etopia Computer Training
IT Computer Training Experts
Discounts of 25% & Tailored from £295!
25% Off Microsoft Application Courses!

Upcoming Courses

Call for any late availability offers on these upcoming courses.

Training Room Hire

Our Glasgow training room facilities are available for hire.

Crystal Reports Advanced

Duration:2 days
Price:£750.00
Locations:Glasgow, Edinburgh
Glasgow Dates:Mon 27th Feb 12,  Tue 24th Apr 12,  Tue 19th Jun 12,  Tue 28th Aug 12
Edinburgh Dates:Tue 24th Apr 12,  Tue 19th Jun 12,  Tue 28th Aug 12

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 Crystal defined template.
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.