Crystal Reports Part 1 (Live Online)

Overview

Discover the power of Crystal Reports in our live online course, Crystal Reports Part 1. Ideal for organizations seeking to improve their data reporting processes, this course guides you through creating a basic report, connecting to databases, and refining presentations using Crystal Reports 2016.

Gain the critical skills needed to make informed business decisions by transforming raw data into structured, meaningful reports. Learn advanced reporting techniques that simplify complex information into easy-to-understand visuals.

Version Note: Although instructed using Crystal Reports 2016, this course accommodates the 2013 and 2011 versions with minimal interface changes explained by experienced instructors. All users, regardless of the version, will easily adapt to the 2016 environment.

Course Objectives

• Connect to a database to extract and present data.
• Identify elements of the Crystal Reports interface.
• Create and modify basic reports.
• Utilize formulas for data calculation and filtering.
• Build parameterized reports and group report data.
• Enhance reports with additional elements.
• Create reports from Excel workbook data.
• Distribute data effectively.

Target Student: This course is designed for individuals needing database outputs where existing tools are limited or inaccessible. No prior programming or SQL experience is required.

Prerequisites: Basic computer skills and foundational knowledge in database concepts are necessary. Completion of Microsoft Office Access 2016: Level 1 or equivalent experience is recommended.

Course Content

1. Exploring the Crystal Reports Interface
   • Explore Crystal Reports
   • Use Crystal Reports Help
   • Customize Report Settings
2. Working with Reports
   • Create a Report
   • Modify a Report
   • Display Specific Report Data
   • Work with Report Sections
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
4. Building Parameterized Reports
   • Create a Parameter Field
   • Use a Range Parameter
   • Create a Prompt
5. Grouping Report Data
   • Group Report Data
   • Modify a Group Report
   • Group by Using Parameters
   • Create a Parameterized Top N Report
6. Enhancing a Report
   • Format a Report
   • Insert Objects in a Report
   • Suppress Report Sections
   • Use Report Templates
7. Creating a Report from Excel Data
   • Create a Report Based on Excel Data
   • Modify a Report from Excel Data
   • Update Data from Excel
8. Distributing Data
   • Export Data
   • Create Mailing Labels

University: Provider: CourseHorse

Categories:

Syllabus