Crystal Reports 2011 Intermediate Training

How To Take This Class:

• Live Instructor-Led Online Class   > View Schedule or Register
• Onsite Group Training   > Request Pricing

Instructor-Led Online Course Tuition:

$650.00

Course Duration:

2 Days

What Students Receive:

Each student will receive:

• A printed courseware manual for use during and after class.
• Access to a searchable, electronic version of the courseware manual for reference after class (available for 12 months after class.)
• A PC headset for communicating with your instructor and fellow students during your Crystal Reports 2011 Training Class
• A course completion certificate upon successful completion of your Crystal Reports 2011 Training course
• Six months of post-class email support from a Crystal Reports 2011 Instructor

Course Description:

In this Crystal Reports 2011 Intermediate Training Course, students will create more complex reports using grouping, sub-reports, cross-tab reports advanced formulas and charts.

Course Objectives:

Upon successful completion of this course, students will be able to:

• Create automatic and manual running totals
• Work with cross-tab reports
• Add subreports
• Create drill-downs in a report
• Use SQL statements in report processing
• Create complex formulas
• Add charts to reports
• Enhance report functionality

Course Audience:

This course is designed for persons who need output from a database. In some cases, database programs have limited reporting tools, and/or such tools may not be accessible. Students may or may not have programming and/or SQL experience.

Course Prerequisites:

Students should have experience navigating in a Windows environment. Some experience with Microsoft Access or an understanding of database concepts is also helpful. Students should also have attended, or have experience with the concepts in our Crystal Reports 2011 Introduction Course.

Course Syllabus:

1. Creating Running Totals
• Create a Running Total Field
• Modify a Running Total Field
• Create a Manual Running Total
2. Working with Cross-Tabs
• Create a Cross-Tab Report
• Format a Cross-Tab Report
• Create Groups in Cross-Tab Reports
3. Adding Subreports
• Insert a Subreport
• Edit a Subreport
• Share Variables
4. Creating Drill-Downs in a Report
• Create a Drill-Down
• Create Headings for Drill-Down Data
5. Using SQL Statements in Report Processing
• Create a Report Using SQL Queries
• Summarize Report Data
• Create Joins Using SQL
• Create Subqueries
• Create a SQL Expression Field
6. Creating Complex Formulas
• Work with Loops
• Work with Arrays
7. Adding Charts to Reports
• Create Charts
• Create a Chart with a Drill-Down
• Create a Top N Chart
• Create a Cross-Tab Chart
• Create Charts for Grouped Data
• Format a Chart
• Create a Chart Template
8. Enhancing Report Functionality
• Organize Data Based on a Hierarchy
• Create a Dynamic Image
• Create a Report Alert
• Create a Geographic Map
9. Appendix A: Managing Reports
10. Appendix B: Processing Data on the Server
11. Appendix C: Detecting and Fixing Problems