Crystal Reports Advanced Training in New Zealand

• Create a basic report
• Create a connection to a data source
• Make simple modifications to an existing report
• Use basic formatting techniques
• Create groups in a report
• Create sub-totals and grand totals in a report
• Create basic formulas
• Perform simple filters and sorts

Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method

• Create automatic and manual running totals
• Work with cross-tab reports
• Add subreports
• Create drill-downs in a report
• Use SQL statements in report processing
• Create complex formulas
• Add charts to reports
• Enhance report functionality

Lesson 1: Creating Running Totals

• Topic 1A: Create a Running Total Field
• Topic 1B: Modify a Running Total Field
• Topic 1C: Create a Manual Running Total

Lesson 2: Working with Cross-Tabs

• Topic 2A: Create a Cross-Tab Report
• Topic 2B: Format a Cross-Tab Report
• Topic 2C: Create Groups in Cross-Tab Reports

Lesson 3: Adding Subreports

• Topic 3A: Insert a Subreport
• Topic 3B: Edit a Subreport
• Topic 3C: Share Variables

Lesson 4: Creating Drill-Downs in a Report

• Topic 4A: Create a Drill-Down
• Topic 4B: Create Headings for Drill-Down Data

Lesson 5: Using SQL Statements in Report Processing

• Topic 5A: Create a Report Using SQL Queries
• Topic 5B: Summarise Report Data
• Topic 5C: Create Joins Using SQL
• Topic 5D: Create Subqueries
• Topic 5E: Create a SQL Expression Field

Lesson 6: Creating Complex Formulas

• Topic 6A: Work with Loops
• Topic 6B: Work with Arrays

Lesson 7: Adding Charts to Reports

• Topic 7A: Create Charts
• Topic 7B: Create a Chart with a Drill-Down
• Topic 7C: Create a Top N Chart
• Topic 7D: Create a Cross-Tab Chart
• Topic 7E: Create Charts for Grouped Data
• Topic 7F: Format a Chart
• Topic 7G: Create a Chart Template

Lesson 8: Enhancing Report Functionality

• Topic 8A: Organise Data Based on a Hierarchy
• Topic 8B: Create a Dynamic Image
• Topic 8C: Create a Report Alert
• Topic 8D: Create a Geographic Map