Two-day Crystal Reports Course

You will learn:

Day 1

• About Crystal Reports
• Report Creation Wizards
• Create a Blank Report
• Report sections
• Insert a field (use the Field Explorer)
• Adding additional fields
• Selecting fields
• Resizing fields
• Preview the report
• Displaying field names
• Combine database fields in a text object
• Adding summary information
• Adding a title
• Formatting objects
• Adding a field heading
• Limit or restrict the records to be included in a report
• Grouping
• Inserting a company logo or picture
• Choosing data sources and database fields
• Database Expert
• Design tab environment
• Using the Select Expert
• Set up record selection using a formula
• Record selection formula templates
• Sorting data
• Sort field
• Sort Direction
• Group and sort direction (Four sort and group direction options)
• Creating custom groups
• Group data in intervals
• Edit a Group
• Sorting records within groups
• Subtotaling
• Calculating a percentage
• Running Totals
• Working with sections
• Multiple columns
• Formatting
• Using a template
• To apply a template to an existing report
• Removing an applied template
• Hyperlink fields
• Subreports
• Charts
• Creating a parameter field

Day 2

• Using Formulas
• Pulling out a portion, or portions, of a text string
• Extracting parts of a date
• Formula Components and Syntax
• Editing formulas
• Removing the working formula from your report
• Debugging Formula
• Basic Syntax Fundamentals
• Simple data types (Basic syntax)
• Number (Basic syntax)
• Currency (Basic syntax)
• String (Basic syntax)
• Boolean (Basic syntax)
• Date, Time and DateTime (Basic syntax)
• Range data types (Basic syntax)
• Comments (Basic syntax)
• How fields appear in formulas
• Assignment (Basic syntax)
• Control structures (Basic syntax)
• Using If - Else - End If (Basic syntax)
• Select - Case statements (Basic syntax)
• For - Next loop (Basic syntax)
• Using the Exit For statement (Basic syntax)
• Do Loops (Basic syntax)
• Array data types (Basic syntax)
• Variables (Basic syntax)
• Variable Scope (Basic syntax)
• Local Variables
• Global variables (Basic syntax)
• Shared variables (Basic syntax)
• Functions (Basic syntax)
• Crystal syntax fundamentals
• Comments ( Crystal syntax)
• Expressions ( Crystal syntax)
• Assignment and Variable Declaration ( Crystal syntax)
• Variable Scope ( Crystal syntax)
• Declaring array variables ( Crystal syntax)
• Control Structures ( Crystal syntax)
• Evaluation Time functions (Basic and Crystal syntax)
• Some Commonly used Functions
• Custom functions
• Parameter Fields and Prompts
• To create a parameter with a static prompt
• The SQL language

Date: Monday 13 September and Tuesday 14 September 2010

Cost: $660 (Australian dollars) including morning tea, lunch, afternoon tea, notes and lots of hands on exercises

Time: 9 am - 5pm

Place: 600 Collins Street or at a place close to the Monash freeway about 25 minutes drive from Melbourne city in Australia

Enquiries or Enrolment:

Email: melbourne@expert.com.hk

We also offer on-site training courses at your place anywhere in Australia, email to us for details: melbourne@expert.com.hk