This 2 day Crystal Reports class is intended for those experienced in Crystal Reports and who want to learn more about database functionality and the more advanced features of Crystal Reports. This will be enhanced through the use of hands-on exercises throughout the course.
Please note that XI is the older version of Crystal Reports and should not be confused with 2011.
Goals
- Learn about databases and SQL.
- Learn about custom functions.
- Learn about more advanced functions.
- Learn how to make reports more efficient and effective.
- Learn about charts.
- Learn about report alerts.
Outline
- Crystal Reports Refresher
- Creating a Crystal Report
- Using Parameters
- Creating Parameters
- Optional Parameters
- Using a List of Values
- Using Parameters
- Subreports
- Unlinked Subreports
- Linked Subreports
- Charts
- Adding Charts to Reports
- Cross-tabulation Reports
- Using Cross-tabulation Reports
- Working with SQL
- The SELECT Statement
- The WHERE Clause
- The ORDER BY Clause
- Joins
- SQL Commands
- SQL Expressions
- Advanced Techniques
- Special Fields
- Using the Select Case Statement
- Evaluation Time Functions
- Conditional Formatting
- Alternating Row Formatting
- Report Alerts
- Using Report Alerts
To Hire an AMS Crystal Reports Subject Matter Expert and Instructor who also teaches this class, call us today at 800-798-3901!