Get in Touch

Course Outline

1. Overview of Crystal Reports Solutions by Business Objects

  • Exploration of available software editions and deployment models

2. Navigating the Crystal Reports Interface

  • Understanding toolbars and application menus
  • Customising the workspace environment

3. The Report Creation Workflow

  • Utilising report wizards (e.g., for mailing labels and tabular reports)
  • Establishing connections to diverse data sources
  • Importing database tables
  • Transitioning between Design and Preview modes
  • Organising report elements
  • Formatting and editing objects
  • Saving report files

4. Data Selection and Filtering

  • Defining filter parameters
  • Refining selection criteria

5. Data Structuring in Reports

  • Applying sort orders
  • Grouping data sets
  • Generating summary fields

6. Report Design and Formatting

  • Inserting images and logos
  • Adding descriptive text
  • Utilising system and special fields
  • Embedding hyperlinks
  • Managing report sections
  • Implementing conditional formatting

7. Developing Basic Formulas

  • Applying calculation logic within reports
  • Constructing custom formulas
  • Executing mathematical operations
  • Processing text strings
  • Leveraging conditional functions
  • Managing date and time values

8. Application of Basic SQL Statements

  • Integrating SQL into reports
  • Composing simple SQL queries for calculations and text operations

9. Summary Reporting: Cross-Tabulation

  • Generating Cross-Tab reports
  • Configuring Cross-Tab layouts and styling

10. Data Visualisation (Charts)

  • Preparing data for graphical representation
  • Selecting suitable chart types
  • Editing and styling charts

11. Sharing and Exporting Reports

  • Reviewing supported file formats
  • Configuring export settings and options

12. Printing Reports

  • Configuring page setup
  • Adjusting print options and settings
 14 Hours

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories