Course description
Crystal Reports: Advanced
At the end of this course you will be able to: Explore the Crystal Reports interface, create a basic report and modify it, use formulas to calculate and filter data, build a parameterised report, group report data, enhance a report, create a report using data sourced from an Excel database and distribute data.
Upcoming start dates
Training Course Content
Power Formatting with Multiple Sections
- Using Multiple Sections in Reports
- Using the Section Expert to Work with Sections
- Conditionally Formatting Multiple Sections
Using the Running Totals Feature
- Understanding Running Totals
- Creating Running Totals for a List of Numbers
- Conditional Running Totals
Setting Default and Report Options
- Setting the Default Layout for Design and Preview Views
Using Advanced Formula Features
- Understanding How Crystal Reports Processes the Data
- What Is a Pass
- Using Evaluation Time Functions
- Working with Variables
- Declaring a Variable
- Assigning a Value to a Variable
- Using a Variable in a Formula
- Variable Scope
- Separating Statements in Complex Formulas
- Working with Arrays
- Understanding the Formula Evaluation Time Debugger
Using Sub reporting as a Workaround Solution
- Understanding Subreports
- Unlinked versus Linked Subreports
- Creating an Unlinked Subreport
- Linking a Subreport
- Database Links versus Subreports in One-to-Many Situations
- Formatting the Subreport
- Passing Data from the Main Report into a Subreport
- Creating On-Demand Subreports
- Creating Hyperlinks
- Using Subreports to Link "Unlinkable" Data
Creating Powerful Groups
- Customizing the Group Name Field
- Using a Field Name to Customize the Group Name
- Using a Formula to Customize the Group Name Field
- Creating Custom Groups
- Customizing Group Sort Order
- Grouping on a Formula Field
- Using Group Selection to Filter the Records in the Report
- Grouping Hierarchically
Working with Cross-Tab Reports
- Understanding How Cross-Tabs Affect Your Data
- Creating a Cross-Tab Report
- Creating a Cross-Tab with Multiple Rows or Columns
- Applying a Formatting Style to the Cross-Tab
- Customizing the Cross-Tab Format
- Changing Background Colours
- Formatting Individual Cells
- Changing the Summary Operation
- Suppressing Rows, Columns or Totals
- Repeating Row Heading for Multi-Page Cross-Tabs
- Using Alias Names for Column and Row Headings
- Charting Cross-Tabs
- Customizing Cross-Tab Group Names
- CurrentFieldValue
Report Alerts
- What are Report Alerts
- Creating Report Alerts
- Basing Report Formulas or Conditional Formatting on Report Alerts
- Creative Usage for Report Alerts
Why choose SquareOne Training
25 years' experience of delivering quality IT Training Services
All trainers Certified Microsoft Office Trainer (MOS) or higher
Public and in-house training throughout the UK
Expenses
For information on pricing for this course, please give us a call on 0151 650 6907.
This course is offered as a closed course at your office only. Please see our Training locations below for where we train.
Request info
SquareOne Training
With 30 years of experience in IT training, personal skills, and consultancy, SquareOne specialise in crafting and delivering exceptional industry leading training courses. Our extensive range of courses are tailored to cater to a diverse range of learning preferences and...
Case Studies
Excel Templates For Mexichem
At SquareOne Training we take pride in designing Spreadsheets for our customers, so we were delighted to be asked to design a solution to track staff courses and KPI alerts. This spreadsheet was implemented in 2018, but completely changed the way the company worked and made the data not only accurate but trackable.
SquareOne Deliver IT Rollout Projects to a World Leading Gas and Oil Company
Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.