SAP 7090310 podręczniki

Sap 7090310 Arkusz Danych (706 strony)

Marka: Sap | Kategoria: Oprogramowanie bazy danych | Rozmiar: 5.41 MB |

Angielski

Spis treści

2011-05-16

1

2011-05-164

4

2011-05-165

5

2011-05-166

6

2011-05-167

7

2011-05-168

8

2011-05-169

9

2011-05-1610

10

Contents

10

2011-05-1611

11

2011-05-1612

12

2011-05-1613

13

2011-05-1614

14

2011-05-1615

15

2011-05-1616

16

2011-05-1617

17

2011-05-1618

18

2011-05-1619

19

2011-05-1620

20

1.1 About Crystal Reports

21

1.2.2 Sample Reports

22

Quick Start

23

2.2 Report Creation Wizards

24

2.2.1 Standard

24

2.2.2 Cross-Tab

24

2.2.3 Mailing Label

25

2.2.4 OLAP

25

2.3 Quick start for new users

25

2.3.1 Before you begin

26

2.3.2 Creating the report

26

2011-05-1627

27

2.3.2.2 Report sections

28

2.3.2.3 Inserting a field

28

2.3.2.3.1 To insert a field

29

2.3.2.4 Understanding fields

30

2.3.2.6 Selecting fields

31

2.3.2.7 Resizing fields

31

2.3.2.8 Reviewing your work

31

2011-05-1632

32

2011-05-1633

33

2011-05-1634

34

2.3.2.12 Adding a title

35

2.3.2.13 Formatting objects

35

2011-05-1636

36

2.3.2.15 Saving the report

37

2.3.3 Record Selection

37

2011-05-1638

38

2.3.3.2 Deleting a field

39

2.3.3.2.1 To delete a field

40

2.3.4 Grouping and sorting

41

2.3.4.1 Grouping the report

41

2011-05-1642

42

2.3.4.3 Sorting records

43

2011-05-1644

44

2.3.5 Completing the report

45

2011-05-1646

46

2011-05-1647

47

2011-05-1648

48

2011-05-1649

49

2011-05-1650

50

Report Design Concepts

51

2011-05-1652

52

3.2.3 Finding the data

53

3.2.4 Manipulating the data

54

2011-05-1655

55

2011-05-1656

56

2011-05-1657

57

2011-05-1658

58

Introduction to Reporting

59

4.2.1 The Database Expert

60

4.2.1.1 Data tab

60

2011-05-1661

61

4.2.1.2 Links tab

62

4.2.2 The Field Explorer

62

4.2.2.1 Tree View

62

2011-05-1663

63

4.2.2.3 Group Name Fields

64

4.3.1 Design tab

64

4.3.1.1 Design tab areas

65

2011-05-1666

66

2011-05-1667

67

4.3.2 Preview tab

68

4.3.2.1 Standard view

68

4.3.2.2 Preview Panel

69

4.3.2.2.2 The Parameter Panel

70

4.3.2.2.3 Find tab

71

4.3.3 HTML Preview tab

72

4.4 Creating a new report

73

4.4.2 Adding tables

74

4.4.2.1 To add a table

74

4.4.3 Linking multiple tables

75

4.4.4.1 Database fields

76

4.4.4.2 Formula fields

77

4.4.4.3 SQL Expression fields

77

4.4.4.4 Parameter fields

78

4.4.4.5 Running total fields

78

4.4.4.6 Special fields

79

4.4.4.7 Text objects

79

4.4.4.8 Picture fields

80

4.4.4.9 Hyperlink fields

81

2011-05-1682

82

4.4.6 Formatting data

83

4.4.7 Record selection

84

4.4.9.1 Drill-down cursor

85

4.4.10 Using the zoom feature

85

2011-05-1686

86

2011-05-1687

87

4.5.1 The Report Explorer

88

4.5.1.1 Toolbar

89

4.5.2 The Workbench

90

4.5.2.1 Toolbar

90

4.5.2.2 Shortcut Menus

91

4.5.3 The Dependency Checker

91

4.5.3.1 Shortcut Menu

92

2011-05-1693

93

4.6 Beyond basic reports

94

5.1.1 Work flow

95

2011-05-1696

96

2011-05-1697

