Klienditugi: 7440010 (E-R 10-18)

Abi | Registreeri | Logi sisse

E-raamat: Crystal Reports 2008 For Dummies

3.47/5 (30 hinnangut Goodreads-ist)

Allen G. Taylor (Database Consultant, Oregon City, Oregon)

Formaat: PDF+DRM
Ilmumisaeg: 02-Jun-2008
Kirjastus: For Dummies
Keel: eng
ISBN-13: 9780470388679

Teised raamatud teemal:

Enterprise software

Formaat - PDF+DRM
Hind: 19,49 €*
* hind on lõplik, st. muud allahindlused enam ei rakendu
Lisa ostukorvi
Lisa soovinimekirja
See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.

Formaat: PDF+DRM
Ilmumisaeg: 02-Jun-2008
Kirjastus: For Dummies
Keel: eng
ISBN-13: 9780470388679

Teised raamatud teemal:

Enterprise software

DRM piirangud

Kopeerimine (copy/paste):

ei ole lubatud
Printimine:

ei ole lubatud
Kasutamine:

Digitaalõiguste kaitse (DRM)
Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

Vajalik tarkvara
Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

Seda e-raamatut ei saa lugeda Amazon Kindle's.

A report is only useful if those who receive it understand what it means. Knowing how to use Crystal Reports gives you the edge in producing reports from your database that really are crystal clear. Crystal Reports 2008 For Dummies is a quick and easy guide to get you going with the latest version of this bestselling report-writing software. In fact, its so popular that previous editions have made it a bestseller too. Crystal Reports 2008 For Dummies gives you just what you should know to produce the reports youll need most often, including how to:

Pull specific information from your database, sort and group it, and find the details you need Use dynamic or cascading prompts Troubleshoot and print reports and save time with templates View reports on your LAN Write formulas to retrieve specific information Create and update OLAP reports Format reports, control page breaks, and even add graphics or Flash files Enhance your reports with charts and maps Use Crystal Reports in the enterprise

Theres also a companion Web site with sample reports from the book and links to sites with more related information. With Crystal Reports 2008 For Dummies by your side, youll soon be able to create reports from simple to spectacular, whenever the need arises.

Introduction

(1)

About This Book

(1)

Conventions Used in This Book

(1)

What You're Not to Read

(1)

Foolish Assumptions

(1)

How This Book Is Organized

(1)

Part I: Reporting Basics

(1)

Part II: Moving Up to Professional-Quality Reports

(1)

Part III: Advanced Report Types and Features

(1)

Part IV: Crystal Reports Types and Features

(1)

Part V: Publishing Your Reports

(1)

Part VI: The Part of Tens

(1)

Icons Used in This Book

(1)

Where to Go from Here

(2)

Part I: Reporting Basics

(48)

Transforming Raw Data into Meaningful Information

(8)

Major Features of Crystal Reports 2008

(4)

Formatting a report

(1)

Generating barcodes

(1)

Enhancing a report with formulas and custom functions

(1)

Getting visual with charts and maps

(1)

Xcelsius integration

(1)

Adobe Flash integration

(1)

Displaying a report

(1)

Distributing a report

(1)

Supplying Crystal Reports with data

(1)

The Lone Edition of Crystal Reports 2008

(1)

Viewing a Report

(4)

Reading a printed report

(1)

Viewing a report with Crystal Reports

(2)

Viewing a report on a LAN or on the Web

(1)

Create a Simple Report Right Now!

(20)

First Things First: Finding the Sample Database

(1)

Starting Crystal Reports 2008

(2)

Creating a Report with the Blank Report Option

(16)

Allocating more space to the layout

(1)

Introducing your report

(2)

Choosing the fields that appear in your report

(2)

Improving the readability of page headers

(1)

Previewing the report

(2)

Page footers carry useful information

(2)

Wrapping things up with a report footer

(1)

Recording helpful information about your report

(2)

Printing a Report

(1)

Where to Go from Here

(1)

Report Design Guidelines

(6)

Defining an Effective Report Design

(1)

Defining Your Audience

(1)

Defining the Report's Purpose

(1)

Choosing Content for Your Report

(1)

