This Crystal Reports 2020 Advanced course is designed to increase report design skills and discover the reporting power of Crystal Reports. Topics covered include grouping options and sub reports, formulas such as variables and functions, querying using SQL reporting and charting.
What will you learn?
At the end of this Crystal Reports 2020 Advanced course, delegates will have learned how to:
- Use advanced formula techniques including variables
- Create running totals in a report
- Understand and optimise the three stage processing of reports
- Learn basic SQL and ODBC techniques to expand data source capabilities
- Create data dictionaries for use as report sources
- Use advanced parameter techniques and create “alerting” reports
- Use advanced section techniques and create sophisticated paging reports
- Use sub –reports (active and passive)
- Use advanced cross-tab techniques in reports.
- Graph single and multiple data series
Audience?
Report designers who want to further develop their basic report design skills using Crystal Reports.
Course Contents
Recap
- Course Files & Report Types reviewed
- Default Options & Settings
Formulas
- Understanding formula language & syntax
- Using functions and operators
- Using variables
- Creating, Declaring, & Assigning Formula Variables
- Using control structure
- Creating Running Totals
Multi-pass Reporting
- Multi Pass Explained
- Evaluation Time Functions
- Using Multiple Variables
Parameters
- Defining parameter fields
- Referencing a parameter
- Responding to a parameter
- Using values
- Deleting parameters
- Using Parameter Fields to select records
- Parameter Fields – to sort records & set conditional formats
Advanced Formatting (Conditional)
- Conditional On/Off Formatting
- Conditional Attribute Formatting
Grouping
- Applying specified order grouping
- Using the Group Sort Expert
- Creating a group selection based on summary
- Information
- Grouping data hierarchically
Cross-tabs
- Create a Cross-tab – using the Expert
- Filter Cross-tab by group
- Format Rows and Columns
- Multi-Level Cross Tabs
- Cross Tab Summary Operations
- Cross Tabs & Parameter Fields / Formula Fields / Group Headers
Subreports
- Insert & Edit a Subreport
- Linked/Unlinked Subreports
- Format a Subreport Object
- Share Formulas Between Main and Subreports
- Create an On-demand Subreport
- Adding captions to subreports
- Updating subreports
- Using shared variables in a subreport
SQL/ODBC & SQL Designer
- SQL Introduction & SQL Statements
- ODBC Data Source Introduction
- SQL Designer Introduction
- Create a SQL Expression
- Select Records on the Server
- Write/Edit a SQL Query
- Build a Report on a SQL Query
- Create SQL Commands in the Crystal Report Environment
Crystal Dictionaries
- Create a Crystal Dictionary
Charting Data
- Modify/Format a Chart
- Create a Top N Chart
- Create a chart Template
- Chart Data, Text and Calculations
- Charts from Cross Tabs
Report Alerts
- What Are Report Alerts
- Creating, Modifying and using Alerts
Multiple Sections
- Manipulating multiple sections, and general uses for multiple sections
- General section formatting (Reviewed)
Course Materials
Enliten IT will provide each delegate with a workbook and other useful reference materials where applicable. These may be either paper based or in Adobe pdf format or a combination thereof.
Prerequisites
Delegates must have taken the Report Design Introduction course and/or understand basic report design concepts such as linking, record selection, sorting, grouping, summarising, basic formulas, conditional reporting and section formatting. Relational database knowledge is recommended. Knowledge of programming and/or SQL would also be helpful.
Additional Information
NOTE: We only offer the SAP Crystal Reports 2020 Advanced course on a private in-house basis. For pricing and availability just pick up the phone and call us on 0845 1085481.
Enliten IT reserves the right to modify course content and materials as required in the interests of continuous course improvement, at any time, without notification.
The suggested course duration is a guideline. Course topics and duration may be modified by the instructor based upon the knowledge and skill level of the course participants.