Crystal Reports Advanced Workshop
Workshop Description
Since you've probably completed the first workshop, or are familiar with the basics of building and modifying reports, you're ready to move ahead to create complex reports and data sources using Crystal Reports' tools. In this course, you'll not only learn how to create more sophisticated reports like subreports and cross-tabs, you'll also learn how to increase the speed and efficiency of your reports by using SQL queries and dictionaries.
Topics Covered
Lesson 1: Report Creation Review
- Review learning from the introductory session
Lesson 2: Using the Repository
- Using the repository
- Updating repository objects
Lesson 3: Formulas
- String formulas
- Nested functions
- Numbered functions
- Date and time functions
- If-then-else statements
- Select statements
Lesson 4: Managing Reports
- Using the workbench
- Publishing to BusinessObejcts Enterprise
Lesson 5: Variables and Arrays
- Defining variables
- Declaring variables
- Referencing variables
- Defining arrays
- Declaring arrays
- Referencing arrays
Lesson 6: Report Templates
- Applying report templates
- Building a template without a data source
Lesson 7: Parameters
- Common uses of parameters
- Dynamic versus static parameters
- Responding to a parameter
- Multiple parameters
- Edit masks
- Grouping with parameters
Lesson 8: Cross-tabs
- Building a basic cross-tab
- Formatting a cross-tab
Lesson 9: Report Sections
- Using the section expert conditionally
- Underlay
- Multi-column reporting
Lesson 10: Specialised Reports
- Running totals
- Form letters
- Hyperlinks
- Dynamic graphics
- Alerts
- Top N reporting
Lesson 11: Sub-Reports
- Adding a sub-report
- Changing sub-report links
- On-demand sub-reports
- Shared variables
- Linking on un-linkable data
Audience
The target audience for this session is Crystal Reports report designers.
Pre requisite Knowledge, Experience and Education
- SAP Crystal Reports Introduction Workshop
Delivery & Duration
This is a three day workshop. The training can take place either on your site or at one of our venues around the UK.
Request More Information
For more information regarding this workshop, please call today 0845 124 9495 and speak to one of our team or complete our short form below.

