Crystal Reports 2011 Video Tutorial Course

CareerVision Training

£ 70 - (83 )
IVA inc.

Informazione importanti

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

• Format: DVD-ROM
• Duration: 9.5 Hours (128 lessons)
• Instructor: Guy Vaccaro
• Platform: Windows PC or Mac


In this SAP Crystal Reports 2011 Training Video, veteran trainer Guy Vaccaro teaches you how to use this powerful enterprise-level business intelligence software. You will learn how to connect to your data sources, design reports, and distribute your reports as required.

You start by learning the basics of creating a report - making a connection to a database, selecting your tables and views, adding fields, and finally, saving your report. From there, using audio and video training techniques in this computer based training course, Guy teaches you how to format your report, and deal with special field data such as dates, non-data items, and sorting your data.

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.


Dove e quando

Inizio Luogo
Da definire
Distance Learning

Cosa impari in questo corso?

Creating Databases


In The Beginning
What Will I Be Able To Do With Crystal Reports
Quick Tour Of The SAP Crystal Reports Interface And Toolbars
Making Use Of The Included Working Files
Installing The Sample Databases Provided
Changing The Datasource Of The Working Files
About The Crystal Reports Tutor

Setting Up A New Report
Starting Crystal Reports And A New Report
Setting Page Size Orientation For The Report
Making A Connection To The Sample Access Databases
Making A Connection To The Sample Excel Files
Making A Connection To The Sample SQL Server Database
Selecting The Correct Tables or Views
Field Explorer And Sections Overview
Adding And Removing Fields On The Report
Field Masks And Column Header Control
Browsing The Data Before Insertion
Previewing The Report For The First Time
Refreshing The Reports Data
Saving The Report
Saving The Report Without The Data

Report Navigation
Paging Through The Report
Searching For Text Within The Report
Changing The Zoom In Preview And Design
Using The Group Navigation Pane

Formatting The Report
Moving And Resizing Objects On The Report
Using The Guides And Other Alignment Options
Snap To Grid Saves The Day
Changing The Font Style, Size And Color
Adding A Color Border Or Background To Controls
Paragraph Settings
Number Formatting For Numerical Data Fields
Currency Formatting For Money Data Fields
Date Formatting Options
Using The Format Painter
Adding A Hyperlink To A Field
Lock The Format Size And Position Of An Object
Default Font Formatting Options
Default Data Formatting Options
Background Colors

Using The Special Data Fields
Adding Special Date Fields
Inserting Page Numbers
Adding The File Path To The Page Footer
Report Author And Title Fields
Of What Use Are The Remaining Special Fields

Adding Non Data Items To A Report
Inserting And Editing Text Objects
Format Options For A Text Object
Adding A Horizontal Or Vertical Line
Formatting A Line And Controlling Its Behaviour
Adding And Formatting A Box
Adding A Box That Crosses Section Boundaries
Adding A Company Logo Or Other Image
Adding Data Fields To Non Data Text Boxes
Removing Non Data Items

Sorting Data
How To Sort By A Field On The Report
Sorting By More Than One Field
Sorting By Fields NOT Visible On The Report
Removing Sort Criteria

Filtering Report Data
Filtering A Field By Existing Values
Using The Different Comparison Operators With Text Fields
Filtering The Data By Date Fields
Filtering Numeric Fields
Removing Filters From The Report
Filtering By More Than One Field
Multiple Field Criteria And/Or
Using A Wildcard In Filter Criteria
Filtering For Empty(NULL) Fields

Grouping Reports
What Is Grouping
How To Add A Group
Formatting The Group Name
Enhancing The Group Header
Grouping A Report On Dates Or Time
Creating Multiple Level Groups
Removing A Group
Changing The Group Sort Order
Customizing Group Heading Labels
Group Preview Options
Specifying Your Own Groups
Swapping The Data Field For A Group

Summarizing Data
Inserting A Grand Total Field
Insert A Sub Total Field
The Effects Of Moving Summary Fields Within A Report
Displaying Sub Totals As A Percentage Of Grand Totals
Summary Fields Using Average Minimum Or Maximum
Creating A Summary Report By Hiding Details
Creating A Drilldown Report
Refreshing A Drilldown Report
Sorting Group Based On Summary Values Not Group Values
Using Top Or Bottom N To Filter Summary Data

Using Parameters In Reports
What Are Parameters
Adding A Free Text Parameter Field
Using A Text Parameter To Filter Data
Number Parameter Fields For Filtering
Date Fields Used In Parameters
Creating And Using A Pick List Parameter
Creating And Using A Dynamic Pick List
Multiple Parameter Fields
Deleting Parameter Fields

Formula Fields
Creating A Formula To Enhance A Report
Altering And Renaming A Formula Field
Deleting A Formula Field
Creating A Formula To Concatenate
String Manipulation Formula In Action
Date Formula In Action
Calculating Age With Crystal Reports
Sorting And Filtering With A Formula Field
Using Formula Fields While Grouping
Formula And Parameter Fields Working Together
Conditions Within Formulas
Using IF To Negate A NULL Concatenation

Section Formatting
Report Header And Footer Options
Formatting Options Of The Page Header And Footer
Group Header And Footer Settings
Details Section Formatting Including Multiple Columns

The Standard Report Wizard
The Steps Involved In The Standard Report Wizard
Editing A Report Generated By The Wizard
Using The Report Templates On Your Own Reports

Data Table Linking
Quick Overview Of Relational Databases
Visual Linking In Crystal Reports
Warning Watch For Cartesian Joins
Link Types And Their Effect
Removing Tables From A Report

Distributing The Report
Choosing The Appropriate Export Format
Export Directly To Email
Exporting Data Into / Excel xlsx Format
Exporting To The New Read Only Format To Protect Report Design

The Workbench
Opening The Workbench
Adding Projects And Reports To The Workbench
Managing Reports Within The Workbench