Basic Features Review
Review of basic report creation procedures
Adding objects
Positioning and resizing
Formatting
Filtering records
Grouping, sorting, totaling
Saving and previewing
Excel and Access Add-Ins
Creating a report from Excel
Creating a report from Access
Using Power Tools to Create Advanced Reports
Power Formatting with Multiple Sections
Using and manipulating multiple sections
Conditionally formatting multiple sections
Working with Cross-tabs
Understanding Cross-tabs and how they affect your data
Creating a cross-tab
Creating a cross-tab with multiple rows or columns
Setting a style
Customizing a cross-tab
Sizing columns and rows
Formatting cells both absolutely and conditionally
Suppressing rows or columns
Changing background colors
Repeating row labels
Changing the summary operation
Charting a cross-tab
Using the Running Totals Feature
Creating Running Totals in a list
Creating Running Totals for a group
Creating conditional Running Totals
Prompting with Parameters
Creating a parameter
Using a parameter field to select records
Responding to a parameter prompt
Creating a pick list
Adding a parameter value to a Text Object
Allowing multiple values
Importing a Pick List
Using multiple parameter fields in a report
Limiting the range of a parameter
Using a parameter in conditional formatting
Using an Edit Mask for string parameters
Sorting with a parameter
Problem Solving (Advanced Use of Common Features)
Advanced Linking
Adding/removing databases from the report
Working with links
Adding tables more than once to the same report
Changing join types
Creating Powerful Groups
Customizing the Group Name field
Using a field from the database
Using a formula
Creating specified order groups
Grouping based on a formula
Selecting groups based on their summary values
Grouping data hierarchically
Working with Advanced Formulas
Understanding multi-pass reporting
Using Evaluation Time functions
Working with variables
Declaring a variable
Assigning a value to a variable
Using the content of a variable
Understanding variable scope
Searching and replacing
Working with arrays
Using array variables
Using control structures
Review of if…then…else
Select statements
For loops
While loops
Safety mechanisms for loops
Running Reports Efficiently
Understanding what Crystal Reports can pass to the database for processing
Strategies for efficient report performance
Using SQL Expressions to make reports more efficient
Using the Switch function to pass processing to the database level
Subreporting as a Workaround Solution
Working with subreports
Unlinked versus Linked subreports
Creating an unlinked subreport
Linking a subreport
Database links versus subreports in one-to-many situations
Passing data from the main report into a subreport
Passing data from the subreport into the main report
Creating on-demand subreports
Creating a hyperlink
Using Structured Query Language and the Crystal SQL Designer
Understanding SQL and ODBC
Using the SQL Designer
Aggregating data in the SQL Designer
Writing a report on an SQL Query
Understanding what Crystal Can Pass to the SQL Query
Using SQL Expressions for better report performance
Appendix A – Working with Crystal Dictionaries
Appendix B – Changing the Data Source and Remapping Database Fields
Appendix C – Creating an ODBC Data Source
Appendix D – The Xtreme Sample Database
Appendix E – Reference list of functions and operators
Appendix F – Glossary