Crystal Reports 2011 Allows You to get Ahead
Welcome to Makintouch Consulting
Let's Shape The Future Together
0806-403-6722, 0703-345-4196
trainings@makintouchconsulting.com

Crystal Reports 2011

Crystal Reports 2011 – Level 1

In this course, students will connect to a database to extract data and present it as a report.

Who Should Attend:
This course is designed for people who need output from a database. In some cases, database programs have limited  treportingools, and/or such tools may not be accessible. Students may or may not have programming and/or SQL experience.

At Course Completion:
Upon successful completion of this course, students will be able to:
identify elements of the Crystal Reports interface.
create and modify a basic report.
use formulas to calculate and filter data.
build a parameterized report.
group report data.
enhance a report.
create a report using data from an Excel database.
distribute data.
Prerequisite(s) or equivalent knowledge:
Access 2010 – Part 1

Outline:

Lesson 1: Exploring the SAP Crystal Reports 2011 Interface

  • Explore Crystal Reports
  • Use Crystal Reports Help
  • Customize the Report Settings

 

Lesson 2: Working with Reports

  • Create a Report
  • Modify a Report
  • Display Specific Report Data
  • Work with Report Sections

 

Lesson 3: Using Formulas in Reports

  • Create a Formula
  • Edit a Formula
  • Filter Data Using a Formula
  • Work with Advanced Formulas and Functions
  • Handle Null Values

 

Lesson 4: Building Parameterized Reports

  • Create a Parameter Field
  • Use a Range Parameter in a Report
  • Create a Prompt

 

Lesson 5: Grouping Report Data

  • Group Report Data
  • Modify a Group Report
  • Group Using Parameters
  • Create a Parameterized and Report

 

Lesson 6: Enhancing a Report

  • Format a Report
  • Insert Objects in a Report
  • Suppress Report Sections
  • Use Report Templates

 

Lesson 7: Creating a Report from Excel Data

  • Create a Report Based on Excel Data
  • Modify a Report Generated from Excel Data
  • Update Data in a Report Based on Excel Data

 

Lesson 8: Distributing Data

Crystal Reports 2011 – Level 2

The student will learn to create complex reports using Crystal Reports’ tools.

Who Should Attend:
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.
At Course Completion:
Upon successful completion of this course, students will be able to:

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

 

Prerequisite(s) or equivalent knowledge:
Crystal Reports 2011 – Level 1
Prerequisite Comments:
A knowledge of programming or SQL would be helpful.

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

Form fill

Thank you for choosing Makintouch Consulting for IT education and training.
After you fill out the online registration form, you will be contacted by a representative to confirm the details and proceed further with the process.

Loading...

Our Clients and Partners

© 2016 | Makintouch Consulting | Site by Vast DV'
24, Bamishile Street, Off Allen Avenue, Ikeja Lagos 
Phone: +234 818 001 0481 | 08064036722
Email: info@makintouchconsulting.com