Crystal Reports Level 2
| Date |
Location |
Duration |
Cost |
23 Sep 2010 (Thu)
24 Sep 2010 (Fri) | Washington | 2 | £ 395 |
11 Oct 2010 (Mon)
12 Oct 2010 (Tue) | Washington | 2 | £ 395 |
23 Nov 2010 (Tue)
24 Nov 2010 (Wed) | Washington | 2 | £ 395 |
16 Dec 2010 (Thu)
17 Dec 2010 (Fri) | Washington | 2 | £ 395 |
01 Feb 2011 (Tue)
02 Feb 2011 (Wed) | Washington | 2 | £ 395 |
14 Apr 2011 (Thu)
15 Apr 2011 (Fri) | Washington | 2 | £ 395 |
06 Jun 2011 (Mon)
07 Jun 2011 (Tue) | Washington | 2 | £ 395 |
28 Jul 2011 (Thu)
29 Jul 2011 (Fri) | Washington | 2 | £ 395 |
Please contact us to discuss private course dates and locations |
Course Overview
Delegates will learn how to create advanced formulas, format reports based on calculation results (conditional formatting), use multiple sections, insert sub reports and access data from sources other than PC databases.
Prerequisites
- To ensure your success, we recommend that delegates first take the course Crystal Reports Level 1, or have equivalent knowledge.
Objectives
Related Courses
Training Options
- Scheduled public courses at one of our training venues
- Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
- Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
- For further information please contact us on 0191 377 8377
What's Included
- 1 delegate per computer
- Telephone and email support
- Relaxed refreshment area at our training venues
- Lunch and refreshments when training is delivered at our training venue
- Comprehensive course manual and exercises
Course Content
Review Exercises
Formatting sections for summary/drill-down
Creating formulas
Selecting, grouping and summarizing
Adding and linking databases
Creating a basic report
Conditional Formatting
Removing conditional formatting
Using the highlighting expert
Assigning conditional attribute formatting
Applying and removing conditional on/off formatting
Understanding the difference between absolute and conditional formatting
Advanced Formulas / Variables
Creating formulas using multiple variables
Using evaluation time functions
Understanding multiple pass reporting
Creating running totals
Using variables in formulas
SQL and Commands
Adding parameters to your own SQL statement
Defining your own SQL as the data source
Introduction to standard query language (SQL)
Parameter Fields
Using parameter fields to set conditional formats
Using parameter fields to specify sort criteria
Understand edit masks
Report Alerts
Viewing record sets created by use of alerts
Creating and using report alerts
Multiple Sections
Working with multiple sections and conditional formats
Moving, splitting and merging sections
Inserting and deleting sections
Subreports
Using variables to pass data from a sub report to the main report
Creating on-demand subreports
Formatting subreports
Inserting unlinked and linked subreports
Identifying when subreports are needed
Basic & Advanced Cross-Tabs
Using formula fields & parameter fields with cross tab reports
Formatting cross Tab components
Inserting multiple rows, columns and summarized fields
Creating basic and advanced cross tab reports
Charting
Creating basic, calculating and cross tab related charts
Formatting existing graphs
Chart types, layout options and using the Chart Expert
Print