Klienditugi: 7440010 (E-R 10-18)

Abi | Registreeri | Logi sisse

E-raamat: Crystal Reports 10 For Dummies

3.60/5 (48 hinnangut Goodreads-ist)

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

Formaat: EPUB+DRM
Ilmumisaeg: 23-Feb-2011
Kirjastus: For Dummies
Keel: eng
ISBN-13: 9781118054253

Teised raamatud teemal:

Formaat - EPUB+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: EPUB+DRM
Ilmumisaeg: 23-Feb-2011
Kirjastus: For Dummies
Keel: eng
ISBN-13: 9781118054253

Teised raamatud teemal:

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.

Would you read information presented like this? No. Its just not natural. Sometimes presentation is almost as important as content. When you create a report, the goal is to provide information for readers in a format they can readily understand.

Crystal Reports 10 For Dummies, the latest version of the most popular report writer in the world, shows you how to create simple or sophisticated reports, turning data into interactive, actionable reports that convey whats happening in your business. You can progress cover-to-cover or use the index to find out how to:

Give your reports more pizzazz by using the correct fonts, color, drop shadows, graphic elements, and more Integrate elements from multiple, non-database sources Group sort, total result sets, cross-tab reports, and add formulas, charts, or maps Print reports Use customized Business Views gleaned from the same information to provide each reader with information he or she needs to know without spilling all the beans, sales figures, marketing information, or whatever Present multi-dimensional data in OLAP (Online Analytical Processing) cubes Get ideas from sample reports on the companion Web site

Written by Allen G. Taylor, nationally known lecturer, teacher, and author of over 20 books, including Database Development for Dummies, Crystal Reports 10 For Dummies makes it crystal clear how to:

Store your information securely in Crystal Repository Use Crystal Analysis 10 to display OLAP data so you and your reports readers can analyze the information in an online environment Use Crystal Enterprise to put Crystal Reports online for viewing by hundreds or thousands of people in your organization

Whether you want to dazzle your companys CEO and shareholders, motivate the sales force, or simply share database information cogently, with Crystal Reports 10 For Dummies you not only make your point, you an impression. When your reports look professional, you look professional.

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

(2)

Reporting Basics

(1)

Moving Up to Professional Quality Reports

(1)

Advanced Report Types and Features

(1)

Crystal Reports in the Enterprise

(1)

Publishing Your Reports

(1)

The Part of Tens

(1)

About the Web Site

(1)

Icons Used in This Book

(1)

Where to Go from Here

(2)

Part I: Reporting Basics

(48)

Transforming Raw Data into Usable Information

(8)

Major Features of Crystal Reports 10

(2)

Formatting a report

(1)

Enhancing a report with formulas and custom functions

(1)

Getting visual with charts and maps

(1)

Displaying a report

(1)

Distributing a report

(1)

Supplying Crystal Reports with data

(1)

The Four Editions of Crystal Reports 10

(2)

The Standard Edition

(1)

The Professional Edition

(1)

The Developer Edition

(1)

The Advanced Edition

(1)

Viewing a Report

(3)

Reading a printed report

(1)

Viewing a report with Crystal Reports

(2)

Viewing a report on your local area network or the Web

(1)

Create a Simple Report Right Now!

(16)

Starting Crystal Reports 10

(1)

Creating a Report with the Blank Report Option

(13)

Allocating more space to the layout

(1)

Giving the report a title

(2)

Choosing the fields that will appear in your report

(1)

Improving the readability of page headers

(1)

Previewing the report

(2)

Page footers carry useful information

(1)

Wrap things up with a report footer

(1)

Recording helpful information about your report

(1)

Troubleshooting a Report That Doesn't Look Quite Right

(1)

Printing a Report

(1)

Report Design Guidelines

(10)

Audience

(1)

Purpose

(1)

Content

(1)

Interfacing the Report to a Database

(3)

Connecting to Microsoft Access

(1)

Connecting to other data sources

(1)

What Should the Report Look Like?

(5)

Making a good first impression

(1)

Deciding how best to present the information

(1)

Should the report include graphs, charts, or pictures?

(1)

Style communicates meaning, too

(1)

Does the report convey the message?

(2)

Reporting Overview

(12)

Creating a Report with Report Creation Wizard

(6)

Creating a standard report

(5)

The rest of the Report Creation wizards

(1)

Starting with a Blank Report

(1)

Connecting Your Report to Its Data Source

(5)

Accessing database files directly

(1)

Linking to ODBC data sources

(1)

Retrieving data from Crystal SQL Designer files

(1)

Reporting on data in OLE DB data sources

(1)

Creating customized data access with Crystal Dictionaries

(1)

Which interface should you use?

(2)

Part II: Moving Up to Professional Quality Reports

(76)

Pulling Specific Data from a Database

(16)

Get Data Quickly with Select Expert

(6)

Using Formulas to Retrieve Data

(2)

Using Parameter Fields to Retrieve Data at Runtime

(6)

Troubleshooting Tips

(2)

Sorting, Grouping, and Totaling Result Sets

(20)

Sorting Report Data

(6)

Sorting based on multiple fields

