Course Description
Short Course | 12 hours | 1.2 CEUs | $850
In this 3-day, interactive workshop students learn the basics of Crystal Reports on day one and then forge into the more complex and powerful features of Crystal Reports on Day 2 and 3. Day 1 topics include creating basic reports, formatting, basic formulas, selection criteria, grouping and sorting, summary reports, and printing and exporting. Day 2 and 3 topics include linking tables, power formatting, conditional formatting, advanced formulas, summary reports, running totals, parameters, sub-reporting, custom groups, charts, cross-tab reports and alerts. The course incorporates a number of hands-on exercises to reinforce the learning process.
Course Outline
- Day 1
- Creating a Simple Report
- Formatting Features
- Creating and Using Basic Formulas
- Selecting Specific Records from the Database
- Grouping and Sorting Data
- Using Subreporting as a Workaround Solutions
- Powerful Custom Grouping
- Creating Charts
- Cross-Tab Reports
- Creating Summary Reports and Charts
- Creating a Summary Report
- Drill-Down
- Exporting Your Reports
- Using the Report Wizards
- Combining Multiple Tables
- Power Formatting
- Conditional Formatting
- Advanced Formulas
- Running Totals
- Prompting with Parameters
- Report Alerts
Prerequisites
Working Knowledge of Windows and familiarity with relational database concepts (tables, fields, records) is required.
Duration
12 Hours | 2 Days or 4 Nights*Academic Unit eligibility to be determined by college/university in which you are enrolled in a degree seeking program.