This course is designed for people who know how to create basic list and group reports but need to create reports that include subreports, cross-tabs, advanced formulas and charts based on more than one data series.
After participating, they will be able to create complex reports using Crystal Reports’ tools.
Course Duration: 2 days
Prerequisites:
Students should participate in Crystal Reports 2011: Level 1 before taking this course. Knowledge of programming and/or SQL is also helpful.
Hardware and Software Requirements:
For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware configuration:
- 1 GHz Pentium®-class processor or faster
- A minimum of 1 GB of RAM is recommended
- 20 GB hard disk or larger if you use Windows XP Professional as your operating system. You should have at least 1 GB of free hard disk space available for Office 2010 installation
- Access to one of the following: a local CD-ROM drive, a local DVD drive, or access to a networked CD-ROM drive
- A keyboard and mouse or other pointing device
- A 1024 x 768 resolution SVGA monitor is recommended
- Network cards and cabling for local network access
Internet access (check with your local network administrator). - A printer (optional) or an installed printer driver
- A projection system to display the instructor’s computer screen
Each computer requires the following software:
- Microsoft® Windows® XP SP2 or Vista
- Custom installation of Crystal Reports® 2011
- Default installation of Microsoft® Office 2010
- Printer driver (Printers are not required; however, each PC must have an installed printer driver to use Print Preview.)
- Adobe® Reader® 9.0 and above
For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware configuration:
- 1 GHz Pentium®-class processor or faster
- A minimum of 1 GB of RAM is recommended
- 20 GB hard disk or larger if you use Windows XP Professional as your operating system. You should have at least 1 GB of free hard disk space available for Office 2010 installation
- Access to one of the following: a local CD-ROM drive, a local DVD drive, or access to a networked CD-ROM drive
- A keyboard and mouse or other pointing device
- A 1024 x 768 resolution SVGA monitor is recommended
- Network cards and cabling for local network access
Internet access (check with your local network administrator). - A printer (optional) or an installed printer driver
- A projection system to display the instructor’s computer screen
Each computer requires the following software:
- Microsoft® Windows® XP SP2 or Vista
- Custom installation of Crystal Reports® 2011
- Default installation of Microsoft® Office 2010
- Printer driver (Printers are not required; however, each PC must have an installed printer driver to use Print Preview.)
- Adobe® Reader® 9.0 and above
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
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 Outline:
- Creating Running Totals
- Create a Running Total Field
- Modify a Running Total Field
- Create a Manual Running Total
- Working with Cross-Tabs
- Create a Cross-Tab Report
- Format a Cross-Tab Report
- Create Groups in Cross-Tab Reports
- Adding Subreports
- Insert a Subreport
- Edit a Subreport
- Share Variables
- Creating Drill-Downs in a Report
- Create a Drill-Down
- Create Headings for Drill-Down Data
- 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
- Creating Complex Formulas
- Work with Loops
- Work with Arrays
- 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
- Enhancing Report Functionality
- Organize Data Based on a Hierarchy
- Create a Dynamic Image
- Create a Report Alert
- Create a Geographic Map
- Managing Reports
- Processing Data on the Server
- Detecting and Fixing Problems
- Creating Running Totals
- Create a Running Total Field
- Modify a Running Total Field
- Create a Manual Running Total
- Working with Cross-Tabs
- Create a Cross-Tab Report
- Format a Cross-Tab Report
- Create Groups in Cross-Tab Reports
- Adding Subreports
- Insert a Subreport
- Edit a Subreport
- Share Variables
- Creating Drill-Downs in a Report
- Create a Drill-Down
- Create Headings for Drill-Down Data
- 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
- Creating Complex Formulas
- Work with Loops
- Work with Arrays
- 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
- Enhancing Report Functionality
- Organize Data Based on a Hierarchy
- Create a Dynamic Image
- Create a Report Alert
- Create a Geographic Map
- Managing Reports
- Processing Data on the Server
- Detecting and Fixing Problems