Crystal Reports 2011 Level 2

Our classes are always live and instructor led from our Exton, PA or EPIC Partner locations. Springhouse AnywhereLive options require Internet Access. Select classes are Guaranteed to Run (GTR). View our complete schedule policies.

 

 

 

 

Overview

​This course is designed for people who know how to create basic list and group reports and need to create reports that include sub-reports, 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.

Intended Audience

​This course is designed for people who know how to create basic list and group reports and need to create reports that include sub-reports, 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.


At Completion

​Upon Successful Completion of this course, students will be able to:

  • Create automatic and manual running totals
  • Work with cross-tab reports
  • Add sub-reports
  • Create drill-downs in a report
  • Use SQL statements in report processing
  • Create complex formulas
  • Add charts to reports
  • Enhance report functionality

Prerequisites

​To be successful in this course, students should have completed Crystal Reports Level 1 or possess equivalent knowledge. Previous programming experience and/or SQL is also helpful.


Exams & Certifications


Materials


Course Outline

​Lesson 1: Creating Running Totals

  • Create a Running Total Field
  • Modify a Running Total Field
  • Create a Manual Running Total

Lesson 2: Working with Cross-Tabs

  • Create a Cross-Tab Report
  • Format a Cross-Tab Report
  • Create Groups in Cross-Tab Reports

Lesson 3: Adding Subreports

  • Insert a Subreport
  • Edit a Subreport
  • Share Variables

Lesson 4: Creating Drill-Downs in a Report

  • Create a Drill-Down
  • Create Headings for Drill-Down Data

Lesson 5: Using SQL Statements in Report Processing

  • Create a Report Using SQL Queries
  • Summarize Report Data
  • Create Joins Using SQL
  • Create Subqueries
  • Create a SQL Expression Field

Lesson 6: Creating Complex Formulas

  • Work with Loops
  • Work with Arrays

Lesson 7: Adding Charts to Reports

  • Create Charts
  • Create a Chart with a Drill-Down
  • Create a Top N Chart
  • Create a Cross-Tab Chart
  • Create Charts for Grouped Data
  • Format a Chart
  • Create a Chart Template

Lesson 8: Enhancing Report Functionality

  • Organize Data Based on a Hierarchy
  • Create a Dynamic Image
  • Create a Report Alert
  • Create a Geographic Map

Appendix A: Managing Reports

Appendix B: Processing Data on the Server

Appendix C: Detecting and Fixing Problems

 

 

Crystal Reports 2011 Level 2http://springhouse.com/course-catalog/CRYSTAL2011L2Crystal Reports 2011 Level 2

Get More Information
Name:

Phone:  

Email:  

Comments:

Help us prove you're not a robot:
 

 ‭(Hidden)‬ Catalog-Item Reuse

Microsoft Gold Partner

PMI R.E.P.

AXELOS Limited

The Microsoft Gold CPLS logo is a mark of Microsoft, Inc.

The PMI R.E.P. logo is a mark of the Project Management Institute, Inc.

ITIL® is a registered trade mark of AXELOS Limited.
IT Infrastructure Library® is a registered trade mark of AXELOS Limited
The Swirl logo™ is a registered trade mark of AXELOS Limited
Accredited course material is property of ITSM Academy.

Connect with us

Springhouse Education & Consulting Services

Corporate HQ:Eagleview Corporate Park
707 Eagleview Boulevard
Suite 207
Exton, PA 19341

610-321-3500 - info@springhouse.com