Font size:

Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports 2013 enhances report building and report processing techniques with a variety of features that add value to a presentation.


TARGET AUDIENCE:
This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience.

COURSE OBJECTIVES:
In this course, you will connect to a database to extract data and present it as a report. You will: •Identify the 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 workbook.•Distribute data.

COURSE OUTLINE:


Exploring the Crystal Reports Interface

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

Working with Reports

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

Using Formulas in Reports

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

Building Parameterized Reports

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

Grouping Report Data

  • Group Report Data
  • Modify a Group Report
  • Group by Using Parameters
  • Create a Parameterized Top N Report

Enhancing a Report

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

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

Distributing Data

  • Export Data
  • Create Mailing Labels
Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
Virtual Live3/7/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days990.002522451
OH Blue Ash3/7/2018 8:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days990.002591254
Virtual Live4/10/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days990.002522454
TN Nashville4/10/2018 8:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days990.002591390
Virtual Live5/10/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days990.002522443
CA Gardena5/10/2018 8:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days990.002591132
NY Rochester5/15/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>2 days700.002520409
Virtual Live5/15/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days700.002522452
Virtual Live6/12/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days990.002522447
CT Bloomfield6/12/2018 8:00:00 AM<span class="course-type type-cv" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'HVILT')" onmouseout="clearHoverInfo()">Cv</span>2 days990.002591272
NY Rochester11/8/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>2 days700.002520412
Virtual Live11/8/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days700.002522455
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 12 of 12 items