This course teaches students how to connect to databases, retrieve raw data, format the data and present it to web-based users.

Print Outline in PDF format

Using Crystal Reports, power users and developers can integrate stored data into complex reports and front-end applications for broad distribution.

Who Needs to Attend:

Individuals involved in creating reports from stored data, including data analysts, department/project/sales managers, database administrators, programmers, systems analysts and technicians.

Prerequisites:

Programming experience is helpful.

Course Content:

OVERVIEW OF CRYSTAL REPORTS

• Formatting and summarizing data

• Filtering, sorting and grouping data

• Customizing reports with program logic

• Accessing reports via a Web browser

• Adding a report to a custom application

THE CRYSTAL REPORT WRITER

• Writing a basic report

• Formatting and styling

LINKING CRYSTAL REPORTS TO DATA

• Connecting to common data sources

• Establishing data connections

INTERPRETING STRUCTURES AND RETRIEVING DATA

• Navigating complex data

• Gathering the right data

COMBINING POWERFUL REPORT TECHNIQUES

• Organizing and summarizing reports

• Building advanced reports

• Visualizing complex data

• Coding in formula language

• Writing effective formulas

• Converting to Basic Syntax

DEPLOYING REPORTS TO THE INTERNET, INTRANETS AND VISUAL BASIC

• Deploying Crystal Reports

• Publishing reports to a Web site

• Integrating with custom applications

BEYOND CRYSTAL REPORTS

• Expanding access with Seagate Analysis

• Analyzing data using an OLAP cube