Crystal Reports Advanced training - 2 days - please call 01273 622272 for a quote
Advanced Crystal Reports training uk
This Crystal Reports training course will teach Students how to: create advanced formulas, format reports based on calculation results, use multiple sections, insert sub reports, access data from sources other than PC databases, and create user libraries.
This Advanced Crystal Reports training course is designed for users with a basic knowledge of Crystal Reports but who require the use of advanced formulas and formatting, need to access information that is not PC-based, or need to set up reports that other users will access and run.
Crystal Decisions Crystal Reports Advanced Training Course Objectives
Upon successful completion of this crystal reports training course, students will be able to:
- Create formulas with multiple statements and use variables.
- Understand and control the calculation process used to compile your data.
- Control the appearance of your report using conditional format statements and multiple sections.
- Create parameter formulas that allow your users to determine what information they want to see on a report.
- Enhance the analysis capability of your cross-tabs.
- Extend your reporting capacity by utilizing sub-reports.
- Access data from SQL/ODBC data sources, and generate queries using Crystal SQL Designer.
- Create and modify dictionary files to simplify the reporting process for your users.
- Create and edit graphical representations of your data using the Chart Expert or modify existing graphs with the Chart Analyzer.
Advanced Crystal Reports Training Course Content
Review Exercises
- Creating a basic report
- Adding and linking databases
- Selecting, grouping and summarizing
- Creating formulas
- Formatting sections for Summary/Drill-Down
Conditional Formatting
- Understand the difference between absolute and conditional formatting
- Apply and remove conditional on/off formatting
- Assign conditional attribute formatting
- Use the Highlighting Expert
- Remove conditional formatting
Advanced Formulas
- Use variables in formulas
- Create running totals
- Understand multiple pass reporting
- Use evaluation time functions
- Create formulas using multiple variables
Multiple Sections
- Insert and delete sections
- Move sections
- Split sections
- Work with multiple sections and conditional formats
Parameter Fields
- Define parameter fields
- Create parameter fields
- Create a pick list parameter field
- Use parameter fields in the record selection formula
- Use edit masks
- Use parameter fields to specify the sort criteria
- Use the Like statement
- Use parameter fields to set conditional formats
Advanced Cross-Tabs
- Insert multiple rows, columns and summarized fields
- Format cross-tab components
- Use formula fields in cross-tab layouts
- Use parameter fields with cross-tab reports
- Insert a cross-tab for each group value
Subreports
- Identify when subreports are needed
- Insert unlinked subreports
- Format subreports
- Insert linked subreports
- Create on-demand subreports
SQL/ODBC and Crystal SQL Designer
- Defining SQL
- Defining ODBC
- Use Crystal Query Designer
- Using a query to create a report
Crystal Dictionaries
- Define a dictionary
- Use existing dictionaries
- Create dictionaries
- Enhance dictionaries
- Modify a dictionary
Graphing
- Discuss chart types and layout options
- Use the Chart Expert
- Format existing graphs
Crystal Reports Course Prerequisites
To ensure your success on this crystal reports training course, we recommend that you first take the following course or have equivalent knowledge: Crystal Reports Introduction
Crystal Reports Training Recommended Reading
Crystal Reports 9: The Complete Reference - George Peck – buy from amazon
Crystal Reports 9 Standard Full Product – buy from amazon
home book this course resources 01273 622272 info@siliconbeachtraining.co.uk
Microsoft Office and Sage Accounts are skills needed in most modern businesses, we offer a full range of beginners courses, and for more advanced delegates we provide VBA for Access and VBA for Excel training courses.