97

2011-05-1698

98

2011-05-1699

99

2011-05-16100

100

5.5.4 Adding a command

101

2011-05-16102

102

2011-05-16103

103

2011-05-16104

104

2011-05-16105

105

2011-05-16106

106

6.1 Overview

107

2011-05-16108

108

2011-05-16109

109

2011-05-16110

110

6.3.2.1 Live data

111

6.3.2.2 Saved data

111

2011-05-16112

112

2011-05-16113

113

2011-05-16114

114

2011-05-16115

115

6.4.2 Using table indexes

116

2011-05-16117

117

2011-05-16118

118

2011-05-16119

119

6.5.2.1 General

120

6.5.2.2 PC Databases

120

6.5.2.3 SQL Databases

121

2011-05-16122

122

2011-05-16123

123

2011-05-16124

124

2011-05-16125

125

2011-05-16126

126

2011-05-16127

127

2011-05-16128

128

Record Selection

129

7.1.3 Using the Select Expert

130

2011-05-16131

131

7.1.4 Using formulas

132

2011-05-16133

133

7.2 Using formula templates

134

2011-05-16135

135

2011-05-16136

136

2011-05-16137

137

2011-05-16138

138

2011-05-16139

139

2011-05-16140

140

8.1 Sorting data

141

8.1.1.1 Sorting data

141

8.1.1.2 Sort field

142

8.1.1.3 Sort Direction

143

8.1.2.1 To sort your data

144

8.1.3 Sort controls

145

2011-05-16146

146

8.2 Grouping data

147

8.2.1 Grouping data

147

8.2.1.1 To group data

147

2011-05-16148

148

8.2.2 Creating custom groups

149

2011-05-16150

150

2011-05-16151

151

8.2.5 Group selection

152

2011-05-16153

153

2011-05-16154

154

2011-05-16155

155

2011-05-16156

156

2011-05-16157

157

2011-05-16158

158

2011-05-16159

159

2011-05-16160

160

2011-05-16161

161

2011-05-16162

162

2011-05-16163

163

2011-05-16164

164

8.2.9 Editing groups

165

8.3 Summarizing grouped data

166

2011-05-16167

167

2011-05-16168

168

2011-05-16169

169

2011-05-16170

170

8.4 Subtotaling

171

8.4.1 Subtotaling data

171

8.4.1.1 To subtotal data

171

2011-05-16172

172

8.5 Percentages

173

2011-05-16174

174

8.6 Group headers

175

8.6.1 Creating group headers

175

8.6.1.1 Standard headers

176

8.6.1.2 Live headers

176

2011-05-16177

177

2011-05-16178

178

2011-05-16179

179

2011-05-16180

180

Running Totals

181

9.2 Creating running totals

182

2011-05-16183

183

2011-05-16184

184

2011-05-16185

185

2011-05-16186

186

2011-05-16187

187

2011-05-16188

188

2011-05-16189

189

2011-05-16190

190

Multiple Section Reports

191

10.2.1 Inserting a section

192

10.2.2 Deleting a section

192

10.2.3 Moving a section

193

10.3.1 Splitting a section

194

10.3.2 Resizing a section

195

2011-05-16196

196

2011-05-16197

197

10.5 Form letters

198

10.5.1.1 Move/Resize mode

199

10.5.1.2 Edit mode

199

2011-05-16200

200

2011-05-16201

201

10.5.2.2 Inserting a date

202

2011-05-16203

203

2011-05-16204

204

2011-05-16205

205

2011-05-16206

206

Formatting

207

11.2.1 Applying a template

208

2011-05-16209

209

2011-05-16210

210

2011-05-16211

211

2011-05-16212

212

2011-05-16213

213

2011-05-16214

214

2011-05-16215

215

11.3.3 Pre-printed forms

216

11.3.4 Multiple columns

216

11.3.5 Hiding report sections

217

11.3.5.1 Hide (Drill-Down OK)

217

11.3.6 Hiding report objects

218

2011-05-16219

219

2011-05-16220

220

2011-05-16221

221

2011-05-16222

222

2011-05-16223

223

2011-05-16224

224

11.3.10.1 Using the grid

225

11.3.10.2 Selecting the grid

225