Choosing the Report Appearance

(4)

Making a good first impression

(1)

Deciding how best to present the information

(1)

Choosing graphic elements for your report

(1)

Style communicates meaning, too

(1)

Making sure your report conveys your message

(1)

Starting Your Report

(12)

Using the Report Creation Wizard

(6)

Creating a report with the Standard Report Creation Wizard

(5)

Using other report-creation wizards

(1)

Starting with a Blank Report

(1)

Connecting Your Report to Its Data Source

(5)

Accessing database files directly

(1)

Connecting to ODBC data sources

(1)

Retrieving data with SQL

(1)

Reporting on data in OLE DB data sources

(1)

Which interface should you use?

(2)

Part II: Moving Up to Professional-Quality Reports

(92)

Pulling Specific Data from a Database

(18)

Get Data Quickly with Select Expert

(7)

Using Formulas to Retrieve Data

(2)

Using Parameter Fields to Retrieve Data at Runtime

(7)

Step 1: Creating a report that shows everything

(3)

Step 2: Giving the user the power to decide what to show

(2)

Speed retrievals with indexes

(1)

Changing parameter values to change the report

(1)

Troubleshooting Tips When Retrieving Data

(2)

Sorting, Grouping, and Totaling Report Data

(26)

Sorting Report Data

(7)

Sorting based on multiple fields

(4)

Sorting and performance

(1)

Adding Sort Controls to a Report

(3)

Grouping Related Items

(4)

Calculating Percentages

(1)

Drilling Down for Detail

(4)

Keeping Track of Things with Running Totals

(3)

Troubleshooting Sorting, Grouping, and Totaling Problems

(4)

Sorting problems and how to solve them

(1)

Unusual grouping options

(1)

Getting the right totals

(2)

Mastering Report Sections

101

(22)

Changing the Size of a Section

101

(2)

Formatting with the Section Formatting Menu

103

(1)

Using Section Expert for Easy Section Formatting

104

(6)

Common tab, Section Expert

105

(1)

Paging tab, Section Expert

106

(1)

Color tab, Section Expert

107

(3)

Placing Groups Where You Want Them

110

(3)

Starting each group at the top of its own page

110

(2)

Printing totals at the bottom of a page

112

(1)

Restarting page numbering at the beginning of each group

113

(1)

Hiding Details with Summary and Drill-Down Reports

113

(1)

Generating Barcodes

114

(3)

Creating Mailing Labels

117

(3)

Saving Money on Postage with a ZIP Sort

120

(3)

Enhancing Your Report's Appearance

123

(24)

Absolute Formatting

124

(6)

Setting the fonts and their formatting for emphasis

124

(4)

Adding graphical elements for emphasis

128

(2)

Conditional Formatting Using the Format Editor

130

(2)

Creating Emphasis with Highlighting Expert

132

(2)

Adding Pictures to Your Report

134

(2)

Aligning Preprinted Forms

136

(1)

Adding Text from a File

136

(1)

Formatting Options

137

(2)

Special Fields Contain Report Metadata

139

(1)

Raising a Red Flag with Report Alerts

139

(3)

Using Report Templates to Save Time and Effort

142

(5)

Applying a template to a report

143

(1)

Applying a template to an existing report

143

(2)

Applying a template to a report you're creating

145

(2)

Part III: Advanced Report Types and Features

147

(156)

Displaying Your Top Ten (Or Top N) with Group Sort

149

(18)

Sorting Groups Based on Performance

149

(11)

Starting a Top N Report

150

(4)

Displaying a group total

154

(1)

Hiding the details

155

(2)

Removing page breaks

157

(3)

Going with the Percentages

160

(4)

What if you want the top 17 instead of the top 5?

161

(3)

A Choice of Group Sorts

164

(1)

Troubleshooting Group Sort Problems

165

(2)

Adding Formulas to Reports

167

(24)

Formula Overview and Syntax

167

(1)

Lessening the Workload with Functions

168

(1)

Creating a Custom Function in Formula Workshop

169

(13)

Formula Editor

173

(2)

Formula Expert

175

(2)

SQL Expression Editor

177

(1)

Selection formulas

177

