Presentation, versions
Types of reports and data formatting
Customization of reports with business logic
Databases that can be used with Crystal Reports
Assistants available

Direct access to database files
Access by ODBC, OLE-DB
Other access modes

Workshop: Connection to common data sources: MySQL, SQL Server, Oracle, Access, Log files, XML etc.

Structure of a report: header, footer, details area, groupings
Presentation of the example data source
Connection to the data source and selection of tables
Selection of data in restitution
Insertion, positioning and sizing of objects
Preview and save

Workshop: Creation of basic reports and positioning

Designing sections
Annotating the header and footer
Sorting records
Grouping data
Using and formatting special fields
Adding colors, frames and images
Calculated fields

Workshop: Design of reports with quality presentations: customization, calculations and sorting

Formula calculations, field accumulation (subtotals)
Using Alerts Reports
Data Simplification with tables and graphs
Conditional Formatting
Insert hyperlinks
subreports Handling

Workshop: Creation of elaborate reports with integration of links and graphics

Construction and application of a model
Management of repository objects (SQL commands, constants, images, …)
Use of the formulas workshop (Crystal syntax, functions, operators, …)
Parameterized states: definition, use

Workshop: Application of models and parameterized reports

Project manager, publishing, sharing, planning and distribution
Export formats (HTML, PDF …)

Workshop: Using the project manager and exporting reports in different formats