Description

Duration

2 Days

12 CPD hours

This course is intended for

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.

Overview

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.

In this course, students will create a basic report by connecting to a database and modifying the report's presentation.

1 - EXPLORING THE CRYSTAL REPORTS INTERFACE

Topic A: Explore Crystal Reports

Topic B: Use Crystal Reports Help

Topic C: Customize Report Settings

2 - WORKING WITH REPORTS

Topic A: Create a Report

Topic B: Modify a Report

Topic C: Display Specific Report Data

Topic D: Work with Report Sections

3 - USING FORMULAS IN REPORTS

Topic A: Create a Formula

Topic B: Edit a Formula

Topic C: Filter Data by Using a Formula

Topic D: Work with Advanced Formulas and Functions

Topic E: Handle Null Values

4 - BUILDING PARAMETERIZED REPORTS

Topic A: Create a Parameter Field

Topic B: Use a Range Parameter in a Report

Topic C: Create a Prompt

5 - GROUPING REPORT DATA

Topic A: Group Report Data

Topic B: Modify a Group Report

Topic C: Group by Using Parameters

Topic D: Create a Parameterized Top N Report

6 - ENHANCING A REPORT

Topic A: Format a Report

Topic B: Insert Objects in a Report

Topic C: Suppress Report Sections

Topic D: Use Report Templates

7 - CREATING A REPORT FROM EXCEL DATA

Topic A: Create a Report Based on Excel Data

Topic B: Modify a Report Generated from Excel Data

Topic C: Update Data in a Report Based on Excel Data

8 - DISTRIBUTING DATA

Topic A: Export Data

Topic B: Create Mailing Labels

9 - APPENDIX

Appendix A: Setting Up and Configuring Data Sources

Appendix B: Using Report Processing Techniques

Appendix C: Using Functions in Formulas

Course Images

Crystal Reports 2016 - Part 1

By Nexus Human

Booking options

Highlights

Description

About The Provider

Tags

Reviews