11.3.10.4 Viewing guidelines

226

2011-05-16227

227

2011-05-16228

228

2011-05-16229

229

11.3.10.9 Indenting lines

230

2011-05-16231

231

2011-05-16232

232

11.3.13 Vertical placement

233

2011-05-16234

234

2011-05-16235

235

11.3.17 Setting page margins

236

11.3.18 TrueType fonts

236

11.3.19 Printer drivers

237

11.4 Formatting properties

238

2011-05-16239

239

2011-05-16240

240

2011-05-16241

241

2011-05-16242

242

2011-05-16243

243

2011-05-16244

244

2011-05-16245

245

2011-05-16246

246

2011-05-16247

247

2011-05-16248

248

2011-05-16249

249

2011-05-16250

250

2011-05-16251

251

2011-05-16252

252

2011-05-16253

253

2011-05-16254

254

2011-05-16255

255

2011-05-16256

256

2011-05-16257

257

2011-05-16258

258

2011-05-16259

259

2011-05-16260

260

2011-05-16261

261

2011-05-16262

262

11.6.7 Undo/Redo activities

263

11.7 Using the Format Painter

263

2011-05-16264

264

11.8 Working with barcodes

265

11.8.1 Adding a barcode

265

11.8.1.1 To add a barcode

266

11.8.3 Removing a barcode

267

2011-05-16268

268

Charting

269

12.1.2 Chart layouts

270

12.1.3 Chart types

271

2011-05-16272

272

12.1.4 Where to place a chart

273

12.1.5 Drill-down with charts

273

12.2 Creating charts

274

2011-05-16275

275

2011-05-16276

276

2011-05-16277

277

12.3 Working with charts

278

2011-05-16279

279

2011-05-16280

280

12.3.5 Auto-arranging charts

281

12.3.6 Formatting charts

282

2011-05-16283

283

2011-05-16284

284

13.1 Mapping concepts

285

13.1.1 Mapping overview

285

13.1.2 Map layouts

285

13.1.3 Map types

286

2011-05-16287

287

13.1.4 Where to place a map

288

13.1.5 Drill-down with maps

289

13.2 Creating maps

289

13.2.1.1 To map on a group

290

2011-05-16291

291

2011-05-16292

292

13.3 Working with maps

293

13.3.2 Changing the map title

294

13.3.3 Changing the map type

294

13.3.4 Changing map layers

294

13.3.4.1 To change map layers

295

2011-05-16296

296

2011-05-16297

297

13.3.8 Panning a map

298

13.3.9 Centering a map

298

2011-05-16299

299

13.3.11 Formatting Maps

300

13.3.12 To underlay a map

300

14.1 OLE overview

301

14.1.1 OLE terminology

301

14.1.2 Types of OLE objects

302

2011-05-16303

303

14.4.1 In-place editing

304

2011-05-16305

305

2011-05-16306

306

2011-05-16307

307

14.6.1 Embedded objects

308

14.6.2 Linked objects

309

2011-05-16310

310

2011-05-16311

311

2011-05-16312

312

2011-05-16313

313

2011-05-16314

314

Cross-Tab Objects

315

15.2 Cross-Tab example

316

2011-05-16317

317

2011-05-16318

318

2011-05-16319

319

2011-05-16320

320

2011-05-16321

321

2011-05-16322

322

2011-05-16323

323

15.3.4 Modifying the links

324

15.3.5 Adding a chart

324

15.3.6 Selecting records

325

2011-05-16326

326

2011-05-16327

327

2011-05-16328

328

15.4 Working with Cross-Tabs

329

2011-05-16330

330

2011-05-16331

331

15.4.4.2 To total across rows

332

15.4.5.1 To repeat row labels

332

15.5 Formatting Cross-Tabs

333

2011-05-16334

334

2011-05-16335

335

15.6.1 Calculated Members

336

2011-05-16337

337

15.6.1.4 Calculation Formulas

338

15.6.1.5 Header Formulas

338

15.6.1.6 Value Formulas

339

15.6.1.7 Insertion Formulas

339

15.6.2 Embedded Summaries

340

2011-05-16341

341

2011-05-16342

342

Building Queries

343

2011-05-16344

344

2011-05-16345

345

2011-05-16346

346

