Crystal Reports 8 Advanced

Course Description
Course Outline

Course Overview

Students will learn how to create advanced formulas, format reports based on calculation results, use multiple sections, insert subreports, access data from sources other than PC databases, and create user libraries.

Prerequisites

Students should have attended the Crystal Reports 8 Introduction course, and should preferably have a minimum of three months hands-on experience using Crystal Reports in a working environment.

Benefits

Students will learn how to generate reports, which their users can customize, and enhance analysis capabilities.

Target student

Users wishing to move on to a higher level of reporting skills to produce reports from external data sources, for example Access, SQL, Oracle etc. This course is designed for users who require the use of advanced formulas and formatting, need to access information that is not PC-based, or need to set up reports that other users will access and run.

We offer a range of Crystal Reports training courses

Conditional Formatting
Absolute and conditional formatting Apply and remove conditional on/off formatting Assign conditional attribute formatting Use the Highlighting Expert Remove conditional formatting
Advanced Formulas
Use variables in formulas Create running totals Understand multiple pass reporting Use evaluation time functions Create formulas using multiple variables
Multiple Sections
Insert and delete sections Move sections Split sections Work with multiple sections and conditional formats
Parameter Fields
Define parameter fields Create parameter fields Create a pick list parameter field Use parameter fields in the record selection formula Use edit masks Use parameter fields to specify the sort criteria Use the Like statement Use parameter fields to set conditional formats
Advanced Cross-Tabs
Insert multiple rows, columns and summarized fields Format cross-tab components Use formula fields in cross-tab layouts Use parameter fields with cross-tab reports Insert a cross-tab for each group value
Subreports
Identify when subreports are needed Insert unlinked subreports Format subreports Insert linked subreports Create on-demand subreports
SQL/ODBC and Crystal SQL Designer
Defining SQL Defining ODBC Use Crystal Query Designer Using a query to create a report
Crystal Dictionaries
Define a dictionary Use existing dictionaries Create dictionaries Enhance dictionaries Modify a dictionary
Graphing
Chart types and layout options Use the Chart Expert Format existing graphs

Publisher:	Business Objects
Version:	8
Length:	2 days
Course-ID:	078403

	Printer Friendly Version
	Download Outline As PDF

Related Courses

I really enjoyed the course, and was pleasantly surprised by how much I learned

- Wentworth Golf Club