Cover image for Seagate Crystal reports 7 for dummies
Seagate Crystal reports 7 for dummies
Wolf, Douglas J., 1956-
Personal Author:
Publication Information:
Foster City, CA : IDG Books Worldwide, [1999]

Physical Description:
xvii, 389 pages : illustrations ; 24 cm.
General Note:
Includes index.
Title Subject:
Format :


Call Number
Material Type
Home Location
Item Holds
HF5719 .W65 1999 Adult Non-Fiction Central Closed Stacks

On Order



Businesses all over the world rely on Crystal Reports to turn dull data into compelling reports that become critical decision-making tools. Now, with Crystal Reports 7 and Seagate Crystal Reports 7 For Dummies, you can use your current database program to create reports that look great, from simple one-table reports to integrated presentations with all the bells and whistles.

Crystal Reports is the simple solution to the problem of generating reports. Whether you're a beginner or a seasoned Crystal Reports user, and whatever your database software, Seagate Crystal Reports 7 For Dummies opens up a whole new world of high-performance information management. Discover helpful advice on how to know what questions to ask before you start researching your report and how to use new Crystal Reports 7 features (such as Geographic Mapping, the Highlighting Expert, Running Totals, and tools for creating Web-ready reports). Customize reports for your audience by creating cross-tab and summary reports, and add new levels of snap and sophistication with graphs, pictures, logos, and embedded objects. Master the art of selecting, sorting, and grouping report records, and save time by inserting ready-to-use or custom formulas into your reports. Link your databases and distribute your finished reports through your Web site as HTML, Excel, or runtime files.

You don't need to be a database guru to make Crystal Reports the most important part of your arsenal of data management tools. Just grab this great, plain-speaking guide and start work today.

Author Notes

About the Author Douglas Wolf is the author of more than 24 books. He writes for several software-specific publications, produces software training videos, and is a radio talk show host.

Table of Contents

