Crystal Reports 2011 Level: 2Newly Released

Crystal Reports 2011 Level: 2 Course Description

Duration: 2.00 days (16 hours)

You will create complex reports using Crystal Reports' tools

Next Class Dates

Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.

Back to Top

Intended Audience for this Crystal Reports 2011 Level: 2 Course

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

Back to Top

Course Prerequisites for Crystal Reports 2011 Level: 2

Back to Top

Crystal Reports 2011 Level: 2 Course Objectives

  • » 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

Back to Top

Crystal Reports 2011 Level: 2 Course Outline

      1. Creating Running Totals
        1. Create a Running Total Field
        2. Modify a Running Total Field
        3. Create a Manual Running Total
      2. Working with Cross-Tabs
        1. Create a Cross-Tab Report
        2. Format a Cross-Tab Report
        3. Create Groups in Cross-Tab Reports
      3. Adding Subreports
        1. Insert a Subreport
        2. Edit a Subreport
        3. Share Variables
      4. Creating Drill-Downs in a Report
        1. Create a Drill-Down
        2. Create Headings for Drill-Down Data
      5. Using SQL Statements in Report Processing
        1. Create a Report Using SQL Queries
        2. Summarize Report Data
        3. Create Joins Using SQL
        4. Create Subqueries
        5. Create a SQL Expression Field
      6. Creating Complex Formulas
        1. Work with Loops
        2. Work with Arrays
      7. Adding Charts to Reports
        1. Create Charts
        2. Create a Chart with a Drill-Down
        3. Create a Top N Chart
        4. Create a Cross-Tab Chart
        5. Create Charts for Grouped Data
        6. Format a Chart
        7. Create a Chart Template
      8. Enhancing Report Functionality
        1. Organize Data Based on a Hierarchy
        2. Create a Dynamic Image
        3. Create a Report Alert
        4. Create a Geographic Map

Back to Top

Do you have the right background for Crystal Reports 2011 Level: 2?

Skills Assessment

We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.

Our required skill-assessments ensure that:

  1. All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
  2. NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
  3. We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.

Take your FREE Skill Assessment test »

Back to Top

Award winning, world-class Instructors

Charles W.
- Expert in Microsoft Office applications such as Excel, Word, PowerPoint, Outlook, Project, Visio, and Access as well as Adobe Graphic and Web Designer (InDesign, Acrobat, Photoshop, Illustrator, Dreamweaver and Flash Catalyst)
- Holds an A.A.S in Graphic Design as well as various Awards and Affiliations, including MCT, MCP, MCAS, and Office 2007 Master.
- Senior Lead Trainer for over 10 years.


Charles is a Technical Trainer & Instructional Designer for over 10 years. He is a Microsoft Certified Trainer and dedicates himself to Microsoft Office applications such as Excel, Word, PowerPoint, Outlook, Project, Visio, and Access. He is also an Adobe specialist and holds a degree in Graphic Design.

Charles is well known for his high evaluation scores, achieving 8.75 out of 9 on a regular basis, teaching in one-on-one, instructor-led, and web-based environments; one of the reasons for his high evaluation is his expertise in increasing personnel performance by developing and implementing programs constructed from the job task analysis process. Charles currently teaches Adobe Graphic and Web Designer, and Microsoft Office Specialist courses at NetCom Learning.
Larry G.
- More than 14 years of experience as a Security Subject Matter Expert as well as black belt in a variety of martial arts.
- Numerous Challenge Coins from the US Government including the US Army, and the Criminal Investigation Command.
- Much acclaimed instructor at NetCom Learning, with evaluation scores of 8.8 out of 9.


Larry is a unique instructor and IT security expert. If you sit in one of his classes you might get the feeling of being in a martial arts class - That's exactly how Larry wants it! "The principles behind IT security are the same as those in a variety of martial arts," Larry says. In addition to teaching IT security for over 14 years, he has practiced martial arts since he was 13 years old and holds black belts in multiple disciplines including Tai Chi, Kung Fu, and Kick Boxing. "All of these techniques are like tools for different types of attacks," Larry explains.

Larry's excellence in certification training and passion for IT security has earned him numerous Challenge Coins from the US Government including the US Army, and the Criminal Investigation Command. He is also a much acclaimed instructor at NetCom Learning, with evaluation scores of 8.8 out of 9.
Paul B.
- Microsoft Office Specialist with over 14 years of training experience.
- Expert in the IT industry, working in the IT field since 1986.
- Highly rated instructor with an all-time average evaluation score of 8.7 out of 9.


Paul is Subject Matter Expert specializing in the Microsoft Office Suite and SharePoint end-user technologies with more than 25 years of practical experience in the IT industry. He is also a Microsoft Certified Trainer (MCT) with over 14 years of training experience.

A sought-after instructor and eternal favorite among students, his instructor feedback scores are among the industry's highest at 8.7 out of 9.0. As a trainer, his knowledge and passion for the subject matter as well as his personable nature, excellent communications skills and sense of humor are implicit in every class. NetCom Learning is proud to have Paul on our roster of IT geniuses.

See more...   See more instructors...

Back to Top

Client Testimonials & Reviews about their Learning Experience

We are passionate in delivering the best learning experience for our students and they are happy to share their learning experience with us.
Read what students had to say about their experience at NetCom.   Read student testimonials...

Back to Top