Goals
- Improve performance on Crystal Reports All versions
- Create reports
- Advanced functions
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
4 days
Price
£ 1878
Audience
Consultants, developers, business intelligence project managers
Prerequisites
SQL language
Reference
BUS100047-F
Using the Repository Explorer
Saving Files to the Repository
Adding Objects or Images to the Repository
Editing Repository Objects
SQL Commands
Using functions and operators
Using Crystal language and syntax (presentation)
Functions: Strings
Nested
functions Mathematical and Boolean
functions Miscellaneous functions
Practical workshop: Miscellaneous and nested functions
Using the Project Manager: The Workbench
Using Variables and Tables
Variables
Differences between Visual Basic and Crystal Report
syntax SWITCH function (Visual or Crystal syntax)
Practical workshop: Declaration and use of variables
Model expert
Building a model without a data source
Practical workshop: Using models
Add Parameter Fields
Conditional Formatting of Fields
Lab: Creating a Simple Parameter
Creating a crosstab
Modify the options of the
crosstab wizard Customizing a crosstab without an assistant
Using calculated fields in a TC (New)
Practical workshop: Cross tables
Section management
Multi-column management
Cumulative total fields
Practical workshop: Cumulative total
Export in other formats (pdf, html, xls …)
Export of the document on a Crystal server
Practical workshop: Distribution of reports
Practical workshop: Alert report
Practical workshop: Report N Best
Practical workshop: Conditional management of dynamic images
Practical workshop: Inserting Xcelsius elements
Sessions
Contact us for more informations about session date
