Description
Who is this training for ?
For whom ?Prerequisites
Training objectives
Training program
- Introduction
- Database concepts.
- Overview of the report design environment.
- The different parts of a report in SAP Crystal Reports.
- Creating a simple report
- Connection to a data source.
- Selection of different tables from the source.
- Manual creation of links between fields of different tables (joins).
- Set linking options.
- Select the data you want in the report.
- Add a command prompt to the report.
- Formatting a list-type table.
- Visualizing the result.
- Practical work Creating reports based on different selections and presenting the results.
- Formatting
- Formatting cells.
- Positioning and sizing cells.
- Sorting on the values of one or more fields.
- Added a grouping on the values of the data source records.
- Calculation formulas.
- Visualization of the result.
- Practical work r nCreation of personalized reports, integration of calculation formulas, sorting of results, etc.
- Creation of complex reports
- Implementation of sections: footers, headers.
- Hide certain sections.
- Summary fields: subtotals, grand totals Creating other calculated fields.
- Formulas.
- The formula workshop, the four main windows for creating formulas.
- Using variables .
- Parameter field.
- Practical work Definition and creation of complex states.
- Use of variables and complex calculations.
- Elaborate formatting
- Crosstabs.
- Diagrams: data, titles, axes.
- Conditional formatting.
- Subreports linked or unlinked.
- Connecting fields.
- Practical work Creation of complete reports with integration of links and graphs.
- Diffusion
- Saving and publishing reports.
- Export formats.
- Different formats: HTML, XLS, PDF.
- Configuration of export.