Crystal Reports XI Training

Crystal Reports XI Training Videos on CD or DVD

Crystal Reports XI Training Course

Hosted by Jason Manibog
8 Hours of Crystal Reports Training on CD or DVD

In this Crystal Reports training you will learn how to take advantage of the powerful reporting features built into Crystal Reports XI. Crystal Reports instructor Jason Manibog, begins by introducing the basic concepts of Crystal Reports such as using formulas, building groups, building reports, working with records, and creating charts. As the course progresses Jason covers many advanced features such as 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.

Crystal Reports XI Training Series

w/e-Study Guides

Part#: mk-crexi | Contents: Set of 4 CD-ROMs or via 2 Year Online access

Format

Reg: $319.00
Sale: $299.00
*No tax except for Maryland (USA) residents.

Shipping: Economy shipping allow 4-7 business days for delivery*

Payment options:

Order securely online or call 1-888-797-4040 (301-589-3349)

All major credit cards (Visa, MasterCard, Amex, and Discover)

PayPal: Pay online quickly with your PayPal account

Company PO's accepted (Net 30); Call for multi-user license

CD-ROM based trainingMultimedia CD-ROM & DVD Based Training:
With CD & DVD based training, the lectures were video taped and then digitized and are presented to you in Full Motion Video, Audio, & Graphics. DVD-ROMs will run only on a computer DVD Drive and will not run on a TV DVD Player. DVD-Video will run on both a computer DVD Drive and a TV DVD Player.

System Requirements: 400 MHz Processor (minimum), CD-ROM Drive (for CDs), DVD Drive (for DVD-ROMs & DVD-Videos) or TV DVD Player (for DVD-Videos), 64 MB RAM, Sound Card. Available Hard Disk Space 200 MB. Windows 98, NT, ME, 2000, XP, Vista, Windows 7, or Apple Mac.

Crystal Reports Trainer: Jason Manibog
Jason Manibog 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.

Course Outline - Crystal Reports XI Training:

Level 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

Level 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

Level 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

Level 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

Hands-on, Multimedia, and Self-paced Training
Featured Customers
Free Newsletter
Reg. price: $319.00
Sale price: $299.00

Format

Product Details
  • Part#: mk-crexi
  • Contents: Set of 4 CD-ROMs or via 2 Year Online access
  • Economy Shipping: Allow 4-7 business days for delivery*
Payment Options
  • Order securely online or call 1-888-797-4040 (301-589-3349)
  • All major credit cards (Visa, MasterCard, Amex, and Discover)
  • PayPal: Pay online quickly with your PayPal account
  • Company PO's accepted (Net 30); Call for multi-user license
  • *No tax except for Maryland (USA) residents.
Guarantees

Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player