Crystal Reports Online Help

347

16.5.1 Creating query filters

348

16.5.2 Building prompts

349

16.5.2.1 To create a prompt

350

2011-05-16351

351

2011-05-16352

352

2011-05-16353

353

2011-05-16354

354

16.6.1 What is a subquery?

355

16.6.2 Building a subquery

355

16.6.2.1 To build a subquery

355

16.6.2.2 Subquery parameters

356

2011-05-16357

357

2011-05-16358

358

16.6.4.2 Ranking parameters

359

2011-05-16360

360

17.1.1 OLAP grid objects

361

17.2 Creating an OLAP report

362

2011-05-16363

363

2011-05-16364

364

17.2.4.1 To specify a slice

365

17.2.4.2 To add a page

366

17.2.4.3 To add a parameter

366

17.2.6 Inserting a chart

367

17.3 Updating an OLAP report

368

2011-05-16369

369

2011-05-16370

370

17.4.3 Formatting grid lines

371

17.4.4 Labeling dimensions

372

2011-05-16373

373

2011-05-16374

374

2011-05-16375

375

17.6.2.1 To add a filter

376

2011-05-16377

377

2011-05-16378

378

18.1 Distributing reports

379

18.1.1 Printing a report

379

18.1.2 Faxing a report

379

18.1.2.1 To fax a report

380

18.1.3 Exporting a report

380

18.1.3.1 Export format types

380

2011-05-16381

381

2011-05-16382

382

2011-05-16383

383

2011-05-16384

384

18.1.3.1.2 Exporting to HTML

385

To export to HTML

386

18.1.3.2 Destination

387

To export to an application

388

To export to a disk file

389

2011-05-16390

390

2011-05-16391

391

18.1.4.1 To open your report

392

18.1.4.2 To save your report

392

2011-05-16393

393

2011-05-16394

394

18.2 Viewing reports

395

2011-05-16396

396

2011-05-16397

397

2011-05-16398

398

2011-05-16399

399

2011-05-16400

400

2011-05-16401

401

2011-05-16402

402

2011-05-16403

403

2011-05-16404

404

18.2.1.6 Data context formats

405

2011-05-16406

406

2011-05-16407

407

18.3 Using smart tags

408

2011-05-16409

409

2011-05-16410

410

Report Alerts

411

2011-05-16412

412

19.2.2 Editing Report Alerts

413

19.2.3 Deleting Report Alerts

414

19.2.4 Viewing Report Alerts

414

2011-05-16415

415

2011-05-16416

416

Using Formulas

417

20.2.1 Formula components

418

20.2.2 Formula syntax

419

20.2.2.2 For more information

420

20.4 Specifying formulas

421

2011-05-16422

422

20.4.1.2 Workshop Tree

423

2011-05-16424

424

2011-05-16425

425

2011-05-16426

426

20.4.2.2 Choosing the syntax

427

2011-05-16428

428

2011-05-16429

429

2011-05-16430

430

2011-05-16431

431

2011-05-16432

432

20.5.3 Editing formulas

433

20.5.5 Copying formulas

434

2011-05-16435

435

20.6 Deleting formulas

436

20.7 Debugging formulas

437

20.7.2 Debugging tutorial

438

20.7.2.1 About this tutorial

438

20.7.2.2 Formula1

438

20.7.2.3 Formula2

439

20.7.2.4 Formula3

440

20.7.2.5 Formula4

440

20.7.2.6 Formula1+2

441

20.7.2.7 FinalFormula

441

2011-05-16442

442

2011-05-16443

443

2011-05-16444

444

2011-05-16445

445

2011-05-16446

446

2011-05-16447

447

2011-05-16448

448

2011-05-16449

449

2011-05-16450

450

2011-05-16451

451

2011-05-16452

452

Parameter Fields and Prompts

453

21.1.2 Prompt considerations

454

2011-05-16455

455

21.1.4 Optional parameters

456

2011-05-16457

457

2011-05-16458

458

21.3.1 List-of-values types

459

2011-05-16460

460

2011-05-16461

461

2011-05-16462

462

2011-05-16463

463

2011-05-16464

464

2011-05-16465

465

2011-05-16466

466

2011-05-16467

467

2011-05-16468

