Crystal Reports Advanced Outline
Aims of the Two-Day Course
This course is suitable for existing users who wish to create complex
reports and data sources using Crystal's tools. The course is 100% hands
on, with exercises to help the trainees practice the new skills they learn.
Course Content
- Create Running Totals
- Create a Running Total Field
- Modify a Running Total Field
- Create a Manual Running Total on Detail Data
- Create a Manual Running Total on Summary Data
- Build Cross-tabs in your Report
- Create a Cross-tab
- Create a Specified Group Order
- Filter Cross-tab by Group
- Change the Cross-tab Format
- Format Rows & Columns
- Keep Groups Together
- Adding Subreports
- Insert a Subreport
- Link a Subreport to Data in a Primary Report
- Edit a Subreport
- Format a Subreport Object
- Share Formulas Between Main & Subreports
- Create an On-Demand Subreport
|
- Improving Report Processing Speed
- Create a SQL Expression
- Select Records on the Server
- Write a SQL Query
- Edit a SQL Query
- Build a Report on SQL Query
- Create SQL Commands in the Crystal Report Environment
- Build Dictionaries
- Create a Dictionary
- Organise the View of Data in a Dictionary
- Add Graphics to the Dictionary
- Build a Report Based on a Dictionary
- Charting Data
- Create a Chart
- Modify a Chart
- Create a Top N Chart
- Format a Chart
- Create a Chart Template
- Reporting on Excel Data
- Create & Modify a Report
- Update the Report
|
Prerequisites
The trainees should have completed the Level One course or they should
be able to create basic list and group reports. Programming and/or SQL
experience would be an advantage.
Course Duration
Twelve hours (9.30am to 12.30pm and 1.30pm to 4.30pm on both days).
Prices
|
