Crystal Reports XI Level 2

In this course, students 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.

Course Outline

In this course, students 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.

Introducing the Acend Modern Classroom Classes Guaranteed to Run

An assessment process takes place at the start of class that results in the creation of a personalized learning plan for each participant . We integrate each individual's specific project objectives with their skill gaps to create the learning prescription. The instructor assumes the role of consultant and guides each participant through the process of filling the critical gaps identified in the learning plan.

Who Should Attend:

This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools to make it easier for other people to create reports. They may or may not have programming and/or SQL experience.

At Course Completion:

Upon successful completion of this course, students will be able to: - create running totals in a report. - build cross-tabs in your report. - add subreports to a report. - design a report that uses a drill-down. - improve processing speed in your reports. - chart single and multiple data series. - report from Excel data. - implement report prompts. - enhance report functionality.

Course Outline Lesson 1: Creating Running Totals

• 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

Additional Details

Pre-Requisites

Crystal Reports XI - Level 1

Certificates offered

Certificate of completion

Cancellation Policy

Cancellations or postponements received more than ten business days prior to the first day of the course will be subject to a 15% administration fee. The cost of the course is payable, in full, for any cancellations or postponements received within ten business days, or less, prior to the first day of the course.

Map & Reviews

Acend Corporate Learning
[ View Provider's Profile ]

Toronto Training Center
69 Yonge St
Suite 1200
Toronto, Ontario
Canada   M5H 1A1

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

I loved the Adobe InDesign course but as a new user I felt there was so much material to cover and I wanted to take my time getting familiar with the program and learning about everything. I think if the class had been 2 days instead of 1 it would have been perfect!

Reviewed by Laurel A. 2012

   

Manual provided was totally different then computer training. Expected more hands on training instead of just watching an instruction video.

Reviewed by Kellie D. 2012

   

Great

Reviewed by larissa h. 2012

   

The video - was not at all interactive - only concepts were presented. The manual completedly different from the video material. I have no objections to using different approaches but a course on any software must include interactive materials.

Reviewed by Katarina F. 2012

   

The course was set up in a way which was easy to follow. However, I thought there was a lot of information to take in the day. The instructor was very helpful and very knowledgeable.

Reviewed by Bonnie . 2012

   

The training provider, Melanie, was exceptional. She was very knowledgeable and sat with me personally for hands on training. I found the course to be long and difficult to complete in one day.

Reviewed by Bonnie . 2012

   

The amount of material was a little much (maybe an hour) to cover in the allotted time - but otherwise good.

Reviewed by Lisa K. 2011

   

The room was too cold for me. The Instructor was very helpful.

Reviewed by Agnes S. 2011

   

A co worker of mine, did not receive the certificate of completing the course. As well, I received a website to log to after the course for 30 days (The Online Support). Although the vendor ID number does not exisit. I have gone back to my contact at Last Minute Training, and haven't received any feedback from her. The course was good, the follow up, was the greatest service.

Reviewed by Jennifer S. 2011

   

Would like to have access to the on-line training materials for this course for a period of time after course completion

Reviewed by Sandra B. 2011

   

Hi - the server crashed during my session and I would like to reschedule. Can someone contact me to do this?

Reviewed by Maura A. 2011