468

2011-05-16469

469

2011-05-16470

470

21.7 The Parameter Panel

471

Business

472

Administrator's Guide

472

2011-05-16473

473

21.8.4 Null handling

474

21.8.5 Long lists of values

475

21.9.1 Unmanaged reports

476

21.9.2 Managed reports

476

Business Views

477

2011-05-16478

478

2011-05-16479

479

2011-05-16480

480

2011-05-16481

481

2011-05-16482

482

2011-05-16483

483

2011-05-16484

484

2011-05-16485

485

2011-05-16486

486

2011-05-16487

487

2011-05-16488

488

2011-05-16489

489

2011-05-16490

490

Subreports

491

22.1.1.1 Unlinked

492

22.1.1.2 Linked

492

2011-05-16493

493

22.2 Inserting subreports

494

22.2.1 Previewing subreports

495

22.2.3 Updating subreports

496

2011-05-16497

497

2011-05-16498

498

2011-05-16499

499

2011-05-16500

500

2011-05-16501

501

2011-05-16502

502

22.8.1 To add a caption

503

2011-05-16504

504

Understanding Databases

505

23.1.2 Indexed tables

506

2011-05-16507

507

2011-05-16508

508

23.2.1 What is SQL?

509

2011-05-16510

510

23.2.2 SQL DBMS

511

23.2.2.1 Stored procedures

512

23.2.4 The SQL language

513

23.2.4.1 SELECT

513

23.2.4.2 DISTINCT

513

23.2.4.3 FROM

513

23.2.4.4 WHERE

514

23.2.4.5 ORDER BY

514

23.2.4.6 GROUP BY

515

2011-05-16516

516

2011-05-16517

517

23.3 Changing data sources

518

2011-05-16519

519

23.4 Working with aliases

520

23.5 Linking tables

521

23.5.1 Link from and link to

521

23.5.2 Link relationships

521

2011-05-16522

522

2011-05-16523

523

2011-05-16524

524

23.5.4.1 Linking data files

525

2011-05-16526

526

23.5.5.1 Linked SQL tables

527

23.5.6.1 Consideration 1

528

23.5.6.2 Consideration 2

529

23.5.6.3 Consideration 3

529

23.5.8 Linking indexed tables

530

23.5.9 Link processing order

531

23.5.10 Linking options

532

23.5.10.1 Inner join

532

23.5.10.2 Left Outer join

533

2011-05-16534

534

23.5.10.3 Right Outer join

535

23.5.10.4 Full Outer join

536

23.5.10.5 Not Enforced

537

23.5.10.6 Enforced From

537

23.5.10.7 Enforced To

538

23.5.10.8 Enforced Both

538

23.5.10.9 Equal [=] link

538

2011-05-16539

539

2011-05-16540

540

2011-05-16541

541

2011-05-16542

542

2011-05-16543

543

2011-05-16544

544

23.6 Server-side processing

545

2011-05-16546

546

2011-05-16547

547

23.7 Mapping database fields

548

23.7.2 Remapping processes

549

2011-05-16550

550

2011-05-16551

551

23.8 Saved Data Indexes

552

23.8.3.1 To index saved data

553

2011-05-16554

554

24.1 Integrating with SAP

555

24.1.1 Introduction

555

2011-05-16556

556

Logging on to the SAP server

557

2011-05-16558

558

24.1.2 Add-Ons

559

24.1.3 Reporting with SAP

559

MDX Query driver overview

560

Formatted reporting overview

561

2011-05-16562

562

2011-05-16563

563

2011-05-16564

564

Selecting cubes for reports

565

Saving reports to BW

566

To save a report to BW

566

To create a simple BW query

567

To save the query in BW

568

To create a new report

568

To group and sort data

569

To summarize the data

569

To save your report

570

2011-05-16571

571

How to summarize data

573

2011-05-16574

574

2011-05-16575

575

2011-05-16576

576

2011-05-16577

577

2011-05-16578

578

2011-05-16579

579

Selecting an ODS object

580

Click Options

581

2011-05-16582

582

2011-05-16583

583

InfoSet Query driver overview

584

2011-05-16585

585

2011-05-16586

586

2011-05-16587

587

Open SQL driver overview

588

2011-05-16589

