Crystal Reports Advanced Training Class
This is a two day training class on Crystal Reports. It assumes that you have either taken the 2 day introductory training course on Crystal Reports, or you have gained enough experience on your own using Crystal Reports such that you are ready for an advanced course.
Target Student:
Anyone with a desire or need to learn how to use advanced features of Crystal Reports. Prior knowledge of Crystal Reports is assumed.
Course outline:
Lesson 1: Creating Running Totals
Topic 1A: Create a Running Total Field
Topic 1B: Modify a Running Total Field
Topic 1C: Create a Manual Running Total on Detail Data
Topic 1D: Create a Manual Running Total on Summary Data
Lesson 2: Building Cross-tabs in Your Report
Topic 2A: Create a Cross-tab Topic 2B: Create a Specified Group Order Topic 2C: Filter Cross-tab by Group Topic 2D: Change the Cross-tab Format Topic 2E: Format Rows and Columns Topic 2F: Keep Groups Together
Lesson 3: Adding Subreports
Topic 3A: Insert a Subreport
Topic 3B: Link a Subreport to Data in a Primary Report
Topic 3C: Edit a Subreport
Topic 3D: Format a Subreport Object
Topic 3E: Share Formulas Between Main and Subreports
Topic 3F: Create an On-demand Subreport
Lesson 4: Improving Report Processing Speed
Topic 4A: Create a SQL Expression
Topic 4B: Select Records on the Server
Topic 4C: Write a SQL Query
Topic 4D: Edit a SQL Query
Topic 4E: Build a Report on a SQL Query
Topic 4F: Create SQL Commands in the Crystal Report Environment
Lesson 5: Building Dictionaries
Topic 5A: Create a Dictionary
Topic 5B: Organize the View of Data in a Dictionary
Topic 5C: Adding Graphics to the Dictionary
Topic 5D: Build a Report Based on a Dictionary
Lesson 6: Charting Data Topic 6A: Create a Chart
Topic 6B: Modify a Chart
Topic 6C: Create a Top N Chart
Topic 6D: Format a Chart
Topic 6E: Create a Chart Template
Lesson 7: Reporting on Excel Data
Topic 7A: Create a Report
Topic 7B: Modify a Report
Topic 7C: Update the Report