快速掌握Crystal Reports 10入门指南

5星 · 超过95%的资源需积分: 10 123 浏览量更新于2024-08-01 收藏 9.97MB PDF 举报

"《水晶报表傻瓜教程：Crystal Reports 10 for Dummies》是一本面向初学者的实用指南，作者是Allen G. Taylor。这本书旨在帮助读者快速而有效地掌握Crystal Reports 10，这是用于创建数据库报告的强大工具。它详尽介绍了主要功能，避免了复杂的细节，使读者能够轻松生产日常所需的报告类型，包括一些不常见的需求。书中以章节形式组织，每个章节聚焦于一个特定的报告功能或操作，便于读者随需查阅。作者采用逐步指导的方式，通过实例演示如何进行常见任务，这使得学习过程既系统又直观。无论是直接负责报告制作的人员，还是对报告需求有管理职责的管理者，都能从本书中获益匪浅。书中不仅阐述了技术上的可能性，还区分了哪些操作简单易行，哪些可能需要更多时间和精力，这对于合理估计报告制作时间具有实际帮助。读者可以将这本书作为手边的参考书，根据需要查询并跟随步骤进行实践，提升报告制作技能。版权方面，本书符合1976年美国版权法的规定，未经许可，任何形式的复制、存储或传输都是受限的，需获得出版商的书面许可或者支付版权许可费用。《水晶报表傻瓜教程：Crystal Reports 10 for Dummies》是一本实用且易于理解的指南，无论你是报告新手还是希望提高工作效率的专业人士，都能从中找到适合自己的内容，提升报告设计和分析能力。"

Chapter 2: Create a Simple Report Right Now! . . . . . . . . . . . . . . . . . . .17

Starting Crystal Reports 10...........................................................................18

Creating a Report with the Blank Report Option.......................................19

Allocating more space to the layout..................................................22

Giving the report a title .......................................................................23

Choosing the fields that will appear in your report.........................25

Improving the readability of page headers.......................................26

Previewing the report ..........................................................................27

Page footers carry useful information...............................................29

Wrap things up with a report footer ..................................................30

Recording helpful information about your report ...........................31

Troubleshooting a Report That Doesn’t Look Quite Right.......................32

Printing a Report............................................................................................32

Chapter 3: Report Design Guidelines . . . . . . . . . . . . . . . . . . . . . . . . . . . .33

Audience..........................................................................................................33

Purpose ...........................................................................................................34

Content............................................................................................................35

Interfacing the Report to a Database...........................................................35

Connecting to Microsoft Access.........................................................36

Connecting to other data sources......................................................37

What Should the Report Look Like? ............................................................38

Making a good first impression ..........................................................39

Deciding how best to present the information.................................39

Should the report include graphs, charts, or pictures?..................40

Style communicates meaning, too .....................................................40

Does the report convey the message?...............................................41

Chapter 4: Reporting Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .43

Creating a Report with Report Creation Wizard ........................................43

Creating a standard report..................................................................44

The rest of the Report Creation wizards ...........................................49

Starting with a Blank Report.........................................................................49

Connecting Your Report to Its Data Source................................................50

Accessing database files directly .......................................................51

Linking to ODBC data sources............................................................51

Retrieving data from Crystal SQL Designer files ..............................52

Reporting on data in OLE DB data sources.......................................53

Creating customized data access with Crystal Dictionaries ..........53

Which interface should you use? .......................................................53

Crystal Reports 10 For Dummies

xiv

01_571370_ftoc.qxd 5/4/04 9:19 AM Page xiv

Part II: Moving Up to Professional Quality Reports ........55

Chapter 5: Pulling Specific Data from a Database . . . . . . . . . . . . . . . .57

Get Data Quickly with Select Expert............................................................57

Using Formulas to Retrieve Data..................................................................63

Using Parameter Fields to Retrieve Data at Runtime ................................65

Troubleshooting Tips ....................................................................................71

Chapter 6: Sorting, Grouping, and Totaling Result Sets . . . . . . . . . . . .73

Sorting Report Data .......................................................................................73

Sorting based on multiple fields.........................................................75

Sorting and performance.....................................................................78

Grouping Related Items.................................................................................79

Calculating Percentages................................................................................82

Drilling Down for Detail.................................................................................84

