Crystal Reports XI

Training Provided by Online Training Directory Receive a fundamental understanding of the concepts of Crystal Reports XI by learning to build reports, use formulas, build groups, work with records, and create charts. Crystal Reports XI Receive a fundamental understanding of the concepts of Crystal Reports XI by learning to build reports, use formulas, build groups, work with records, and create charts. Follow Jason Manibog as he teaches you many advanced features including the use of running totals, working with cross-tab reports, and utilizing subreports. Additionally, you will develop an understanding for Open Database Connectivity (ODBC) drivers, inner and outer joins, Structured Query Language (SQL), and updating and verifying data sources Your Crystal Reports XI training is presented by Jason Manibog, he has been in the IT business for the past eight years, five of those as a trainer/consultant. He has conducted numerous classes in Crystal Reports, from versions eight through 11 and has done a wide variety of consultations in Crystal Reports and other database tools, including Microsoft Access and SQL. FREQUENTLY ASKED QUESTIONS How long will it take me to complete the course? The amount of time it takes to complete the course is dependent upon the time you are able to spend in study. The actual length of the online video instruction is close to 12 hours (including the hands-on practice simulations). However to maximize the learning experience, that online video instruction is broken into many smaller topic segments that tend to be 10-15 minutes in length, and many have optional activities as well.Will I be able to work at my own pace? Yes. The modular format of the instruction method allows you to proceed according to your own pace. Your personal schedule governs your completion time.Are there any required books for the course? No. the printable materials are accessible from within each course segment and can be viewed online as well. These are included at no additional cost to you.Can I assess what I have learned? Yes. Each self-paced unit has an associated assessment quiz. From there you will be able to determine if you understood the concepts or if you still need to review the materials further.What are the advantages of taking this course online? Always accessible?on demand?single login?easy to manage?work at your own pace?these are just a few of the many advantages.

Crystal Reports XI Outcomes
After completing all four course levels, you will have gained a well-rounded education allowing you to...

1. Build reports
2. Use formulas
3. Build groups
4. Workwith records
5. Create charts

Enroll today in this course to start your learning.
Assessment
Evaluation of your performance will be based on...

1. Individual module quizzes which can be taken before or after the training section
2. Post quiz that assesses the combined topics covered within the complete courses level

Completing a self-directed course: It will be your responsibility to access the course through your individual login, learn from the one-on-one instruction segments, and assess your level of retention with the post tests. All course materials will remain accessible online for the period of the subscription access. The printable study guides can be retained indefinitely as a means of refreshing your skills after a period of time.
Session 1 1.0 What is Crystal Reports 2.0 Setting up Before You Build Reports

• 2.1 Reviewing a Sample Report Design
• 2.2 Previewing Report Data
• 2.3 Setting Default Options

3.0 Building a Report

• 3.1 Creating a Report from Scratch
• 3.2 Adding Fields
• 3.3 Re-sizing and Moving Fields
• 3.4 Adding Titles and other Special Fields
• 3.5 Saving the Report

4.0 Finding, Sorting And Filtering

• 4.1 Finding Records
• 4.2 Sorting Records
• 4.3 Filtering Records

5.0 Grouping

• 5.1 Building Groups
• 5.2 Adding Summaries
• 5.3 Formatting Groups
• 5.4 Adding Groups and Changing Group Order
• 5.5 Group Filtering

6.0 Using Basic Formulas

• 6.1 Using the Formula Workshop
• 6.2 Building a Basic Math Formula
• 6.3 Building a Basic Text Formula
• 6.4 Using Formulas in Grouping

7.0 Using the Help Section

• 7.1 Using the Help Features
• 7.2 Using the Workbench

Session 2 1.0 Working with Advanced Formulas

• 1.1 Using Formulas in Record Selection
• 1.2 Creating If, Then, Else Statements
• 1.3 Using Conversion Functions
• 1.4 Using Select Case Statements

2.0 Creating Parameters

• 2.1 Building the Parameter
• 2.2 Using Dynamic Parameters

3.0 Formatting Sections

• 3.1 Adding a Watermark
• 3.2 Basic Formatting
• 3.3 Conditional Formatting
• 3.4 Changing Conditional Data Display
• 3.5 Controlling the Display of Drill-Downs

4.0 Working With Charts

• 4.1 Creating a Chart
• 4.2 Formatting Charts
• 4.3 Modifying Charts
• 4.4 Creating a Chart by Group

5.0 Exporting Data

• 5.1 Exporting to Adobe PDF
• 5.2 Exporting to Excel
• 5.3 Exporting to the Web
• 5.4 Setting Report Definitions

6.0 Using the Report Wizard

• 6.1 Building a Standard Report
• 6.2 Building Mailing Labels
• 6.3 Formatting Mailing Labels

Contact Hours: 24 Session 3 1.0 Working with Running Totals

• 1.1 Creating Running Totals
• 1.2 Creating Conditional Running Totals
• 1.3 Creating Running Totals by Group

2.0 Utilizing Variables and Arrays

• 2.1 Using Variables
• 2.2 Using Arrays

3.0 Understanding Report Processing

• 3.1 Building a Group Summary Report
• 3.2 Reviewing Report Processing

4.0 Working with Cross-Tab Reports

• 4.1 Building Cross-Tab Reports
• 4.2 Formatting Cross-Tab Reports
• 4.3 Placing Cross-Tabs in Groups

5.0 Utilizing Subreports

• 5.1 Building an Unlinked Subreport
• 5.2 Building a Linked Subreport
• 5.3 Sharing Data between a Main Report and Subreport
• 5.4 Building On-Demand Subreports

6.0 Creating Custom Groups

• 6.1 Grouping by Formula
• 6.2 Combining Groups

Session 4 1.0 Using ODBC Drivers

• 1.1 Creating a Connection

2.0 Comparing Inner and Outer Joins

• 2.1 Changing the Join in a Report
• 2.2 Tip: Checklist for Finding Missing Data in a Report

3.0 Introducing SQL with Crystal Reports

• 3.1 Reasons for Using SQL
• 3.2 Building a Report Using SQL
• 3.3 Using the WHERE Clause
• 3.4 Using Aggregate Functions in SQL
• 3.5 Aliasing
• 3.6 Using a Subquery in a Report
• 3.7 Using SQL Expressions
• 3.8 Tip: Showing the SQL Used to Build a Report

4.0 Updating and Verifying Data Sources

• 4.1 Adding a Table to a Report
• 4.2 Setting a Datasource Location
• 4.3 Verifying a Database

5.0 Generating Report Alerts

• 5.1 Setting and Using Alerts
• 5.2 Using Alerts with Parameters

6.0 Using Templates

• 6.1 Using a Pre-Built Template on a Report
• 6.2 Setting up a Template
• 6.3 Setting up a Chart Template
• 6.4 Bonus: Creating a Custom Function

Working with Tips and Tricks

About The Training Provider: Online Training Directory

More Database Training from Online Training Directory

• Crystal Reports 8
• Database Design Concepts
• Database Management
• Oracle 10g OCA