About This Training Course

In this tCrystal Reports XI - Level 2 Training Course, students will learn how to create more sophisticated reports including subreports and cross-tabs, and how to increase the speed and efficiency of your reports by using SQL queries.

Subjects Covered

This Crystal Reports XI - Level 2 Training Course will cover the following subjects:

• Create a Running Total Field
• Modify a Running Total Field
• Create a Manual Running Total on Detail Data
• Create a Manual Running Total on Summary Data

Lesson 2: Building Cross-tabs in Your Report
• Create a Cross-tab
• Create a Specified Group Order
• Filter a Cross-tab by Group
• Change the Cross-tab Format
• Conditionally Format Rows and Columns
• Keep Groups Together

Lesson 3: Adding Subreports
• Insert a Subreport
• Link a Subreport to a Primary Report
• Edit a Subreport's Structure
• Format a Subreport Using the Format Editor
• Share Variables Between Subreports and Primary Reports
• Create an On-demand Subreport

Lesson 4: Creating Drill-downs
• Create a Drill-down
• Create Separate Headings for Drill-down Data

Lesson 5: Enhancing Report Processing by Writing SQL Statements
• Create a Report Using SQL Queries
• Summarize Report Data Using SQL Aggregate Functions
• Create Joins Using SQL
• Create Subqueries
• Create a SQL Expression Field

Lesson 6: Charting Data
• Create a Bar Chart
• Modify a Chart
• Format a Chart
• Create a Chart Template
• Create a Top N Chart
• Create a Cross-tab Chart

Lesson 7: Reporting on Excel Data with Crystal Reports
• Create a Report Based on Excel Data
• Modify a Report Generated from Excel Data
• Update Data in a Report Based on Excel Data

Lesson 8: Working with Prompts
• Create a Static Prompt
• Create a Dynamic Prompt

Lesson 9: Enhancing Report Functionality
• Group Data Hierarchically
• Create a Dynamic Image
• Create a Report Alert
• Create a Geographic Map

Other Information

This Crystal Reports XI - Level 2 Training Course can also be completed by the Walk-In Classroom Learning method. The New Horizons Walk-In Learning methodology was developed by industry professionals and certified trainers to provide a method of training that combines the least amount of time away from the office, with the most time dedicated to learning what they need to know.

The Walk-In Learning Approach: When students arrive at a New Horizons Walk-In centre, they are greeted by the mentor (a certified trainer with industry expertise) who will be mentoring and guiding them through their training. They are then assigned their own networked workstation containing two monitors. This environment allows for simultaneous access to the lecture delivered via recorded audio and video, and a live lab environment.

Why Walk-In Learning?

Flexible Scheduling: Flexible course schedules allow the student to determine when they attend training. The training schedule can be built around a work schedule so productivity in the workplace is maintained.

Focus on and learn relevant modules: Not every course is entirety relevant to a student’s needs. The Walk-In classroom allows you to focus on modules which are more relevant to the technology environment you work in and to your specific learning needs.

Time away from the office now reduced to ONE day blocks: Traditional ILT (Instructor Led Training) courses involved IT staff taking five continuous days out of the office to attend the course. This impacted the business and service levels. In the Walk-In classroom you can pick the days of training and create a custom attendance schedule to suit your calendar, projects and convenience.

If you need further information contact Startnextweek.com.au on 1300 728 102