Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

In this training course for SAP Crystal Reports 2011, 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. You will continue to learn the features of SAP Crystal Reports 2011 with subjects such as filtering your data, grouping reports together, and using paramaters. Finally, you will explore some more advanced features such as formula fields, using the report wizard, linking data tables, and distributing your report via email, Excel, and more. As a bonus, Guy has included a chapter on how to use the Workbench, included with Crystal Reports. By the conclusion of this video based training course for SAP Crystal Reports 2011, you will be fully capable of connecting to your data source, and creating rich, informative reports, and distributing these reports. Working files are included, to allow you to work alongside the author as he teaches you the software.

Subscriber Reviews

Average Rating: 5 out of 5 rating Based on 3 Ratings

No Subscribers have provided a review for this video.

Table of Contents

Chapter/Selection

Time

01. In The Beginning

What Will I Be Able To Do With Crystal Reports

Play Video

00:04:33

Quick Tour Of Crystal Reports Interface And Toolbars

Play Video

00:05:07

Making Use Of The Included Working Files

Play Video

00:02:52

Installing The Sample Databases Provided

Play Video

00:05:00

Changing The Datasource Of The Working Files

Play Video

00:07:00

About The Author

Play Video

00:01:44

02. Setting Up A New Report

Starting Crystal Reports And A New Report

Play Video

00:03:43

Setting Page Size Orientation For The Report

Play Video

00:02:49

Making A Connection To The Sample Access Databases

Play Video

00:05:21

Making A Connection To The Sample Excel Files

Play Video

00:03:25

Making A Connection To The Sample SQL Server Database

Play Video

00:05:19

Selecting The Correct Tables or Views

Play Video

00:05:27

Field Explorer And Sections Overview

Play Video

00:05:39

Adding And Removing Fields On The Report

Play Video

00:05:19

Field Masks And Column Header Control

Play Video

00:03:28

Browsing The Data Before Insertion

Play Video

00:02:17

Previewing The Report For The First Time

Play Video

00:02:37

Refreshing The Reports Data

Play Video

00:02:55

Saving The Report

Play Video

00:02:56

Saving The Report Without The Data

Play Video

00:02:59

03. Report Navigation

Paging Through The Report

Play Video

00:02:11

Searching For Text Within The Report

Play Video

00:04:50

Changing The Zoom In Preview And Design

Play Video

00:02:53

Using The Group Navigation Pane

Play Video

00:02:27

04. Formatting The Report

Moving And Resizing Objects On The Report

Preview

00:06:42

Using The Guides And Other Alignment Options

Preview

00:03:38

Snap To Grid Saves The Day

Preview

00:03:21

Changing The Font Style, Size And Color

Preview

00:05:10

Adding A Color Border Or Background To Controls

Preview

00:05:03

Paragraph Settings

Preview

00:02:43

Number Formatting For Numerical Data Fields

Preview

00:03:40

Currency Formatting For Money Data Fields

Preview

00:03:56

Date Formatting Options

Preview

00:04:40

Using The Format Painter

Preview

00:04:06

Adding A Hyperlink To A Field

Preview

00:05:28

Lock The Format Size And Position Of An Object

Preview

00:02:11

Default Font Formatting Options

Preview

00:04:24

Default Data Formatting Options

Preview

00:04:27

Background Colors

Preview

00:02:36

05. Using The Special Data Fields

Adding Special Date Fields

Preview

00:05:27

Inserting Page Numbers

Preview

00:04:12

Adding The File Path To The Page Footer

Preview

00:01:34

Report Author And Title Fields

Preview

00:02:31

Of What Use Are The Remaining Special Fields

Preview

00:02:41

06. Adding Non Data Items To A Report

Inserting And Editing Text Objects

Preview

00:03:11

Format Options For A Text Object

Preview

00:06:10

Adding A Horizontal Or Vertical Line

Preview

00:03:55

Formatting A Line And Controlling Its Behaviour

Preview

00:05:28

Adding And Formatting A Box

Preview

00:03:19

Adding A Box That Crosses Section Boundaries

Preview

00:03:35

Adding A Company Logo Or Other Image

Preview

00:04:31

Adding Data Fields To Non Data Text Boxes

Preview

00:04:46

Removing Non Data Items

Preview

00:01:46

07. Sorting Data

How To Sort By A Field On The Report

Preview

00:03:17

Sorting By More Than One Field

Preview

00:04:09

Sorting By Fields NOT Visible On The Report

Preview

00:01:58

Removing Sort Criteria

Preview

00:02:31

08. Filtering Report Data

Filtering A Field By Existing Values

Preview

00:05:51