Introductionp. 1
About This Bookp. 1
Foolish Assumptionsp. 2
How This Book Is Organizedp. 2
Conventions Used in This Bookp. 5
Icons Used in This Bookp. 6
Where to Go from Herep. 6
Part I What You Need to Know to Survivep. 7
Chapter 1 Setting the Tablep. 9
In the Beginning, There Was a Tablep. 9
Form Follows Functionp. 11
Table for . . . One or More?p. 12
Planning the Reportp. 13
Chapter 2 Creating a Simple Reportp. 15
Starting Crystal Reportsp. 15
Creating a New Reportp. 16
Using the Design Tabp. 21
Inserting Data Fieldsp. 23
Taking a Previewp. 26
Inserting a Second Fieldp. 27
Browsing Datap. 29
Moving a Field in the Preview Tabp. 33
Using Guidelines and Rulers to Position Objectsp. 35
Using Guidelines in Previewp. 36
Using Gridsp. 37
Using the Report Gallery Expertsp. 38
Chapter 3 Crystal Reports: Basic Skillsp. 43
Opening a Saved Reportp. 43
Inserting Text Objectsp. 46
Adding a Number Fieldp. 56
Aligning Columns and Headersp. 57
Getting the Numbers Formattedp. 60
Using the Highlighting Expertp. 62
Moving from Page to Page in a Reportp. 65
Magnifying the Pagep. 66
Part II Manipulating Recordsp. 71
Chapter 4 Selecting Recordsp. 73
What Is Selecting Records?p. 73
Using the Select Expertp. 74
Removing Record Selectionp. 86
Using a Parameter Fieldp. 87
Chapter 5 Sorting and Grouping Recordsp. 95
Sorting Recordsp. 96
Breaking Tiesp. 97
Inserting Groupsp. 98
Group Name Settingp. 99
Group Tree Optionsp. 102
Viewing Groups in the Design Tabp. 102
Inserting a Totalp. 104
Changing a Groupp. 111
Doing a Top N Sortp. 113
Part III Formatting and Formulas for Successp. 115
Chapter 6 Graphing and Mapping Datap. 117
Creating a Map from a Reportp. 117
Creating and Inserting a Graphp. 118
Creating a Group Graphp. 118
Modifying a Graphp. 124
Drilling Down on a Graphp. 133
Changing the Graph Typep. 136
Using a Chart Templatep. 136
Chapter 7 Using the Crystal Formula Languagep. 149
What Is a Formula?p. 149
Acquainting Yourself with the Parts of a Formulap. 150
Opening the Formula Editorp. 150
Syntax 101p. 154
Going Down the Road to Creating a Formulap. 155
Eliminating Blank Records with a Formulap. 156
Creating a Formulap. 157
Adding a Formula That Totals by Groupp. 163
Adding a Formula That Calculates a Percentage of Totalp. 166
Entering a Running Totalp. 167
Working with Text Stringsp. 170
Changing Numbers to Wordsp. 172
Going on a Datep. 174
Using If-Then-Else Formulasp. 177
Understanding Boolean Formulasp. 183
Creating a Record Selection Formulap. 185
More Formulas to Tryp. 187
More Help on Formulasp. 190
Chapter 8 Using Conditional Formattingp. 193
Absolute versus Conditional Formattingp. 193
Using On or Off Propertiesp. 194
Using Attribute Propertiesp. 194
Chapter 9 Creating a Subreportp. 201
When Do I Add a Subreport?p. 202
Creating a Scenariop. 202
Adding the Subreportp. 203
Viewing the Linked Subreportp. 205
Options for Subreportsp. 206
Part IV Putting On Some Finishing Touchesp. 207
Chapter 10 Formatting Sections of a Reportp. 209
Changing the Size of a Sectionp. 209
Formatting Sections with the Seciton Expertp. 218
Chapter 11 Creating Presentation-Quality Reportsp. 229
Quickly Formatting a Reportp. 229
Zooming In on the Reportp. 233
Working with Special Fieldsp. 235
Inserting a Special Fieldp. 238
Inserting Lines and Boxesp. 252
Drawing a Box around an Objectp. 259
Text Objects Extrap. 260
Inserting a Picture or Logo into the Reportp. 263
Inserting an OLE Objectp. 265
Using Auto Arrange to Format Reportsp. 266
Part V Creating Specific Types of Reportsp. 269
Chapter 12 Creating a Cross-Tab Reportp. 271
Identifying the "By" Wordp. 271
Creating a Cross-Tab Object in a New Reportp. 272
Inserting a Cross-Tab into an Existing Reportp. 278
Creating a Cross-Tab by Using the Cross-Tab Expertp. 283
An Advanced Idea!p. 289
Chapter 13 Creating a Summary Reportp. 291
Chapter 14 Linking to Other Databasesp. 297
Linking Conceptsp. 297
Working with Linksp. 300
Using SQL Joinsp. 312
Part VI Disseminating Reports without a Hitchp. 319
Chapter 15 Distributing Reportsp. 321
What Is an Export File?p. 321
Exporting Reportsp. 322
Setting Up an ODBC Data Sourcep. 336
Mailing a Reportp. 338
Faxing a Reportp. 339
Compiling a Crystal Reports Reportp. 340
Using the Report Distribution Expertp. 342
Printing the Distributed Reportp. 349
Web Reportingp. 351
Chapter 16 Setting Your File Optionsp. 353
The Layout Tabp. 354
The New Report Tabp. 357
The Database Tabp. 358
The SQL Tabp. 359
The Editors Tabp. 360
The Reporting Tabp. 361
The Fields Tabp. 363
The Fonts Tabp. 365
The OLAP Tabp. 366
Part VII The Part of Tensp. 367
Chapter 17 Ten Questions to Ask Before You Create a Reportp. 369
How sensitive is the information in the report?p. 369
From what databases, views, or tables do you need to include information in this report, and what fields do you want to include in the report?p. 370
Do you want all the records in the report or a subset?p. 370
How do you want the data grouped?p. 370
How do you want the data sorted?p. 370
What summary calculations do you want in the report?p. 371
What text do you want to appear in thep. 371
Do you want certain data to stand out?p. 371
How should the report be distributed and to whom?p. 371
When do you need to see this report, and when should it be distributed?p. 371
Is this how the report should look?p. 372
Chapter 18 Ten Tricks to Enhance Reportsp. 373
Use a predictable formatp. 373
Allow generous white spacep. 374
Position report headings and page numbers in the same place for every reportp. 374
Make data easy to understandp. 374
Place and align columns appropriatelyp. 375
Keep columns consistentp. 375
Use column headers strategicallyp. 375
Visually group datap. 376
Add graphs and/or maps to make your reports more descriptivep. 376
Add graphics to your report to make it visually interestingp. 376
Indexp. 377
Book Registration Information