Click Here for the Outline in PDF Version Course Outline: Crystal Reports 8.5: Advanced (2 Days) with Hands-On Labs Learning Objectives Create formulas with multiple statements and use variables Understand and control the calculation process used to compile your data Control the appearance of your report using conditional format statements and multiple sections Create parameter formulas that allow your users to determine what information they want to see on a report Understand and use report alerts to notify you about data changes Enhance the analysis capability of your cross-tabs Extend your reporting capacity by utilizing subreports Access data from SQL/ODBC data sources, and generate queries using Crystal SQL Designer Create and modify dictionary files to simplify the reporting process for your users Create and edit graphical representations of your data using the Chart Expert or modify existing graphs with the Chart Analyzer This course description should be used to determine whether the course is appropriate for you based on your current skill and technical training needs. Technical information is provided on the intended audience, course prerequisites, and covered topics. Course content, prices, and availability are subject to change without notice. Course Audience This seminar is designed for those who require the use of advanced formulas and formatting, need to access information that is not PC-based, or need to set up reports that other users will access and run. Course Description This two day information-packed seminar provides a hands-on look at some of the advanced features within Crystal Reports. It should prove of value to developers and managers who need to access non-PC based information or design reports for other users. The course opens with a review of Crystal Report fundamentals which include but are not limited to creating a basic report, adding and linking databases, and creating formulas. In addtion to the review of basic concepts, topics on creating multiple sections, conditional formats, advanced formulas, and subreports. These advanced features and others will provide the ability to further customize the presentation of data as well as adapability to changing data and users. The seminar includes demonstrations of the Crystal SQL Designer and advanced formula and Crystal dictionary creation. Seminar attendees will be provided with comprehensive notes and programming examples. Course Objectives At course completion the student will be able to perform the following tasks: Create formulas with multiple statements and use variables Understand and control the calculation process used to compile your data Control the appearance of your report using conditional format statements and multiple sections Create parameter formulas that allow your users to determine what information they want to see on a report Understand and use report alerts to notify you about data changes Enhance the analysis capability of your cross-tabs Extend your reporting capacity by utilizing subreports Access data from SQL/ODBC data sources, and generate queries using Crystal SQL Designer Create and modify dictionary files to simplify the reporting process for your users Create and edit graphical representations of your data using the Chart Expert or modify existing graphs with the Chart Analyzer Prerequisites Attendees should be experienced in the development of Crystal Reports. Experience with relational data concepts or equivalent knowledge is recommended but not required. TOPICS COVERED IN LECTURE & LAB Review Exercises Creating a Basic Report Adding and Linking Databases to a Report Selecting, Grouping, and Summarizing Creating Formulas Formatting Sections for Summary/Drill-Down Conditional Formatting Absolute versus Conditional Formatting On/Off Formatting Conditional Attribute Formatting The Highlighting Expert Restoring Conditional Formats Advanced Formulas Using Variables in Formulas Creating a Running Total Understanding Multiple-pass Reporting Using Evaluation Time Functions Creating Formulas Using Multiple Variables Multiple Sections Inserting Sections Moving Sections Splitting Sections Multiple Sections and Conditional Formats Parameter Fields What are Parameter Fields? Creating Parameter Fields Using Pick Lists Using Parameter Fields in Record Selection Using Edit Masks Using Parameter Fields to Set Sort Criteria Using the Like Statement Setting Conditional Formats Using ParameterFields Using Report Alerts What are Report Alerts Creating Report Alerts Modifying Report Alerts Deleting Report Alerts Advanced Cross-tabs Inserting Multiple Rows, Columns, and SummarizedFields Editing a Cross-tab Using Formula Fields in a Cross-tab Using Parameters in Cross-tabs Creating a Cross-tab Object for Each Group Value Subreports Identifying Subreport Features Inserting Unlinked Subreports Formatting Subreports Inserting Linked Subreport Using On-demand Subreports SQL/ODBC and Crystal SQL Designer Introducing Structured Query Language (SQL) Introducing ODBC Data Sources Introducing the Crystal SQL Designer Using a Query to Create a Report Crystal Dictionaries Defining Dictionaries Using Existing Dictionaries Creating Dictionaries Enhancing Your Dictionary Modifying a Dictionary Graphing Using Chart Types and Layouts Using the Chart Expert to CreateGraphs Modifying Existing Charts with the Chart Editor Formatting Charts

Policy