A hands-on instructor-led SAP Crystal Reports training course allowing people to upskill from an already good existing knowledge of Crystal Reports to further improve their ability to create more efficient and effective reports. The course allows delegates to return to work with a confidence that they can achieve tasks which require an advanced knowledge of reporting knowledge and techniques. This ability is achieved through learning, discussion and practice while working together with a master-class-level trainer in a professional classroom environment.

Pricing
- 1 Day of group training is £999 + VAT per day
- 2 Days of group training is £899 + VAT per day
- 3 Days of group training is £849 + VAT per day
- One-to-one training is £499 + VAT per day
• Using advanced formulae and functions and understanding when this is appropriate
• Enhancing reports using advanced formatting along with improved processing speed
• Report from information held in spreadsheets such as Excel data
• Create drill-down reports, inserting sub reports and managing sections for efficient reporting
• Creating CrossTab reports to summarise data, use charts and maps for visualising data
This course is aimed to foster an expert level of competence and ability using Crystal Reports amongst individuals who already possess an initial understanding of how to use Crystal Reports software.

Whats covered in this course

Advanced Formulae
- Formula Workshop
- Custom functions
- Advanced functions
- Running totals
- Variables and Arrays
- Dependency Checker
Advanced Report Formatting
- Applying a Crystal template
- Creating a template
- Setting default Report Options
Advanced Formulae
- Formula Workshop
- Custom functions
- Advanced functions
- Running totals
- Variables and Arrays
- Dependency Checker
Reporting on Excel Data
- Creating a report
- Modifying a report
- Updating the report
Managing Sections
- Adding/modifying sections
- Underlaying sections
- Drill-down reports
- Hiding and suppressing sections
- Hiding/Displaying sections conditionally
Adding Subreports
- Inserting a subreport
- Linking a subreport in a main report
- Editing a subreport
- Sharing formula between main and subreport
- Creating an on-demand subreport
Improving Report Processing Speed
- Creating an SQL Expression
- Selecting records on the Server
- Writing and editing an SQL query
- Building a Report on your SQL query
- Creating SQL commands
CrossTab Reports
- Creating a CrossTab
- Creating a specified group order
- Filtering CrossTab by group
- Changing the CrossTab format
Creating Charts and Maps
- Creating a chart
- Creating a Top N chart
- Formatting a chart
- Creating a chart template
- Creating and editing a map

How we train

Live Online Training

A fully interactive, instructor-led training course you can attend from the comfort of your own home or office. Enjoy an interactive learning session online with our most convenient and accessible method yet.
Classroom Training

We regularly host training courses in our city-centre venue. Join our experienced trainers in person for a fully interactive training session, and enjoy access to our comfortable breakout room and on-site café.
Training at Your Workplace

Looking for private training in central Scotland? Our qualified trainers can make the trip to your office, providing professional on-site training in an environment that's comfortable and familiar to you.

Send an enquiry or call us on 0141 730 0025