Crystal Reports 2008 Level 2

In this course, you'll create complex reports & data sources using Crystal Reports' tools. You will not only create more sophisticated reports including subreports &cross-tabs, but also increase the speed & efficiency of your reports by using SQL queries

Course Outline

Until now, you have used Crystal Reports to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, you will create complex reports and data sources using Crystal Reports' tools. You will not only create more sophisticated reports including subreports and cross-tabs, but you will also 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.

Target Student: 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 that make it easier for other people to create reports. They may or may not have programming and/or SQL experience.

Performance-Based Objectives Upon successful completion of this course, students will be able to:
·              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.

Course Content 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: Summarize 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: Organize Data Based on a Hierarchy
Topic 8B: Create a Dynamic Image
Topic 8C: Create a Report Alert
Topic 8D: Create a Geographic Map
 
Appendix A: Managing Reports
 
Appendix B: Processing Data on the Server
 
Appendix C: Detecting and Fixing Problems

Additional Details

Pre-Requisites

Crystal Reports® 2008: Level 1. A knowledge of programming and/or SQL would also be helpful.

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