Crystal Reports 2008 Fundamentals Video Tutorial Course

CareerVision Training
Distancia

£ 70 - (83 )
IVA inc.

Informazione importanti

  • Training
  • Beginner
  • A distanza
  • Durata:
    Flexible
  • Quando:
    Da definire
  • Invio di materiale didattico
Descrizione

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


COURSE INTRODUCTION

Crystal Reports 2008 is the market leading report writing package that allows users to create custom reports from a massive array of data storage systems.

This Crystal Reports 2008 Tutorial Video is presented by Guy Vaccaro, who has many years experience with database report writing, with and without Crystal Reports. He will help you traverse through the report writing process and build your skills so that you too can create your very own custom reports that actually tell you what you need to know rather than relying on anything supplied by any database provider.

Informazione importanti

Requisiti: 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.

Sedi

Dove e quando

Inizio Luogo
Da definire
Distance Learning

Cosa impari in questo corso?

Report Writing
Database
SQL Server
Oracle
Formatting Reports

Programma

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