Crystal Reports 2008 Video Tutorial Course Bundle

CareerVision Training
Distancia

£ 118 - ($ 450.566)
IVA inc.

Información importante

  • Training
  • Beginner
  • A distancia
  • Duración:
    Flexible
  • Cuándo:
    A definir
  • Envío de materiales de aprendizaje
Descripción

COURSE INCLUDES
• Format: DVD-ROM
• Duration: 14 Hours (237 lessons)
• Instructor: Guy Vaccaro
• Platform: Windows PC or Mac


COURSE INTRODUCTION

This bundle includes:
Crystal Reports 2008 Fundamentals - 7.5 hrs / 152 Lessons
Crystal Reports 2008 Advanced - 6.5 hrs / 85 Lessons

In this Crystal Reports 2008 Training Bundle, you will get the beginners Crystal Reports 2008 training course, as well as the advanced Crystal Reports 2008 training course.

In the beginners video training tutorial, expert author Guy Vaccaro teaches you the basics of creating reports in Crystal Reports 2008. Covering topics ranging from importing your text based, excel based, or SQL based data, to creating the report and formatting the report, you will get the base knowledge you need to continue to the advanced training.

Información importante

Requisitos: This is a DVD Video Tutorial Course which is shipped to you. Work through the video tutorials at your own pace. If you have the software you can practice along with the instructor using the same exercise files as the instructor which are included on the DVD. The narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter. All the concepts of each application are explained clearly and precisely. The DVD works on PC and Mac. You can jump to and from lessons and work at your own pace.

Sedes

Dónde se imparte y en qué fechas

Inicio Ubicación
A definir
Distance Learning

¿Qué aprendes en este curso?

Crystal Reports
Formatting
Parameter Fields
SQL Statements
Variables

Programa académico

Getting Started

What To Expect From Crystal Reports

Opening And Viewing Different Crystal Report Types

Tour Of The Crystal Reports Interface

Crystal Reports Toolbars

What Will I Be Able To Do?


Setting Up A New Report

Starting The Report Creation Process

Setting The Page Size/Orientation For The Report

Making A Connection To An Access Database

Making A Connection To An Excel File

Making A Connection To A SQL Server Database

Selecting The Correct Tables/Views

The Sections Of A Report

Adding Fields To The Report

Removing Fields From A Report

Field Masks And Column Header Control

Browsing The Data Before Insertion

Previewing The Report For The First Time

Refreshing The Data

Saving The Report

Saving The Report With The Data

Creating A New Report - The Whole Process

Setting Up A User DSN

Changing A Reports Data Source


Report Navigation

Paging Through The Report

Searching For Text Within The Report

Group Navigation

Changing The Zoom In Preview And Design Mode


Formatting The Report

Selecting Objects For Formatting Or Resizing

Moving Objects

Resizing Objects

Using The Guides

Using The Grid

Changing The Font Style, Size And Colour - Lesson 1

Changing The Font Style, Size And Colour - Lesson 2

Adding A Colour Border Or Background To Controls

Adding A Hyperlink To A Control

Changing The Paragraph Settings

Number Formatting For Numerical Data Fields

Currency Formatting For Money Data Fields

Date Formatting For Date Data Fields

Using The Format Painter

Aligning And Resizing Multiple Controls On A Report

Setting Default Formatting For Reports

Editing The Layout Default Options


Using The Special Data Fields

Adding Data Date And Data Time Fields

Using The Print Date And Print Time Fields

Inserting Page Numbering

Adding The File Path To The Page Footer

Overview Of The Remaining Special Fields


Adding Non Data Items To A Report

Inserting And Editing Text Objects

Format Options For A Text Box

Adding Labels To Special Fields

Adding A Horizontal Line

Adding A Vertical Line

Formatting A Line

Controlling A Lines Behaviour

Controlling A Lines Position

Adding A Box

Adding A Box That Crosses Section Boundaries

Formatting A Box

Controlling A Box's Behaviour

Controlling The Size And Position Of A Box

Adding A Company Logo Or Other Image

Removing A Non Data Item


Sorting Data In A Report

How To Sort By A Field On The Report

Sorting By More Than One Field

Sorting By Data Fields Not Visible On The Report

Removing Or Changing The Sort Criteria


Filtering The Data That A Report Is Using

The Basics Of Filtering The Data

Filtering A Field By Existing Values

Filtering A Field By More Than One Value

Filtering The Data By Dates

Filtering Numeric Fields

Filtering Field Criteria Using And

Filtering Field Criteria Using Or

Editing Filters With The Select Expert

Removing Filters From The Report

Other Text Data Field Filter Options

Filtering For Nulls

Using A Wildcard In Filter Criteria


Reporting By Groups

Understanding Grouping

How To Add A Group

Group Labels And Headings

Creating A Multiple Level Group

Removing A Group

Changing The Group Sort Order

Changing The Group Name That Is Displayed

Group Preview Options

Utilizing The Group Tree Navigation Panel

Specifying Your Own Groups

Swapping The Data Field For A Group


Summarizing Data

Insert A Grand Total Field

Insert A Sub Total Field

Moving Summary Fields Within The Report

Displaying Sub Totals As A Percentage Of Grand Totals

Summary Fields Using Average, Min Or Max

Creating A Summary Report By Hiding Details

Creating A Drilldown Report

Refreshing A Drilldown Report

Sorting A Group With Summary Fields

Using Top N To Filter Summary Data

Creating A Top 10 List Of Products


Using Parameters In Reports

The Benefits Of Using Parameters

How To Add A Free Text Parameter Field

