The
Crystal Reports Environment
1. Starting Crystal Reports - FREE
2. The Menu Bar
3. Using Toolbars
4. The Design View - FREE
Creating
Data Connections
1. Creating a New Blank Report - FREE
2. The Database Expert - FREE
3. Access/Excel (DAO)
4. ADO.NET (XML)
5. Database Files
6. Java Beans Connectivity
7. JDBC (JNDI)
8. ODBC (RDO)
9. OLAP
10. OLE DB (ADO)
11. Salesforce.com
12. SAP BW MDX Query
13. SAP Info Sets
14. SAP Operational Data Source
15. SAP Table, Cluster, or Function
16. Universes
17. XML and Web Services
18. Repository
19. More Data Sources
20. Selecting Report Data and Tables
21. Making a "Favorite" Connection
22. The Data Explorer
Creating Basic
Reports
1. Adding Data Fields to a Report - FREE
2. Browsing Field Data - FREE
3. Selecting, Moving, and Resizing Fields
4. Using the “Size” and “Align” Commands
5. Creating Text Objects
6. Saving a Report
7. Previewing a Report (2011, 2008 & 11)
8. Previewing a Report (10)
9. Refreshing the Report Data
Linking Tables
in a Report
1. Basic Table Structures and Terms - FREE
2. Linking Multiple Tables - FREE
3. Table Joins
4. Enforcing Table Joins and Changing Link Types
Basic Formatting
Techniques
1. Formatting Report Objects - FREE
2. The Format Editor
3. Drawing Lines
4. Drawing Boxes
5. Format Painter
6. Formatting Part of a Text Object
7. The Template Expert
8. Inserting Pictures
Record Selection
1. The Select Expert - FREE
2. Setting Multiple Filters
3. Editing the Selection Formula
Sorting and
Grouping Records
1. The Record Sort Expert
2. The Group Expert
3. Managing Groups
4. Summarizing Groups
5. Hierarchical Groupings
6. The Group Sort Expert
Printing Reports
1. Inserting Special Fields
2. Page Setup
3. Print Setup
4. Printing Reports
Using
Formulas
1. Crystal Reports Formula Syntax
2. The Formula Workshop- Formula Editor Window
3. Creating Formula Fields
4. Crystal Syntax
5. Basic Syntax
6. Finding Function and Operator Assistance
Advanced Formatting
1. The Highlighting Expert
2. The Section Expert
3. Conditionally Formatting a Section
4. Conditionally Formatting a Field
5. Manipulating Multiple Sections
Summary Reports
1. Summarizing Report Data
2. Using the DrillDownGroupLevel Feature
Charting
1. The Chart Expert
2. Editing Charts
3. Setting General Chart Options (2011, 2008 and 10)
4. Setting General Chart Options (10)
5. Changing Chart Titles
6. Formatting Selected Chart Items (2011, 2008 and 10)
7. Formatting Selected Chart Items (10)
8. Formatting a Data Series
9. Formatting Chart Gridlines
10. Formatting a Chart Grid
11. Setting Chart Axes Options
12 . Adding Chart Trendlines
13 . Modifying a 3D Chart View
14. Using Chart Templates
15. Auto-Arranging Charts
Advanced Reporting
Tools
1. Using Running Totals
2. Creating Parameter Fields (2011, 2008 and 10)
3. Creating Parameter Fields (10)
4. Parameterized Record Selection
5. Entering Parameter Values (2011, 2008 and 10)
6. Entering Parameter Values (10)
7. Creating Subreports
8. Report Alerts
9. Report Alert Functions
Advanced Formula
Creation
1. Evaluation Time Functions
2. Declaring Variables
3. Using and Displaying Variables
4. Using Array Values
5. Using “If… Then… Else…” Statements
6. Using the “Select/Case” Statement
7. Using “For” Loops
8. Using “Do… While” Loops
9. The IIF Function
Advanced Reporting
1. Creating a Report Template
2. Exporting Report Results
3. Exporting as HTML
4. Setting Default Options
5. Setting Report Options
Using Report
Wizards
1. Using the Report Wizards
2. Report Wizard Types
3. Creating a Cross-Tab Report
Advanced Database
Concepts
1. Viewing the SQL Code
2. Using Table Aliases
3. Verifying the Database
4. Setting the Datasource Location
5. Mapping Fields
|