Crystal Reports 10: Level 2

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..

Course Outline

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.

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 on Detail Data
Topic 1D: Create a Manual Running Total on Summary Data

Lesson 2: Building Cross-tabs in Your Report
Topic 2A: Create a Cross-tab
Topic 2B: Create a Specified Group Order
Topic 2C: Filter a Cross-tab by Group
Topic 2D: Change the Cross-tab Format
Topic 2E: Conditionally Format Rows and Columns
Topic 2F: Keep Groups Together

Lesson 3: Adding Subreports
Topic 3A: Insert a Subreport
Topic 3B: Link a Subreport to Data in a Primary Report
Topic 3C: Edit a Subreport
Topic 3D: Format a Subreport Using the Format Editor
Topic 3E: Share Formulas Between Main and Subreports
Topic 3F: Create an On-demand Subreport

Lesson 4: Creating Drill-downs
Topic 4A: Create a Drill-down
Topic 4B: Create Separate Headings for Drill-down Data

Lesson 5: Enhancing Report Processing Using SQL
Topic 5A: Create a Report Using SQL Queries
Topic 5B: Summarize Report Data Using SQL Aggregate Functions
Topic 5C: Create Joins Using SQL
Topic 5D: Create Subqueries
Topic 5E: Create an SQL Expression Field to Promote Server-side Processing

Lesson 6: Charting Data
Topic 6A: Create a Bar Chart
Topic 6B: Modify a Chart
Topic 6C: Create a Top N Chart
Topic 6D: Format a Chart
Topic 6E: Create a Chart Template

Lesson 7: Reporting on Excel Data
Topic 7A: Create a Report Based on Excel Data
Topic 7B: Modify a Report Generated from Excel Data
Topic 7C: Update Data in a Report Based on Excel Data

Appendix A: Inserting a Geographic Map
Supplemental Lesson
Topic 1A: Insert a Map

Additional Details

Pre-Requisites

Crystal Reports 10.0: Level 1, and knowledge of programming and/or SQL would 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, and course ware fees where applicable. 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

TekSource Corporate Learning
[ View Provider's Profile ]

TekSource Learning Center
36 Lombard Street, Suite 600
Toronto, Ontario
Canada   M5C 2X3

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.

   

Hi, There was one problem with the flow. I'm not completely sure as to how best to describe it but basically, it didn't flow from one module to the next. Specifically, if I was in a particular module (say the introduction or first sub-module) and it completed, I was not automatically taken to the next sub-module within the overall module (a module being a section of the course). Feel free to give me a call to discuss at 416-686-3141.

Reviewed by Marjorie C. 2012

   

The first hour of the course was difficult due to the noisy environment. There were 3 separate software platforms being mentored by 2 instructors simultaneously. As each required unique start up instructions, it was very difficult to concentrate on the video teaching for my session in spite of the headphones as there was a significant amount of background noise. I suggest that future sessions that are mentored rather than led be done as dedicated sessions (i.e. only 1 software platform being taught at a time) to minimize the impact of this situation. Additionally, the 2 instructors had side conversations that had nothing to do with teaching the sessions and needed to be asked not to do this as I found it was hindering my ability to listen to the video lesson. Unwilling to crank the volume on the headset, I could hear them clearly over the top of the lesson I was listening to.

Reviewed by Sandy B. 2012

   

Everyone was extremely laid back, kind and courteous. I felt very comfortable and no matter who you were in contact with, all employees were approachable.

Reviewed by Safiya M. 2012

   

While the instructor had a basic understanding of Project 2010, he did not have "advanced" knowledge which was the level of the course. He had not really used the software in "real life" so didn't have any context. Whenever I had questions, he looked for answers from microsoft.com (I could have done the same). I was hoping the instructor would provided added knowledge to what I was learning from the videos.

Reviewed by Hilary S. 2012

   

Fantastic and very relevant. The instructor was very pleasant and helpful.

Reviewed by Carla D. 2012

   

Too many mistakes made in the videos, this made it confusing about what to follow and what to avoid. Seminar presenter got off-topic too much which made me pressed for time.

Reviewed by Emma K. 2011

   

There really is not enough time in one day to do all the exersizes in the training manual, watch all the videos, take the quizzes, and discuss specifc issues with the instructor. I would suggest improving the video intruction to actual take you through some of the exersizes rather than leaving you to do it on your own, because you really only learn by doing.

Reviewed by Charles N. 2011

   

Thought the directions in the book exercises exercises could be written a little clearer.

Reviewed by Robert H. 2011

   

My second course with TekSource and it's always an enjoyable experience. It's a nice clean office environment close to the subway. And the staff is excellent and helpful.

Reviewed by Neil A. 2011

   

Not instructor led hence one star rating

Reviewed by Tim M. 2011

   

The only somewhat critical comment I have is that it can be difficult to concentrate when the mentor is explaining to another student. In a small classroom setting, I guess that is just a reality of mentor-assisted training.

Reviewed by Christine W. 2011

   

Steve Meggenson understand French. He helped me a lot with my documents from work. Now I know how to use Access for my work. I should take this course 5 years ago! But, it's not too late! I want to take the monitored or coach course with Steve again because he can read and understand french!

Reviewed by Candice N. 2011

   

I wish that there had been more examples and more exercises for pivot tables and vlook up. They are very valuable tools.

Reviewed by Stephanie K. 2011

   

Very positive experience.

Reviewed by Stephanie K. 2011