Crystal Reports 9.0 Advanced

Course Aims
This highly intensive two-day training course has been designed to teach existing users of Crystal Reports 9 how to use more advanced techniques and features to create complex reports and data sources.
Who Should Attend?
This course is intended for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools to make it easier for other people to create reports. They do not need to have programming and/or SQL experience, though this would be helpful.
Course Outline: Crystal Reports 9.0 Advanced
Creating 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
Building 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 and 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 and 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 a SQL Query · Create SQL Commands in the Crystal Report Environment
Building Dictionaries
· Create a Dictionary · Organize the View of Data in a Dictionary · Adding 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 a Report · Modify a Report · Update the Report