Goals
- Discover Crystal Reports All versions
- Create reports
- Create formulas and charts
Program
Database concepts
Prototype development
Concept of Workbench
Creation of reports with the wizard or not
Connection to the data source
Selection of tables
Presentation of the development interface
Vocabulary
Using the wizard for creating reports
Creating reports without the wizard
Formatting fields
Report property
Recording
Practical workshop: Creating a report without the wizard
Using the selection
wizard Outer joins
Workshop: Record selection
Sorting records
Grouping data
Calculations
Summary
Practical workshop: Sorting and grouping
Adding graphic elements (lines, frames, images)
Using and formatting special fields
Practical workshop: Formatting the report
Creating and formatting sections
Practical workshop: Formatting sections
Definition and creation of formulas
Boolean type
formulas If Then Else type formulas
Calculations on dates and numbers
Handling character strings
Practical workshop: Simple formulas
Trends
Conditional formatting of data
Workshop: Conditional formatting
Using the chart wizard
Creating the chart located in a Group or in the Report Header
Discovering the different tabs
Selecting the chart type
Example of chart by group
Displaying Legends and Data Labels
Formatting axis labels
Graph options
Formatting of the legend
Practical workshop: The Graphs
Export in other formats (pdf, html, xls …)
Export of the document on a Crystal server
Practical workshop: Distribution of reports
Duration
2 days
Price
£ 943
Audience
Consultants, developers, business intelligence project managers
Prerequisites
SQL language
Business function
Reference
BUS100045-F
Sessions
Contact us for more informations about session date