(3)

Sorting and performance

(1)

Grouping Related Items

(3)

Calculating Percentages

(2)

Drilling Down for Detail

(2)

Keeping Track of Things with Running Totals

(4)

Troubleshooting Sorting, Grouping, and Totaling Problems

(3)

Sorting problems and how to solve them

(1)

Unusual grouping options

(1)

Getting the right totals

(1)

Mastering Report Sections

(18)

Changing the Size of a Section

(10)

Vertical spacing between lines

(3)

The Section Formatting menu

(2)

Common tab of Section Expert

(2)

Color tab of Section Expert

100

(3)

Placing Groups Where You Want Them

103

(2)

Starting each group at the top of its own page

103

(1)

Printing totals at the bottom of a page

104

(1)

Restarting page numbering at the beginning of each group

105

(1)

Hiding Details with Summary and Drill-Down Reports

105

(1)

Creating Mailing Labels

106

(3)

Saving Money on Postage by Doing a Zip Sort

109

(2)

Formatting Your Reports

111

(20)

Absolute Formatting and Conditional Formatting

111

(7)

Absolute formatting overview

112

(4)

Conditional formatting

116

(2)

Highlighting Expert Creates Emphasis

118

(1)

Adding Pictures to a Report

119

(1)

A Trick for Aligning Preprinted Forms

120

(1)

Adding Text from a File

121

(1)

Formatting Options

121

(2)

Special Fields Contain Report Metadata

123

(1)

Raising a Red Flag with Report Alerts

123

(4)

Report Templates Save Time and Effort

127

(4)

What's a template?

127

(1)

How do you use a template in a report?

127

(1)

Applying a template to an existing report

128

(1)

Applying a template to a report you're creating

129

(2)

Part III: Advanced Report Types and Features

131

(114)

Displaying Your Favorite Hit Parade with Group Sort

133

(16)

Sorting Groups Based on Performance

133

(9)

Going with the Percentages

142

(4)

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

144

(2)

A Choice of Group Sorts

146

(1)

Troubleshooting Group Sort Problems

147

(2)

Making Correlations with Cross-Tab Reports

149

(12)

Creating a Cross-Tab Object to Summarize All Report Data

149

(4)

Summarizing the Contents of a Group with a Cross-Tab

153

(4)

Enhancing the Appearance and Readability of a Cross-Tab Object

157

(4)

Changing the width and height of cross-tab cells

158

(1)

Formatting entire rows and columns

158

(1)

Formatting individual fields

159

(1)

Suppressing selected cross-tab data

159

(1)

Printing cross-tabs that span multiple pages

160

(1)

Adding Formulas to Reports

161

(20)

Formula Overview and Syntax

161

(1)

Lessening the Workload with Functions

162

(1)

Creating a Custom Function Using Formula Workshop

162

(10)

Formula Editor

165

(1)

Formula Expert

166

(2)

SQL Expression Editor

168

(1)

Selection formulas

169

(2)

Formatting formulas

171

(1)

Changing and Deleting Formulas

172

(1)

Data Types

173

(3)

Simple data types

173

(2)

Range data types

175

(1)

Array data types

175

(1)

Variables in Formulas

176

(1)

Declaring a variable

176

(1)

Assigning a value to a variable

176

(1)

Control Structures

177

(4)

If-Then-Else

177

(1)

Select Case

178

(1)

For loop

178

(1)

While Do loop

179

(1)

Do While loop

180

(1)

Creating Reports within a Report

181

(14)

Combining Unrelated Reports

181

(6)

Underlay formatting for side-by-side location of subreport

185

(1)

Drilling down in a subreport

186

(1)

Linking a Subreport to a Primary Report

187

(4)

On-Demand Subreports Boost Efficiency

191

(1)

Passing Data Between Reports

192

(1)

Troubleshooting Subreport Problems

193

(2)

Combining Report Elements with OLE

195

(6)

Overview of OLE

195

(2)

Static OLE objects

196

(1)

Embedded objects and linked objects

196

(1)

Embedding or Linking a File as an OLE Object

197

(2)

Embedding or Linking an Object Taken from a File

199

(1)

Editing OLE Objects

199

(2)

Creating and Updating OLAP Reports

201

(10)

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

201

(2)

Who uses OLAP?

201

(1)

Creating multidimensional views

202

(1)

OLAP Reporting with Crystal Reports

203

(8)

Creating a three-dimensional report

203

(6)

Updating an OLAP report

209

(2)

Enhancing Reports with Charts

211

(24)

Choosing the Best Chart Type for Your Data

211

(12)

Side-by-side bar chart

211

(2)

Stacked bar chart

213

(1)

Line chart

213

(1)

Area chart

213

(1)

Pie chart

214

(1)

Doughnut chart

215

(1)

3-D riser chart

216

(1)

3-D surface chart

216

(1)

XY scatter chart

216

(1)

Radar chart

217

(1)

Bubble chart

218

(1)

Stock chart

218

(1)

Numeric axis chart

219

(2)

Gauge chart

221

(1)

Gantt chart

221

(1)

Funnel chart

222

(1)

Different Chart Layouts for Different Data Types

