Crystal Reports V11 - CCR1


Course Outline

ATS's Crystal Reports 11 training course provides comprehensive instruction in producing publication-quality statistical reports, including the basic principles of statistical analysis. This content rich course covers the practical steps you need to respond to periodic or ad hoc requests for information - using your company's own database. Expert Dr. Howard Hammerman shows you how to create reports, charts, graphs, and statistical maps that uncover the underlying trends in your company, and demonstrates the power of applying this kind of analysis to your company's business processes. At the conclusion of this training course, you will understand how to create reports with Crystal Reports 11, including understanding the basics of statistical analysis. ( 5 CD-Rom Bundle)

Module 1

Section A: Introduction · Benefits · Editions · Versions

Section B: Designing Reports · Defining the Purpose · Planning the Layout · Examples of Reports · Choosing Data · Laying Out the Report · The Workbench

Section C: Data Connections · Database Expert · Data Source Options · Access/Excel Connections · ODBC Connections · Selecting Database Objects · Database Object Types

Section D: Relational Database Review · Simple Databases · Relational Database · Fields and Records · Table Relationships · Data Types · Xtreme Sample Database

Section E: Interface Overview · Toolbars · Start Page and Report Tabs · Design/Preview Views · Field Explorer · Report/Repository Explorers · Sample Reports

Section F: Creating Basic Reports · Blank Report · Placing Fields on Reports · Previewing Field Data · Selecting/Sizing Fields · Aligning/Moving/Using Guides · Customizing Layout Options · Creating Report Titles · Finishing Touches

Section G: Previewing, Saving, and Deleting · Saving Reports · Previewing Reports · Deleting Fields

Section H: Working with Text Objects · What is Concatenation? · Adding Text Fields · Concatenating Text and Data · Editing Concatenations · Creating a Form Letter · Formatting Fields · Special Fields


Module 2


Section A: Basic Formatting · Template Expert · Page Margins and Orientation · Font and Alignment · Formatting Multiple Selections · Format Painter · Formatting Editor Options · Customizing Formatting Editor · Preview Formatting

Section B: Adding Graphical Elements · Inserting Lines · Border Styles and Colors · Drawing/Formatting Boxes · Inserting Pictures

Section C: Filtering Records · Case Sensitivity · Select Expert · Select Statements · And Statements · Or Statements · Editing Formulas · Formula Workshop · Help Menu Options

Section D: Grouping and Sorting · Insert Group · Insert Group Options · Keeping Groups Together · Group Tree · Reordering Groups · Grouping Multiple Fields · Changing/Deleting Fields · Record Sort Expert

Section E: Advanced Grouping Options · Inserting Summaries · Adding Labels · Formatting Calculations · Modifying Labels and Calculations · Creating a Grand Total · Group Sort Expert · Grouping on Data Fields

Section F: Conditional Formatting · Conditional Highlighting · Reordering Highlight Conditions · Removing Highlight Conditions · Conditional Formatting Formulas · Formatting Groups

Section G: Running Totals · Running Total Fields · Running Totals by Group · Running Total Counts


Module 3

Section A: Formula Overview · Formula Uses · Function Basics · Syntax Rules · Formula Workshop · Formula Editor

Section B: Creating Formulas · New Formula Field/Workshop · Multiplying Fields · Calculating Fax · Adding Fields · Spot Checking Calculations

Section C: Manipulating Data with Formula · Date Added · Date Add Arguments · Concatenated Formulas · Converting Dates to Text · Boolean Fields · Nested If-Then-Else Statements

Section D: Basic Parameters · Parameter Uses · Considerations · Characteristics and Options · Value Choices · Static List Parameters · Dynamic List Parameters · Exporting Data · Importing Data

Section E: Advanced Parameter Applications · Creating Dynamic Fields · Range of Dates · Range of Values · Minimums and Maximums · Default Values/Edit Masks · Selection Formulas · Sort Parameters

Section F: Formulas Timing · Passes · Pass Phase 1 · Pass Phase 2 · Specifying When Formulas Run · Variables · Declaring Variables · Setting Variables · Using Variables

Section G: Controlling Formula Runtime · Sample Report · Manual Running Totals · Resetting Running Totals · Displaying Variable Values · Suppressing Details · Refreshing the Report



Module 4
Section A: Drill-Down Summary Reports · Starting a New Report · Grouping Using Formulas · Advanced Grouping Formulas · Summarizing Groups · Hiding Sections · Viewing Hidden Sections

Section B: Charts · Standard Report Wizard · Manipulating Charts · Chart Options/Types · Data, Axes, and Options · Color Highlights and Text · Format Editor and Options · Arrange and Drill Down · Saving as Templates

Section C: Maps · Placement, Layout, and Data · Types · Titles and Legends · Preview, Pan, and Zoom · Map Context Menu · Layer Control · Zoom and Drill

Section D: Advanced Database Concepts · Using SQL · Entering SQL Queries · Linking Tables · Joins · Verifying Database Connections · Checking Dependencies · Performing Information

Section E: Subreports · Subreport Uses · Linked vs. Unlinked · How Linked Subreports Work · Creating an Unlinked Subreport · Creating a Linked Subreport · Shortcut Menu Options · On-demand Subreports

Section F: Cross-Tab Reports · Elements and Features · Cross-Tab Report Creation Wizard · Rows and Columns · Summary Fields and Grid Styles · Resizing/Aligning Fields · Contents, Labels, and Columns Options · Modifying Reports · Customizing Report Style

Module 5
Section A: Report Alerts · Creating Alerts · Alert Name and Status · Setting Alert Conditions · Triggering Alerts · Conditional Alerts

Section B: Standard Report Wizard · Using Report Wizard · Adding Fields and Grouping · Group Sorting and Charts · Filtering and Templates · Review of Experts

Section C: Exporting Reports · Export Formats · Exporting to E-mail · Export Destinations · Exporting to Excel · Exporting to PDF · Exporting to HTML · Copying Report Objects · Exporting Report Definitions

Section D: Crystal Reports Settings · Layout Options · Database Options · Formula Editor Options · Reporting Options · Field Options · Font Options

Section E: Templates · Overview · Formatting/Unformattable Objects · Creating New Templates · Inserting Template Field Objects · Formatting/Moving Fields · Adding Special Fields · Graphics and Summary Info · Saving and Applying Templates

Price £695 (Bundle of 5)

<<Back <<Contact Us