Keeping Track of Things with Running Totals............................................86

Troubleshooting Sorting, Grouping, and Totaling Problems....................90

Sorting problems and how to solve them .........................................90

Unusual grouping options...................................................................91

Getting the right totals ........................................................................92

Chapter 7: Mastering Report Sections . . . . . . . . . . . . . . . . . . . . . . . . . . .93

Changing the Size of a Section......................................................................93

Vertical spacing between lines ...........................................................93

The Section Formatting menu ............................................................96

Common tab of Section Expert...........................................................98

Color tab of Section Expert...............................................................100

Placing Groups Where You Want Them.....................................................103

Starting each group at the top of its own page ..............................103

Printing totals at the bottom of a page............................................104

Restarting page numbering at the beginning of each group.........105

Hiding Details with Summary and Drill-Down Reports ...........................105

Creating Mailing Labels...............................................................................106

Saving Money on Postage by Doing a Zip Sort.........................................109

Chapter 8: Formatting Your Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . .111

Absolute Formatting and Conditional Formatting...................................111

Absolute formatting overview..........................................................112

Conditional formatting ......................................................................116

Highlighting Expert Creates Emphasis......................................................118

Table of Contents

01_571370_ftoc.qxd 5/4/04 9:19 AM Page xv

Adding Pictures to a Report .......................................................................119

A Trick for Aligning Preprinted Forms ......................................................120

Adding Text from a File ...............................................................................121

Formatting Options......................................................................................121

Special Fields Contain Report Metadata ...................................................123

Raising a Red Flag with Report Alerts .......................................................123

Report Templates Save Time and Effort ...................................................127

What’s a template?.............................................................................127

How do you use a template in a report?..........................................127

Applying a template to an existing report.......................................128

Applying a template to a report you’re creating............................129

Part III: Advanced Report Types and Features .............131

Chapter 9: Displaying Your Favorite Hit Parade with Group Sort . . .133

Sorting Groups Based on Performance.....................................................133

Going with the Percentages........................................................................142

What if you want the top seventeen instead of the top five? .......144

A Choice of Group Sorts..............................................................................146

Troubleshooting Group Sort Problems .....................................................147

Chapter 10: Making Correlations with Cross-Tab Reports . . . . . . . .149

Creating a Cross-Tab Object to Summarize All Report Data ..................149

Summarizing the Contents of a Group with a Cross-Tab ........................153

Enhancing the Appearance and Readability of a Cross-Tab Object ......157

Changing the width and height of cross-tab cells..........................158

Formatting entire rows and columns...............................................158

Formatting individual fields..............................................................159

Suppressing selected cross-tab data ...............................................159

Printing cross-tabs that span multiple pages .................................160

Chapter 11: Adding Formulas to Reports . . . . . . . . . . . . . . . . . . . . . . . .161

Formula Overview and Syntax ...................................................................161

Lessening the Workload with Functions ...................................................162

Creating a Custom Function Using Formula Workshop ..........................162

Formula Editor....................................................................................165

Formula Expert ...................................................................................166

SQL Expression Editor.......................................................................168

Selection formulas..............................................................................169

Formatting formulas...........................................................................171

Changing and Deleting Formulas ...............................................................172

Data Types ....................................................................................................173

Simple data types ...............................................................................173

Range data types ................................................................................175

Array data types.................................................................................175

Crystal Reports 10 For Dummies

xvi

01_571370_ftoc.qxd 5/4/04 9:19 AM Page xvi

Variables in Formulas ..................................................................................176

Declaring a variable ...........................................................................176

Assigning a value to a variable .........................................................176

Control Structures........................................................................................177

If-Then-Else..........................................................................................177

Select Case ..........................................................................................178

For loop................................................................................................178

While Do loop .....................................................................................179

Do While loop .....................................................................................180

Chapter 12: Creating Reports within a Report . . . . . . . . . . . . . . . . . . .181

Combining Unrelated Reports....................................................................181

Underlay formatting for side-by-side location of subreport.........185

Drilling down in a subreport.............................................................186

Linking a Subreport to a Primary Report..................................................187

On-Demand Subreports Boost Efficiency..................................................191

Passing Data Between Reports...................................................................192

Troubleshooting Subreport Problems.......................................................193