(4)

Formatting formulas

181

(1)

Changing and Deleting Formulas

182

(1)

Data Types

182

(3)

Simple data types

182

(2)

Range data types

184

(1)

Array data types

184

(1)

Variables in Formulas

185

(1)

Declaring a variable

185

(1)

Assigning a value to a variable

186

(1)

Control Structures

186

(5)

If-Then-Else

186

(1)

Select Case

187

(1)

For loop

187

(1)

While Do loop

188

(1)

Do While loop

189

(2)

Creating Reports within a Report

191

(16)

Combining Unrelated Reports

191

(6)

Underlay formatting for side-by-side location of subreport

195

(1)

Drilling down in a subreport

196

(1)

Linking a Subreport to a Primary Report

197

(6)

On-Demand Subreports Boost Efficiency

203

(1)

Passing Data between Reports

204

(1)

Troubleshooting Subreport Problems

205

(2)

Combining Report Elements with OLE

207

(12)

Overview of OLE

207

(1)

Static OLE Objects

208

(4)

Inserting a static OLE object into a report

208

(2)

Making a static OLE object editable

210

(2)

Embedded OLE Objects

212

(2)

Embedding an OLE object into a report

212

(2)

Linked OLE Objects

214

(3)

Embedding or Linking an Object Taken from a File

217

(1)

Integrating Shockwave Flash Objects into Your Reports

217

(2)

Creating and Updating OLAP Reports

219

(26)

What's OLAP, and Why Might You Need It?

219

(2)

Who uses OLAP?

220

(1)

Creating multidimensional views

220

(1)

Connecting to an OLAP data source

221

(1)

OLAP Reporting with Crystal Reports

221

(11)

Operating on OLAP grid objects

222

(1)

Creating a three-dimensional report

222

(10)

Updating an OLAP Report

232

(1)

Formatting Data in an OLAP Report

233

(5)

Changing a dimension's background color

234

(1)

Creating an alias for a dimension

235

(1)

Formatting grid lines

236

(1)

Labeling dimensions

237

(1)

Changing Data Appearance in an OLAP Report

238

(7)

Showing and hiding dimensions

239

(1)

Adding totals to an OLAP grid

240

(1)

Pivoting an OLAP grid

240

(1)

Reordering fields

241

(1)

Sorting data

242

(1)

Filtering data

243

(1)

Making calculations

243

(2)

Using Cross-Tab Reports to Mine Your Data

245

(14)

Creating a Cross-Tab Object to Summarize All Report Data

245

(4)

Summarizing the Contents of a Group with a Cross-Tab

249

(6)

Making Calculations within a Cross-Tab Row or Column

255

(1)

Enhancing the Appearance and Readability of a Cross-Tab Object

256

(3)

Changing the width and height of cross-tab cells

256

(1)

Formatting entire rows and columns

257

(1)

Formatting individual fields

257

(1)

Suppressing selected cross-tab data

258

(1)

Printing cross-tabs that span multiple pages

258

(1)

Enhancing Reports with Charts

259

(24)

Using Chart Expert

259

(4)

Type tab

260

(1)

Data tab

260

(1)

Axes tab

261

(1)

Options tab

262

(1)

Color Highlight tab

263

(1)

Text tab

263

(1)

Creating a Chart

263

(4)

Drilling down from a chart

266

(1)

Changing a chart

267

(1)

Choosing the Best Chart Type for Your Data

267

(11)

Side-by-side bar chart

267

(1)

Percent bar chart

268

(1)

Line chart

268

(1)

Area chart

269

(1)

Pie chart

270

(1)

Doughnut chart

270

(1)

3-D riser chart

271

(1)

3-D surface chart

272

(1)

XY scatter chart

272

(1)

Radar chart

273

(1)

Bubble chart

273

(1)

Stock chart

274

(1)

Numeric axis chart

275

(1)

Gauge chart

276

(1)

Gantt chart

276

(1)

Funnel chart

277

(1)

Histogram

278

(1)

Different Chart Layouts for Different Data Types

278

(2)

Seeing How Chart Placement Affects the Data It Represents

280

(1)

Troubleshooting Chart Problems

281