Using The Different Comparison Operators With Text Fields

Preview

00:06:22

Filtering The Data By Date Fields

Preview

00:06:37

Filtering Numeric Fields

Preview

00:03:35

Removing Filters From The Report

Preview

00:02:29

Filtering By More Than One Field

Preview

00:04:08

Multiple Field Criteria And/Or

Preview

00:04:39

Using A Wildcard In Filter Criteria

Preview

00:05:03

Filtering For Empty(NULL) Fields

Preview

00:04:09

09. Grouping Reports

What Is Grouping

Preview

00:03:46

How To Add A Group

Preview

00:03:26

Formatting The Group Name

Preview

00:03:44

Enhancing The Group Header

Preview

00:03:44

Grouping A Report On Dates Or Time

Preview

00:02:40

Creating Multiple Level Groups

Preview

00:06:32

Removing A Group

Preview

00:01:40

Changing The Group Sort Order

Preview

00:03:47

Customizing Group Heading Labels

Preview

00:03:47

Group Preview Options

Preview

00:05:40

Specifying Your Own Groups

Preview

00:07:25

Swapping The Data Field For A Group

Preview

00:03:28

10. Summarizing Data

Inserting A Grand Total Field

Preview

00:06:39

Insert A Sub Total Field

Preview

00:06:39

The Effects Of Moving Summary Fields Within A Report

Preview

00:03:50

Displaying Sub Totals As A Percentage Of Grand Totals

Preview

00:06:24

Summary Fields Using Average Minimum Or Maximum

Preview

00:04:38

Creating A Summary Report By Hiding Details

Preview

00:08:25

Creating A Drilldown Report

Preview

00:03:51

Refreshing A Drilldown Report

Preview

00:03:00

Sorting Group Based On Summary Values Not Group Values

Preview

00:02:55

Using Top Or Bottom N To Filter Summary Data

Preview

00:06:03

11. Using Parameters In Reports

What Are Parameters

Preview

00:03:39

Adding A Free Text Parameter Field

Preview

00:06:19

Using A Text Parameter To Filter Data

Preview

00:06:31

Number Parameter Fields For Filtering

Preview

00:05:34

Date Fields Used In Parameters

Preview

00:05:14

Creating And Using A Pick List Parameter

Preview

00:07:00

Creating And Using A Dynamic Pick List

Preview

00:05:10

Multiple Parameter Fields

Preview

00:07:11

Deleting Parameter Fields

Preview

00:02:36

12. Formula Fields

Creating A Formula To Enhance A Report

Preview

00:06:04

Altering And Renaming A Formula Field

Preview

00:03:40

Deleting A Formula Field

Preview

00:01:40

Creating A Formula To Concatenate

Preview

00:06:14

String Manipulation Formula In Action

Preview

00:08:58

Date Formula In Action

Preview

00:07:18

Calculating Age With Crystal Reports

Preview

00:04:40

Sorting And Filtering With A Formula Field

Preview

00:03:32

Using Formula Fields While Grouping

Preview

00:04:30

Formula And Parameter Fields Working Together

Preview

00:09:11

Conditions Within Formulas

Preview

00:05:27

Using IF To Negate A NULL Concatenation

Preview

00:06:40

13. Section Formatting

Report Header And Footer Options

Preview

00:06:10

Formatting Options Of The Page Header And Footer

Preview

00:03:18

Group Header And Footer Settings

Preview

00:04:07

Details Section Formatting Including Multiple Columns

Preview

00:05:15

14. The Standard Report Wizard

The Steps Involved In The Standard Report Wizard

Preview

00:05:46

Editing A Report Generated By The Wizard

Preview

00:02:07

Using The Report Templates On Your Own Reports

Preview

00:03:51

15. Data Table Linking

Quick Overview Of Relational Databases

Preview

00:06:21

Visual Linking In Crystal Reports

Preview

00:04:34

Warning Watch For Cartesian Joins

Preview

00:04:39

Link Types And Their Effect

Preview

00:06:35

Removing Tables From A Report

Preview

00:02:53

16. Distributing The Report

Choosing The Appropriate Export Format

Preview

00:07:28

Export Directly To Email

Preview

00:04:20

Exporting Data Into 2007/2010 Excel xlsx Format

Preview

00:03:28

Exporting To The New Read Only Format To Protect Report Design

Preview

00:02:17

17. The Workbench

Opening The Workbench

Preview

00:02:11

Adding Projects And Reports To The Workbench

Preview

00:02:25

Managing Reports Within The Workbench

Preview

00:03:32

Extras

The publisher has provided additional content related to this title.


Description
Content

These files have been provided by the publisher.

  • Working_Files.zip