	Online Crystal Reports IX Series (21 hours)

Summary:
Do you need to know the foundations of Crystal Reports XI? Do you want to create reports that sizzle from one or more data sources ASAP? This series will show you how to create, format, and deliver reports that get results in no time. You will learn everything from the basics of getting around in Crystal's report design environment to the subtle nuances of effective report formatting and data visualization through charting and mapping.

Audience:
This series is for anyone who wants to learn more about Crystal Reports XI.

ONLINE TRAINING INCLUDES

* Interactive online courses.
* Low prices (Only $79.95)
* A full year of complete and unlimited access to your course.
* Return to you courses as many times as you like.
* Assessment tests and certificates (if passed) after each course.

1. NAVIGATING THE DESIGN ENVIRONMENT
Time: 2 hours

This course provides an overview of the report design environment including sections, toolbars, menus, and explorers.

OBJECTIVES:
* Explain the function of report sections
* Identify the program's five main toolbars
* Describe available menu commands
* Utilize the program's explorer dialogs

TOPICS:
* Report sections
* Toolbars
* Menus
* Explorers

2. SELECTING JUST THE RIGHT DATA SOURCE(S) FOR YOUR REPORT
Time: 2 hours

This course provides an overview of working with data sources, including database drivers, data source selection, and data objects.

OBJECTIVES:
* List commonly used database drivers
* Select one or more data sources for a report
* Add data objects to a report
* Join data objects

TOPICS:
* Database drivers
* Selecting a data source
* Adding data objects
* Joining data objects

3. REPORT WIZARDS AND DO IT YOURSELF
Time: 1 hours

This course explains how to make a connection to OLE DB or ODBC databases using Xtreme Sample Database 11 in Crystal Reports XI along with how to use the Standard Report Creation Wizard.

OBJECTIVES:
* Use the report wizards to create a report.
* Create a report without the use of a report wizard.

TOPICS:
* Report wizards
* Do it yourself reporting

4. SELECTING AND ORGANIZING YOUR REPORT DATA
Time: 1 hours

This course provides an introduction to selecting and organizing report data in Crystal Reports XI.

OBJECTIVES:
* Describe the different types of field objects
* Add groups to your reports
* Reorder groups
* Create a drill-down report

TOPICS:
* Understanding field objects
* Grouping report aata
* Creating drill-down reports

5. MANIPULATING YOUR REPORT DATA IN MEANINGFUL WAYS
Time: 2 hours

This course provides an explanation for filtering data on given criteria, sorting data based on field values, and summarizing and subtotaling data.

OBJECTIVES:
* Apply basic and advanced filters
* Sort records
* Apply grand totals
* Apply group totals
* Apply a group selection and sort
* Create a running total

TOPICS:
* Basic filters
* Advanced filters
* Sorting records
* Grand totals
* Group totals
* Group selection
* Running totals

6. LETTING FORMULAS AND FUNCTIONS DO ALL THE WORK
Time: 3 hours

This course provides an introduction to formula creation and the use of functions in Crystal Reports XI.

OBJECTIVES:
* Use the Formula Workshop and Formula Editor
* Create arithmetic, date and time, and string formulas
* Discuss type conversions, control structures, and variables

TOPICS:
* The Formula Workshop
* Arithmetic formulas
* Date and time formulas
* String formulas
* Type conversions
* Control structures
* Variables
* Functions

7. CREATING DYNAMIC REPORTS WITH PARAMETERS
Time: 2 hours

In this course, you will learn to add parameter fields to provide a single report that can service very specific reporting requirements and also accommodate a large audience of business users. You will take a closer look at using parameters in your reports, as well as how parameter fields can be created and implemented.

OBJECTIVES:
* Explain the value of parameters.
* Create and implement basic parameter fields.
* Create and implement dynamic and cascading parameter fields.
* Use parameters with record selections and Top N selections.

TOPICS:
* Parameters 101
* Creating parameter fields
* Implementing parameter fields
* Using parameters with record selections
* Using parameters with Top N selections
* Dynamic and cascading parameters

8. FORMATING REPORTS THAT FUNCTION AND SIZZLE
Time: 3 hours

This course explains how to format your report using various tools in Crystal Reports XI.

OBJECTIVES:
* Position and size report objects
* Modify object properties for formatting purposes
* Use the Format Editor
* Combine and layer report objects
* Configure report page and margin properties
* Link reports
* Create ToolTips
* Add lines, boxes, and watermarks to your report

TOPICS:
* Positioning and Sizing Objects
* The Format Editor
* Modifying Object Properties
* Combining and Layering Objects
* Linking Reports
* Creating ToolTips
* Lines, Boxes, and Watermarks

9. MAKING REPORTS SECTIONS WORK FOR YOU
Time: 2 hours

This course examines the modifiable properties of report sections along with ways to apply them in professionally styled reports.

OBJECTIVES:
* Differentiate report sections
* Describe key functions of the Section Expert
* Change the background color of a report section
* Use the Fit Section command
* Manipulate a report section's general properties
* Use multiple sections within a section area to enhance a report

TOPICS:
* The Section Expert
* Section Color Properties
* Section Common Properties
* Using Multiple Report Sections

10. VISUALIZING YOUR REPORT DATA WITH CHARTS AND MAPS
Time: 3 hours

This course teaches you various charting and mapping techniques, including using the Chart and Map Experts, as well as manual chart and map formatting.

OBJECTIVES:
* Insert a chart into your report
* Modify your chart using the Chart Expert and other chart-related dialogs
* Insert a map into your report
* Modify your map using the Map Expert and other map-related dialogs

TOPICS:
* Basic Charting Options
* Advanced Charting Options
* Basic Mapping Options
* Advanced Mapping Options