(2)

Selecting data to make a chart readable and meaningful

281

(1)

The placement of chart elements matters

282

(1)

Adding Geographic Detail with Maps

283

(10)

Choosing the Right Crystal Reports Map

283

(3)

Map layouts

284

(1)

Map types

284

(2)

Map placement

286

(1)

Creating a Map Step by Step

286

(5)

Creating an advanced layout map

286

(2)

Creating a Group layout map

288

(1)

Creating a Cross-Tab layout map

289

(1)

Creating an OLAP layout map

290

(1)

Including maps in subreports

291

(1)

Changing maps

291

(1)

Troubleshooting Map Problems

291

(2)

Interactivity Features

293

(10)

Crystal Xcelsius Overview

293

(1)

Adding Xcelsius Capability to a Report

294

(6)

Creating an SWF file with Crystal Xcelsius

295

(3)

Embedding your Crystal Xcelsius model in a Crystal report

298

(2)

Enhancing a Report with the Tasteful Use of Flash

300

(3)

Viewing Flash visualizations

300

(1)

Dynamic interaction with a report using a Parameter panel

300

(3)

Part IV: Crystal Reports in the Enterprise

303

(24)

Crystal Reports Server

305

(6)

Connecting to Data Sources

306

(1)

Connecting directly or indirectly

306

(1)

Using Business Views to simplify connectivity

306

(1)

Formatting Reports with Crystal Reports Developer

307

(1)

Providing Platform Services

307

(2)

Publishing and distributing reports

307

(1)

Providing security

308

(1)

Managing the system

308

(1)

Useful Management Tools

309

(1)

Application Services

309

(1)

Web Services

309

(1)

Viewing and Interacting with Reports

310

(1)

BusinessObjects Enterprise Repository

311

(8)

Adding Folders to Your Repository

312

(1)

Storing Your Valuables in BusinessObjects Enterprise Repository

312

(2)

Adding text and bitmapped objects to the Repository

313

(1)

Adding custom functions to the Repository

313

(1)

Adding SQL commands to the Repository

314

(1)

Using Repository Objects in a Report

314

(1)

Adding text objects and images

314

(1)

Adding custom functions

315

(1)

Adding SQL commands

315

(1)

Modifying a Repository Object

315

(2)

Deciding Whether to Update Reports Automatically

317

(1)

Deleting Objects from the Repository

318

(1)

Navigating with Report Parts

319

(8)

Understanding Report Parts Navigation

319

(1)

Using Report Parts to Navigate a Report

320

(7)

Using the Report Parts Drill-down method

321

(4)

Using the Another Report Object method

325

(2)

Part V: Publishing your Reports

327

(42)

Sending Your Reports Out into the World

329

(14)

Printing Your Report

329

(1)

Faxing a Report

330

(1)

Exporting a Report

331

(11)

Export format types

331

(3)

Export destinations

334

(8)

Troubleshooting Output Problems

342

(1)

Displaying Reports Online

343

(20)

Exporting to a Static HTML Page

344

(2)

Adding a Hyperlink to a Report

346

(3)

Distributing Reports via crystalreports.com

349

(1)

Integrating with salesforce.com

350

(1)

Publishing to crystalreports.com with Crystal Reports Desktop Publisher

351

(3)

Interactive Report Viewing with Crystal Reports Viewer

354

(9)

Opening a report in Crystal Reports Viewer

355

(1)

Navigating a report

355

(4)

Printing a report

359

(1)

E-mailing reports to your friends and co-workers

360

(1)

Sharing reports in a variety of formats

360

(1)

Searching a haystack for that elusive needle

361

(1)

Accessing reports on crystalreports.com

361

(2)

SQL Expression Fields

363

(6)

Creating an SQL Statement

363

(3)

Modifying an SQL Statement

366

(3)

Part VI: The Part of Tens

369

(10)

Ten Things to Do Before You Create a Report

371

(4)

Ten Ways to Give Your Reports More Pizzazz

375

(4)

Index

379

Allen G. Taylor teaches database development as well as electrical engineering, and also operates a Web development company. He is a national database management speaker and consultant.

Lisainfo e-raamatute kohta