Using A String Parameter To Filter Data Records

Using A Numeric Parameter To Filter Data Records

Using A Date Parameter To Filter Data Records

Using A Parameter Field With Wildcards

Creating And Using A Pick List Parameter Field

Creating A Dynamic Pick List

Deleting A Parameter Field

Controlling The Request Order For Parameters

The Parameter View Panel


Formula Fields

How To Create Your Own Fields

A Basic Formula To Enhance The Report

Altering Or Renaming A Formula Field

Deleting A Formula

Creating A Formula To Concatenate - Lesson 1

Creating A Formula To Concatenate - Lesson 2

String Manipulation Formulas In Action

Date Formulas At Their Best

Calculating Age With Crystal Reports

Using Formula Fields In The Sort Expert And The Select Expert

Using Formula Fields While Grouping

Making The Formula Field Work With If And Else

Converting Datetime To Date Format To Improve Parameters

Creating An Address Formula With Carriage Returns


Section Formatting

The Report Header And Report Footer Options

Exploring The Formatting Options Of The Page Header And Footer

The Details Section Expert

How To Add A Watermark To A Report

Improving Headings In Drilldowns Using The Section Expert


The Standard Report Wizard

The Steps Involved In The Standard Report Wizard

The Report Template Expert


Data Table Linking

Quick Overview Of Relational Databases

Visual Linking In Crystal Reports

How To Identify Key Fields

Link Types And Their Effects When Used

Removing Links And Tables From The Report


Distributing The Report

Choosing Your Export Format

Export Directly To An Email

Export Directly To Microsoft Excel

Other Export Destinations


The Workbench

Opening The Workbench

Adding Projects To The Workbench

Managing Your Reports Using The Workbench

Removing Reports From The Workbench


Credits And Beyond

About The Trainer

Using The Files Included With This Course

Further Practice - Lesson 1

Further Practice - Lesson 2

What's Next?

CR 2008 Tutorial Wrap Up


Crystal Reports 2008 Advanced

Before We Start

What Will I Be Able To Do At The End Of This Course

Using The Files Included With This Course

Installing The SQL Server Sample Databases

About The Tutor


Getting Up To Speed

Creating A Report From Scratch

Adding And Linking Additional Database Tables

Creating A Formula Field

Sorting Data Within A Report

Grouping Reports

Adding Summary Functions

Filtering Data In The Report

Swapping The Data-source Of A Report


Conditional Formatting

Using The Highlighting Expert

Changing The Order That Conditions Are Met

Removing Highlighting Expert Conditions

Applying ON/OFF Conditional Formatting

Removing Conditional ON/OFF Formatting

Font Color Controlled By A Condition

Font Style Controlled By A Condition

Removing Or Disabling Conditional Formatting

Clever Conditional Formatting Alternating Page NOs

Clever Conditional Formatting Banded Report


Advanced Formulas Using Variables

Declaring Variables To Use In Reports

Understanding The Multiple Pass Report Generation

Making Use Of Multi-Pass In A Report

Using And Outputting Multiple Variables At Once

Using Variables In Multiple Formulas And Locations

Creating And Using User Defined Functions


SQL And Commands

Standard Query Language (SQL)

Defining Your Own SQL As The Data Source

Adding Parameters To Your Own SQL Statement


Parameter Fields

Creating A Parameter Field And Using It To Filter Data

Parameter Fields To Customize Formatting

Letting The User Change The Color Of Banded Reports

Parameter Controlled Sort Order

Making Use Of Masks In Parameters


Report Alerts

Adding An Alert To A Report

Triggering A Report Alert

Viewing Record Sets Created By Alerts

Add A Formula To Generate The Alert Message

Using A Parameter Value With A Report Alert


Multiple Sections

Inserting Extra Sections By Dividing Existing Sections

Deleting And Merging Sections

Splitting Existing Content Between Sections

Moving A Sections Position In A Report

Uses For Multiple Page Header Footer Sections

Multiple Sections Can Provide Column Headings In Drilldown Reports

Adding Continued To Page Heading When Required


Sub Reports

What Is A Sub Report

Creating And Importing An Unlinked Sub Report

Create And Insert A Linked Sub Report

On Demand Sub Reports

Hiding Sub Reports That Contain No Data

Dealing With Overlapping Sub Reports

Methods For Updating Changes Made To The Sub Report

Pass Data Between Sub And Main Report Using Variables


Cross Tabs

Adding A Cross Tab To A Report

Cross Tabs Within Group Headers Or Footers

Generating A Month Name Instead Of A Number

Making Use Of Formulas In Cross Tabs

Utilizing A Parameter Field To Control A Cross Tab

Formatting A Cross Tab And Its Components

Turning On And Off Totals

Change The Calculation Between The Rows And Columns

Placing More Than One Cross Tab On A Report

Sorting A Crosstab By The Summarized Data

Insert Multiple Rows And Or Columns

Use The Step By Step Crosstab Wizard


Charting

Creating A Chart in CR 2008

Changing The Chart Type

Formatting And Renaming The Chart Labels

Customize The Appearance Of A Given Chart

Sorting And Top N In Charts

Placing Charts Within Group Headers Or Footers

Managing Multiple Charts In A Report

A Special Case The Pie Chart

Charts Based On Cross Tabs


Crystal Reports Reader And Automated Report Distributor

Downloading The Reader And The Automated Report Distributor

Installing The Reader And The Distributor (CRD)

Report Viewer File Management

Running Reports In The Viewer

Exporting Data From The Reader

Filtering Data With The Reader

Setup And Configure CRD

Create A Simple Single Report Daily Schedule