223

(1)

A Chart's Placement Affects the Data It Can Represent

224

(1)

Using Chart Expert

225

(7)

Whirlwind tour of the Chart Expert dialog box

225

(4)

Creating a chart

229

(2)

Drilling down from a chart

231

(1)

Changing a chart

232

(1)

Troubleshooting Chart Problems

232

(3)

Selecting data to make a chart readable and meaningful

232

(1)

The placement of chart elements matters

233

(2)

Adding Geographic Detail with Maps

235

(10)

Crystal Reports Maps

235

(3)

Map layouts

236

(1)

Map types

236

(2)

Map placement

238

(1)

Creating a Map Step by Step

238

(5)

Creating an advanced layout map

238

(2)

Creating a Group layout map

240

(1)

Creating a Cross-Tab layout map

241

(1)

Creating an OLAP layout map

242

(1)

Including maps in subreports

243

(1)

Changing maps

243

(1)

Troubleshooting Map Problems

243

(2)

Part IV: Crystal Reports in the Enterprise

245

(60)

Crystal Enterprise Components

247

(22)

Understanding Business Views

247

(1)

The Three Muska-Tiers

248

(1)

The Business Tier

248

(12)

Data Connection

248

(3)

Dynamic Data Connection

251

(2)

Data Foundation

253

(4)

Additional objects

257

(3)

Crystal Enterprise Admin Launchpad

260

(2)

Crystal Management Console

262

(1)

Crystal Enterprise User Launchpad

263

(1)

Crystal Enterprise Web Desktop

263

(1)

Crystal Configuration Manager

264

(1)

Crystal Import Wizard

265

(1)

Crystal Publishing Wizard

265

(4)

Crystal Repository

269

(10)

Storing Your Valuables in Crystal Repository

270

(3)

Adding folders to your Repository

270

(1)

Adding text and bitmapped objects to the Repository

270

(3)

Adding custom functions to the Repository

273

(1)

Adding SQL commands to the Repository

273

(1)

Using Repository Objects in a Report

273

(1)

Modifying a Repository Object

274

(1)

Updating Reports Automatically Using Connected Repository Objects

275

(2)

Deleting Objects from the Repository

277

(2)

Maintaining Security

279

(6)

Restricting Access

279

(4)

Logon tokens

280

(1)

Sessions and session tracking

280

(1)

Primary authentication

281

(1)

Secondary authentication and authorization

281

(1)

Protecting the environment

282

(1)

Web activity auditing

282

(1)

Combating malicious logon attempts

282

(1)

Easing the Security Burden

283

(1)

Single Sign-On

283

(1)

Active trust relationship

283

(1)

Controlling Access to Specific Reports

283

(2)

Creating groups to control access

283

(1)

Granting rights to control access

284

(1)

Navigating with Report Parts

285

(10)

Understanding Report Parts Navigation

285

(2)

Using Report Parts to Navigate

287

(8)

Using the Report Parts Drill-down method

287

(6)

Using the Another Report Object method

293

(2)

Crystal Analysis 10

295

(10)

Digging Deeper into OLAP

295

(1)

Creating a Crystal Analysis Report

296

(9)

Using a blank application

296

(2)

Using the Application Experts

298

(7)

Part V: Publishing Your Reports

305

(20)

Distributing and Viewing Reports

307

(4)

Printing Your Report

307

(1)

Faxing a Report

308

(1)

Exporting a Report

309

(1)

Troubleshooting Output Problems

310

(1)

Displaying Reports Online

311

(6)

Exporting to a Static HTML Page

311

(3)

Adding a Hyperlink to a Report

314

(3)

SQL Commands

317

(8)

Creating an SQL Statement

318

(3)

Adding an SQL Statement to a Repository

321

(1)

Modifying an SQL Statement

322

(3)

Part VI: The Part of Tens

325

(10)

Ten Things to Do Before You Create a Report

327

(4)

Identify the Users

327

(1)

Interview the Users

328

(1)

Arbitrate Conflicting Demands

328

(1)

Nail Down the Project's Scope

328

(1)

Nail Down the Project's Schedule

328

(1)

Verify That the Necessary Data Is in the Database

329

(1)

Determine How the Report Will Be Viewed

329

(1)

Determine the Best Report Type for the Users' Needs

329

(1)

Get Agreement on the Report's Appearance

330

(1)

Decide Whether to Include Charts or Maps

330

(1)

Ten Ways to Give Your Reports More Pizzaz

331

(4)

Use the Correct Fonts

331

(1)

Use Color Tastefully

332

(1)

Enclose Text in Boxes

332

(1)

Emphasize Objects with Drop Shadows

332

(1)

Produce a Consistent Appearance with Templates

333

(1)

Add an Image

333

(1)

Add a Chart

333

(1)

Add a Map

333

(1)

Combine Two Objects with an Underlay

334

(1)

Separate the Summary from the Details with Drill-Down

334

(1)

Index

335

Allen G. Taylor teaches database development at a leading online education company and electrical engineering at Portland State University. He has authored twenty books, including SQL® For Dummies.

Lisainfo e-raamatute kohta