Course Overview
TOPThe course will provide students with a general overview of the basic functionality and a general understanding of report design, including the need to provide quality reports in various presentation formats. Students will gain practical experience through hands-on exercises.
Scheduled Classes
TOPWhat You'll Learn
TOP- Explore the Crystal Reports interface.
- Learn to create a basic report and modify it.
- Learn to format reports..
- Learn to filter reports.
- Learn to group report data.
- Learn to create reports from data in multiple tables.
- Learn to use formulas..
- Learn to use conditional formatting.
- Learn to create summary reports and charts.
- Learn to export reports to Excel and PDF.
- Learn to use Report Wizards.
Outline
TOP
Viewing outline for:
- Getting Acquainted with Crystal Reports
- Report Writing Process
- Opening Crystal Reports
- The Database Expert
- Review the Toolbars
- The Standard Toolbar
- The Formatting Toolbar
- The Insert Toolbar
- The Experts Toolbar
- The Navigation Toolbar
- The External Command Toolbar
- The Report Sections in the Design Tab
- Report Header
- Page Header
- Details
- Page Footer
- Report Footer
- The Field Explorer
- Preview the Report
- Adding Multiple Tables to Reports
- Formatting Reports
- Formatting Fields
- The AdventureWorks Database
- The Format Painter
- Formatting Fields
- Working with Objects
- Text Objects
- Field Titles
- Using Fields in Text Objects
- Aligning and Sizing Objects
- The Section Expert
- Images
- Filtering Reports
- Create a Filter Based on a Single Criterion
- Create a Filter for Multiple Selection Criteria
- Sorting and Grouping Reports
- Using the Sort Expert
- Using the Group Expert
- Summarizing Records within Groups
- Using Basic Formulas
- String Formulas
- Numeric Formulas
- Date/Time Formulas
- Running Totals
- Conditional Formulas
- Advanced Formatting
- Using Multiple Sections
- Summary Reports
- Lines and Boxes
- The Highlighting Expert
- Exporting and Distribution
- Exporting to Excel
- Exporting to PDF
- Exporting to Word
Prerequisites
TOPExperience in the following is required for this Crystal Reports class:
- Basic computer skills
Experience in the following would be useful for this Crystal Reports class:
- Familiarity with relational database concepts (tables, fields, and records)
Who Should Attend
TOPThis Crystal Reports course is intended for students who have little to no experience with Crystal Reports.