ObjectSharp logo
The Microsoft Software Development and Training Experts

Course Info

Guaranteed-to-Run
Instructor-in-Cloud
Duration: 2 days
Price: $995

Upcoming Classes

May 2013

Wed 29 - Thu 30 Register

June 2013

Thu 20 - Fri 21 Register

July 2013

Wed 10 - Thu 11 Register
Mon 29 - Tue 30 Register

August 2013

Mon 19 - Tue 20 Register

Call to register

416-649-3691

Learn from the
Pros Who Know

During this course students will have the opportunity to discuss their own projects with an ObjectSharp subject matter expert.

Home > Training > 

Crystal Reports XI - Level 2

Course Outline

Lesson 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
Lesson 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
Lesson 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
Lesson 4 - Creating Drill-downs
  1. Create a Drill-down
  2. Create Separate Headings for Drill-down Data
Lesson 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
Lesson 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
Lesson 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
Lesson 8 - Working with Prompts
  1. Create a Static Prompt
  2. Create a Dynamic Prompt
Lesson 9 - Enhancing Report Functionality
  1. Group Data Hierarchically
  2. Create a Dynamic Image
  3. Create a Report Alert
  4. Create a Geographic Map
show more>>

Guaranteed-to-Run

Our Live Instructor-in-the-Cloud classes are Guaranteed-to-Run. And you can count on it. They’re Online Live (OLL), and that means you never have to worry about cancellations caused by low enrolment or other problems. All our Guaranteed-to-Run classes run on their scheduled dates. No exceptions. No excuses. We guarantee it!

show more>>

Our outstanding ObjectSharp instructors are known throughout the IT community for their real-world business experience. We’ve teamed them up with the best IT trainers from across North America. Together, they allow us to offer a huge array of IT training classes to our clients.

From Microsoft to Oracle, from Adobe to Cisco, we’re running over 500 Live Instructor-led classes in the next 90 days alone! And almost all of them are Guaranteed-to-Run. One more reason why ObjectSharp is your best choice for IT technical training in Toronto.

Our Training Center

We encourage you to take this Instructor-Led Training: Live Online course at our downtown Toronto Training Center at 40 University Avenue. For TTC riders, we are right on the subway line just south of the St. Andrews station. For GO-Train commuters, we are just steps north of Union Station.

show more>>

In our Training Center every student gets their own powerful Dell workstation with dual monitors. Our classrooms are designed around comfortable ergonomic chairs, generous work surfaces, special air conditioning by classroom and a high-speed fibre connection to the Internet. So it really is a great place to take any of our courses.

Our Training Center

However, we understand that it is not always possible for you to take this Instructor-Led Training: Live Online course at our Center. Therefore, you have the option to take part or all of this course from an offsite location. As long as you have at least DSL-speed Internet connectivity, our Operations Staff can easily connect and join you into this Instructor-Led Training: Live Online class directly from your work, home or other location. Our Site, Your Site or Offsite. Whatever works best for you!

Microsoft Gold Certified Partner Home  |  Consulting  |  Training  |  Company
© 2012 ObjectSharp Corp.416-649-3690