Crystal Reports 9.0: Level 2 Course Description
In this course, students will use Crystal Reports 9.0 to create more sophisticated reports like subreports and cross-tabs, students will also learn how to increase the speed and efficiency of your reports by using SQL queries and dictionaries.
Intended Audience for the Crystal Reports 9.0: Level 2 Course- This course is designed for a person who needs output from a database. In some cases, database programs have limited reporting tools, and/or they may not have access to those tools. They may or may not have programming and/or SQL experience.
Crystal Reports 9.0: Level 2 Course Objectives
- Create running totals in a report.
- Build cross-tabs in your report.
- Add subreports to a report.
- Improve processing speed in your reports.
- Build a dictionary.
- Chart single and multiple data series.
- Report from Excel data.
Required Prerequisites for the Crystal Reports 9.0: Level 2 course
Crystal Reports 9.0: Level 2 Course Outline
- 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
- Building Cross-tabs in Your Report
- Create a Cross-tab
- Create a Specified Group Order
- Filter Cross-tab by Group
- Change the Cross-tab Format
- Format Rows and Columns
- Keep Groups Together
- Adding Subreports
- Insert a Subreport
- Link a Subreport to Data in a Primary Report
- Edit a Subreport
- Format a Subreport Object
- Share Formulas Between Main and Subreports
- Create an On-demand Subreport
- Improving Report Processing Speed
- Create a SQL Expression
- Select Records on the Server
- Write a SQL Query
- Edit a SQL Query
- Build a Report on a SQL Query
- Create SQL Commands in the Crystal Report Environment
- Building Dictionaries
- Create a Dictionary
- Organize the View of Data in a Dictionary
- Adding Graphics to the Dictionary
- Build a Report Based on a Dictionary
- Charting Data
- Create a Chart
- Modify a Chart
- Update the Report
Benefits of taking the Crystal Reports 9.0: 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
- 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.
|
- 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.
|
-
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 |
|
|
|
|
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 |
|
|
|
|
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 |
|
|
|
|
Aug 17 2010 |
| Exceptional + professional + helpful -David H.
|
| Course(s) Taken |
|
|
|
|
Aug 17 2010 |
| It was great. -Joel N.
|
| Course(s) Taken |
|
|
|
|
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 |
|
|
|
-
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 9.0: 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
Take this training with one of the following 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
Contact us
|
|