589

2011-05-16590

590

Linking tables and views

591

To clear Auto-Links

591

Client field

591

Language field

591

Reporting off ABAP functions

591

How it works

592

Limitations

592

Examples

592

2011-05-16593

593

2011-05-16594

594

2011-05-16595

595

What is a data cluster?

596

Mapping ABAP data clusters

597

2011-05-16598

598

2011-05-16599

599

2011-05-16600

600

2011-05-16601

601

2011-05-16602

602

2011-05-16603

603

2011-05-16604

604

2011-05-16605

605

2011-05-16606

606

2011-05-16607

607

2011-05-16608

608

2011-05-16609

609

Applying row-level security

610

2011-05-16611

611

2011-05-16612

612

2011-05-16613

613

2011-05-16614

614

Reports Online Help

615

24.1.3.3.2 Publishing Reports

616

24.2.1 Overview

617

24.3 Integrating with Siebel

618

24.3.1 Connecting to Siebel

618

2011-05-16619

619

2011-05-16620

620

24.3.2.1 Connection names

621

24.3.2.2 Server

621

24.3.2.3 Local

622

2011-05-16623

623

2011-05-16624

624

2011-05-16625

625

24.3.6 Security

626

24.3.7 Views

626

24.3.7.1 The View Mode field

626

2011-05-16627

627

24.3.10 Multi-value columns

628

24.3.11 Data Types

628

24.4.1 Overview

629

2011-05-16630

630

Crystal Reports User's

631

24.5.1 Overview

632

Accessing Data Sources

633

25.2.1 Advantages

634

25.2.2 Disadvantages

634

25.2.3 Three layers

635

25.2.3.1 Crystal Reports

635

25.2.3.2 Data translation

635

25.2.3.3 Database

636

25.2.4.1 Microsoft Access

636

25.2.4.3 Paradox

637

25.2.4.4 DAO

637

25.2.4.5 Pervasive

638

25.2.4.6 Exchange

639

2011-05-16640

640

25.2.4.7 Outlook

641

25.2.4.8 ACT!

641

25.2.4.9 Oracle

642

25.2.4.11 Lotus Domino

642

25.2.4.13 DB2 Server

643

25.2.4.14 Active Data

643

25.2.4.15 Local file system

644

25.2.4.16 NT Event Log

644

25.2.4.18 Web/IIS log files

645

25.3 ODBC data sources

645

25.3.1 Advantages

646

25.3.2 Disadvantages

646

25.3.3 Five layers

647

25.3.3.3 ODBC layer

648

25.3.3.5 Database layer

649

25.3.6.1 Access

650

25.3.6.2 Excel

651

25.3.6.3 Informix

651

25.3.6.5 Visual FoxPro

652

25.3.6.6 Lotus Domino

652

25.3.6.7 OLE DB

653

25.4 JDBC data sources

653

25.4.1 JNDI

654

25.4.2 Five layers

654

25.4.2.3 JDBC layer

655

25.4.2.5 Database layer

655

25.6 Business Views

657

Crystal Reports Online

658

25.8 Crystal Dictionary files

659

2011-05-16660

660

Report Processing Model

661

26.1.4 Pre-pass 2

662

26.1.5 Pass 2

662

26.1.6 Pass 3

663

2011-05-16664

664

A.1 Drive:\filename.extension

665

A.2 Drive:\test.rpt

665

2011-05-16666

666

2011-05-16667

667

2011-05-16668

668

Creating Accessible Reports

669

2011-05-16670

670

2011-05-16671

671

2011-05-16672

672

27.2.2 Text

673

2011-05-16674

674

27.2.2.3 Using punctuation

675

27.2.2.4 Formatting text

676

27.2.3 Color

677

27.2.3.1 Contrasting colors

677

27.2.4 Navigation

678

27.2.5 Parameter fields

679

2011-05-16681

681

2011-05-16682

682

2011-05-16683

683

2011-05-16684

684

2011-05-16685

685

2011-05-16686

686

2011-05-16687

687

2011-05-16688

688

2011-05-16689

689

27.7 Resources

690

More Information

691

LocationInformation Resource

692

(continued)

693

2011-05-16705

705

2011-05-16706

706

SAP Urządzenia