Crystal Reports 10: Level 2

Request more details:

Description:
Since you`ve probably completed the first course, or are familiar with the basics of building and modifying reports, you`re ready to move ahead to create complex reports and data sources using Crystal Reports` tools. In this course, you`ll not only learn how to create more sophisticated reports like subreports and cross-tabs, you`ll also learn how to increase the speed and efficiency of your reports by using SQL queries and dictionaries. You will create complex reports and data sources using Crystal Reports` tools. <BR> <BR> <a href='http://www.professional.ie/it_training/crystalreports_and_brio.htm'> View other Crystal Reports Courses available</a> <BR>
Prerequisites:
Crystal Reports 10.0: Level 1, and knowledge of programming and/or SQL would be helpful.
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 a Cross-tab by Group
Change the Cross-tab Format
Conditionally 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 Using the Format Editor
Share Formulas Between Main and Subreports
Create an On-demand Subreport
Creating Drill-Downs:
Create a Drill-down
Create Separate Headings for Drill-down Data
Enhancing Report Processing using SQL:
Create a Report Using SQL Queries
Summarize Report Data Using SQL Aggregate Functions
Create Joins Using SQL
Create Subqueries
Create an SQL Expression Field to Promote Server-side Processing
Charting Data:
Create a Bar Chart
Modify a Chart
Create a Top N Chart
Format a Chart
Create a Chart Template
Reporting on Excel:
Create a Report Based on Excel Data
Modify a Report Generated from Excel Data
Update Data in a Report Based on Excel Data