Course Outline
1. Overview of Crystal Reports Solutions by Business Objects
- Available software editions and deployment options
2. Navigating the Crystal Reports Interface
- Toolbars and application menus
- Workspace customization
3. Report Creation Process
- Using report wizards (e.g. mailing labels, tabular reports)
- Connecting to various data sources
- Importing tables
- Working in Design and Preview modes
- Arranging report elements
- Formatting and editing objects
- Saving reports
4. Data Selection and Filtering
- Defining filtering parameters
- Modifying selection criteria
5. Structuring Data in Reports
- Sorting data
- Grouping data
- Creating summary fields
6. Report Design and Formatting
- Inserting images and logos
- Adding text descriptions
- Using system and special fields
- Embedding hyperlinks
- Managing report sections
- Applying conditional formatting
7. Creating Basic Formulas
- Applying calculation logic in reports
- Building custom formulas
- Performing mathematical operations
- Working with text (string processing)
- Using conditional functions
- Handling date and time values
8. Using Basic SQL Statements
- Applying SQL within reports
- Writing simple SQL queries (calculations, text operations)
9. Summary Reports: Cross-Tab Tables
- Creating Cross-Tab reports
- Configuring Cross-Tab layout and appearance
10. Data Visualization (Charts)
- Preparing data for visualization
- Selecting appropriate chart types
- Editing and styling charts
11. Sharing and Exporting Reports
- Supported file formats
- Export settings and options
12. Printing Reports
- Page setup configuration
- Print options and settings
Testimonials (3)
Abhi has excellent knowledge of Alteryx and he explained things very clearly. He understood our goals and created bespoke demo datasets that were relevant to our organisation, which was very impressive. The training was well-structured and delivered at a good pace, with time for questions.
Samuel Taylor - Manchester Metropolitan University
Course - Alteryx for Data Analysis
Deepthi was super attuned to my needs, she could tell when to add layers of complexity and when to hold back and take a more structured approach. Deepthi truly worked at my pace and ensured I was able to use the new functions /tools myself by first showing then letting me recreate the items myself which really helped embed the training. I could not be happier with the results of this training and with the level of expertise of Deepthi!
Deepthi - Invest Northern Ireland
Course - IBM Cognos Analytics
Clear explanations with good examples so i could relate to my own line of work.