Crystal Reports XI: Level 2

Crystal Reports XI: Level 2 Course Description

Intended Audience for the Crystal Reports XI: 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 to make it easier for other people to create reports. They may or may not have programming and/or SQL experience.

Training Packages & Career Tracks that include the Crystal Reports XI: Level 2 Course

• Crystal Reports XI

Crystal Reports XI: Level 2 Course Objectives

• You will create complex reports using Crystal Reports' tools.
• 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.

Required Prerequisites for the Crystal Reports XI: Level 2 course

• Crystal Reports XI: Level 1

Crystal Reports XI: 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 on Detail Data
   4. Create a Manual Running Total on Summary Data
2. Building Cross-tabs in Your Report
   1. Create a Cross-tab
   2. Create a Specified Group Order
   3. Filter a Cross-tab by Group
   4. Change the Cross-tab Format
   5. Conditionally Format Rows and Columns
   6. Keep Groups Together
3. Adding Subreports
   1. Insert a Subreport
   2. Link a Subreport to a Primary Report
   3. Edit a Subreport's Structure
   4. Format a Subreport Using the Format Editor
   5. Share Variables Between Subreports and Primary Reports
   6. Create an On-demand Subreport
4. Creating Drill-downs
   1. Create a Drill-down
   2. Create Separate Headings for Drill-down Data
5. Enhancing Report Processing by Writing SQL Statements
   1. Create a Report Using SQL Queries
   2. Summarize Report Data Using SQL Aggregate Functions
   3. Create Joins Using SQL
   4. Create Subqueries
   5. Create a SQL Expression Field
6. Charting Data
   1. Create a Bar Chart
   2. Modify a Chart
   3. Format a Chart
   4. Create a Chart Template
   5. Create a Top N Chart
   6. Create a Cross-tab Chart
7. Reporting on Excel Data with Crystal Reports
   1. Create a Report Based on Excel Data
   2. Modify a Report Generated from Excel Data
   3. Update Data in a Report Based on Excel Data
8. Working with Prompts
   1. Create a Static Prompt
   2. Create a Dynamic Prompt
9. Enhancing Report Functionality
   1. Group Data Hierarchically
   2. Create a Dynamic Image
   3. Create a Report Alert
   4. Create a Geographic Map

Benefits of taking the Crystal Reports XI: Level 2 course at NetCom

• Why choose Business Objects Training at NetCom Learning?
  As a recognition for training excellence, NetCom Learning was chosen by Microsoft as the 2007 Worldwide Learning Solutions Partner of the year out of 1400 training companies.

  In addition, we have won numerous other training awards for quality and customer satisfaction by CompTIA, EC-Council and other vendors. We are simply passionate about learning and achieving the highest customer satisfaction in your learning experience!

• NetCom provides Authorized Training
  NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Platinum Partner, EC-Council Accredited Training Center, Adobe Authorized Training Center, Autodesk Authorized Training Center and many others. We are proud to offer the highest quality, authorized training solutions from our many partners for our customers.

  See our comprehensive list of partner authorizations.

• 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. Bio: 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.

  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. Bio: 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...  
• Actual Client Testimonials

  Nov 15 2011 The instructor was very knowledgeable, thorough and personable. Training will help me do my job better. - Sumit P. Course(s) Taken Crystal Reports 10.0

  
  

  Nov 15 2011 Ideal so far. I already had experience w/ Crystal but learned so much in the Level 1 course with Paul. Great class, can't wait for Level 2. - Natisha B. Course(s) Taken Crystal Reports 10.0

  
  

  Aug 17 2010 Appreciated that [the instructor] took everything step-by-step with lots of examples and review assignments to reinforce what we learned. Had very good patience and answered all questions without rushing. I learned a lot. -Yosef M. Course(s) Taken Crystal Reports XI

  
  

  Aug 17 2010 Exceptional + professional + helpful -David H. Course(s) Taken Crystal Reports XI

  
  

  Aug 17 2010 It was great. -Joel N. Course(s) Taken Crystal Reports XI

  
  

  Nov 06 2009 Training with Professor B was very beneficial as well as an exciting experience. I learned the concepts thoroughly because he made sure I understood and was following the materials. Although the material could have been really dry, [the instructor] made it fun because he has personality. Personality and good communication is key to learning. I came in to NetCom with no knowledge and I leave as a happy geek:)! -MQ Course(s) Taken Crystal Reports XI

  
  
• Awards won by NetCom
  NetCom Learning is an award winning, customer focused company. We are simply Passionate About Learning!

  See our list of awards.

• Specialized Boot Camp Training

  

  This training is also available as a boot camp. NetCom is world famous for delivering specialized boot camp training to our clients.

  For answers to questions regarding our boot camp training delivery format, please refer to our Boot Camp FAQ section.

Enrollment Options for the Crystal Reports XI: Level 2 course

• 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 an Educational Consultant.

Training Delivery Methods

• Classroom Training
  NetCom’s classroom training ensures that you have state-of-the-art tools, techniques and practices you need to succeed on the job. Our instructors are active practitioners and true masters in their fields. With convenient classes at multiple learning centers across the US, you never have to go far to get ahead.

• Live Online Training (LOT)
  NetCom’s premium Live Online Training (we call it LOT) is the ultimate in convenience and cost-effectiveness. LOT combines interactive video instruction via the latest web conference technology, and post-class access to learning labs for a best-in-class learning experience.
  Learn more about LOT

• Boot Camp Training
  NetCom’s intensive boot camps are designed to advance your skills in the shortest possible amount of time and get you certified. Boot camps go at a faster pace and often run for longer days, so you must have some level of subject matter experience before enrolling. Boot camps have mandatory assessment tests to ensure no one will slow down the class for other students. Learn more about Boot Camps

• Private Onsite Training
  With NetCom’s private training programs, you decide where and when courses are held. Tailor the training to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique. Save money by doing bulk customized training.
  Learn more about Private Onsite Training

• Private 1-on-1 Training
  NetCom’s private 1-on-1 training focuses on the highest quality training possible. You get individualized, full attention from the instructor and you decide where and when courses are held. The training is custom tailored to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique.
  Learn more about Private 1-on-1 Training

Call us Toll-free at 1-888-563-8266 FREE Training Inquiry form Website Live Chat Contact us via Email: info@netcomlearning.com