Chapter 13: Combining Report Elements with OLE . . . . . . . . . . . . . . .195

Overview of OLE...........................................................................................195

Static OLE objects ..............................................................................196

Embedded objects and linked objects ............................................196

Embedding or Linking a File as an OLE Object ........................................197

Embedding or Linking an Object Taken from a File.................................199

Editing OLE Objects.....................................................................................199

Chapter 14: Creating and Updating OLAP Reports . . . . . . . . . . . . . . . .201

What’s OLAP, and Why Might I Need It?....................................................201

Who uses OLAP?.................................................................................201

Creating multidimensional views.....................................................202

OLAP Reporting with Crystal Reports ......................................................203

Creating a three-dimensional report................................................203

Updating an OLAP report..................................................................209

Chapter 15: Enhancing Reports with Charts . . . . . . . . . . . . . . . . . . . . .211

Choosing the Best Chart Type for Your Data ...........................................211

Side-by-side bar chart........................................................................211

Stacked bar chart ...............................................................................213

Line chart ............................................................................................213

Area chart............................................................................................213

Pie chart ..............................................................................................214

Doughnut chart...................................................................................215

3-D riser chart .....................................................................................216

3-D surface chart ................................................................................216

XY scatter chart..................................................................................216

xvii

Table of Contents

01_571370_ftoc.qxd 5/4/04 9:19 AM Page xvii

Radar chart .........................................................................................217

Bubble chart .......................................................................................218

Stock chart ..........................................................................................218

Numeric axis chart.............................................................................219

Gauge chart.........................................................................................221

Gantt chart ..........................................................................................221

Funnel chart ........................................................................................222

Different Chart Layouts for Different Data Types ....................................223

A Chart’s Placement Affects the Data It Can Represent..........................224

Using Chart Expert.......................................................................................225

Whirlwind tour of the Chart Expert dialog box..............................225

Creating a chart ..................................................................................229

Drilling down from a chart ................................................................231

Changing a chart.................................................................................232

Troubleshooting Chart Problems ..............................................................232

Selecting data to make a chart readable and meaningful .............232

The placement of chart elements matters......................................233

Chapter 16: Adding Geographic Detail with Maps . . . . . . . . . . . . . . .235

Crystal Reports Maps..................................................................................235

Map layouts.........................................................................................236

Map types............................................................................................236

Map placement ...................................................................................238

Creating a Map Step by Step.......................................................................238

Creating an advanced layout map....................................................238

Creating a Group layout map............................................................240

Creating a Cross-Tab layout map .....................................................241

Creating an OLAP layout map...........................................................242

Including maps in subreports...........................................................243

Changing maps ...................................................................................243

Troubleshooting Map Problems.................................................................243

Part IV: Crystal Reports in the Enterprise....................245

Chapter 17: Crystal Enterprise Components . . . . . . . . . . . . . . . . . . . . .247

Understanding Business Views ..................................................................247

The Three Muska-Tiers................................................................................248

The Business Tier.........................................................................................248

Data Connection .................................................................................248

Dynamic Data Connection.................................................................251

Data Foundation .................................................................................253

Additional objects ..............................................................................257

Crystal Enterprise Admin Launchpad.......................................................260

Crystal Management Console.....................................................................262

Crystal Reports 10 For Dummies

xviii

01_571370_ftoc.qxd 5/4/04 9:19 AM Page xviii

剩余385页未读，继续阅读

dddgon

粉丝: 3
资源: 12

快速掌握Crystal Reports 10入门指南

Crystal Reports 2008 水晶报表官方中文傻瓜教程（翻译）.pdf

Crystal.Reports.10.for.Dummies

Crystal.Reports.2008.For.Dummies

For.Dummies.CISSP.for.Dummies.2nd.Edition.Apr.2007

For.Dummies.Oracle.PL.SQL.For.Dummies.Jun.2006.

For.Dummies.Microsoft.SharePoint.2007.For.Dummies.Apr.2007

For.Dummies.Access.VBA.Programming.For.Dummies.Aug.2004

For.Dummies.Visual.Basic.2008.For.Dummies.Mar.2008

For.Dummies.Ajax.For.Dummies.Feb.2006.eBook-BBL

For.Dummies.Excel.Data.Analysis.For.Dummies.2nd.Edition.epub

最新资源