AUCKLAND (09) 378-0411       HAMILTON (07) 838-0700       WELLINGTON (04) 472-4830      CHRISTCHURCH (03) 365-5020      |      
Home Courses Crystal Reports Advanced User 9-14

Courses


Crystal Reports Advanced User 9-14

Length: 2 Days    Cost: $1,245 + GST    Version: Crystal Reports 9-14

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online
CentreOctNovDecJan
Auckland--
13
----
Hamilton--------
Christchurch--
30
----
Wellington
26
------

Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.


About this Course

This two day hands-on advanced course develops the skills required to analyse data and produce complex reports from diverse data sources using the crystal report designer



Prerequisites

Must have either attended the Crystal Reports Essential Skills course or be an experienced Crystal Reports user.

Course Outline


Formulas

  • If…Then…Else operator
  • Suppress, Hide and Drill-Down Reports



Parameter Fields

  • Parameter for Selecting Records
  • Parameter for Sort Order
  • Parameter in a Formula Expression



Cross-Tabulations

  • Formatting a Cross Tab Report
  • Pivoting a Cross Tab Report
  • Summarising Multiple fields



Custom Functions and the Repository

  • Create Custom Functions
  • Store Objects in Repository



Running Totals

  • Multi-Pass Reporting
  • Creating a Running Total



Forms and Form letters

  • Design a Form
  • Conditional Form Letters



TopN Reports

  • Sort by Group Selection
  • TopN reports
  • BottomN Reports



Linking Tables

  • Linking Two Tables
  • Linking through Direct Access
  • Linking through ODBC
  • Verify Database
  • Set Location



Sub reports

  • Unlinked Sub reports
  • Linked Sub reports
  • On-Demand vs. In-Place Sub reports



Arrays and Variables

  • Variables and Arrays
  • Scope
  • Charts and Maps




 Print this page