Sams Teach Yourself Crystal Reports 9 in 24 Hours.pdf

(5928 KB) Pobierz
Teach Yourself
Crystal Reports 9
Joe Estes
Neil FitzGerald
Kathryn Hunt
Steve Lucas
Ryan Marples
®
in
24
Hours
800 East 96th St., Indianapolis, Indiana, 46240 USA
Sams Teach Yourself Crystal Reports 9
in 24 Hours
Copyright © 2003 by Sams Publishing
All rights reserved. No part of this book shall be reproduced, stored in a
retrieval system, or transmitted by any means, electronic, mechanical, photo-
copying, recording, or otherwise, without written permission from the pub-
lisher. No patent liability is assumed with respect to the use of the information
contained herein. Although every precaution has been taken in the preparation
of this book, the publisher and author assume no responsibility for errors or
omissions. Nor is any liability assumed for damages resulting from the use of
the information contained herein.
International Standard Book Number: 0-672-32090-8
Library of Congress Catalog Card Number: 00-109102
Printed in the United States of America
First Printing: September 2002
05
04
03
4
3
®
A
SSOCIATE
P
UBLISHER
Michael Stephens
A
CQUISITIONS
E
DITOR
Michelle Newcomb
D
EVELOPMENT
E
DITOR
Mark Renfrow
M
ANAGING
E
DITOR
Charlotte Clapp
P
ROJECT
E
DITOR
Andy Beaster
C
OPY
E
DITOR
Rhonda Tinch-Mize
I
NDEXER
Kelly Castell
P
ROOFREADER
Abby VanHuss
T
ECHNICAL
E
DITOR
Marc Borbas
Trademarks
All terms mentioned in this book that are known to be trademarks or service
marks have been appropriately capitalized. Sams Publishing cannot attest to the
accuracy of this information. Use of a term in this book should not be regarded
as affecting the validity of any trademark or service mark.
T
EAM
C
OORDINATOR
Lynne Williams
I
NTERIOR
D
ESIGNER
Gary Adair
C
OVER
D
ESIGNER
Warning and Disclaimer
Every effort has been made to make this book as complete and as accurate as
possible, but no warranty or fitness is implied. The information provided is on
an “as is” basis. The author and the publisher shall have neither liability nor
responsibility to any person or entity with respect to any loss or damages aris-
ing from the information contained in this book.
Aren Howell
P
AGE
L
AYOUT
Ayanna Lacey
G
RAPHICS
Oliver Jackson
Tammy Graham
Bulk Sales
Sams Publishing offers excellent discounts on this book when ordered in quan-
tity for bulk purchases or special sales. For more information, please contact:
U.S. Corporate and Government Sales
1-800-382-3419
corpsales@pearsontechgroup.com
For sales outside of the U.S., please contact:
International Sales
1-317-428-3341
international@pearsontechgroup.com
Contents at a Glance
Introduction
1
P
ART
I
Introduction to Crystal Reports 9.0
Hour 1
2
3
4
The Value of Crystal Reports 9
Getting Started with Crystal Reports 9
Accessing Your Data
Using the Default Report Wizards
11
13
29
49
65
P
ART
II
Fundamentals of the Crystal Reports Design Environment 85
Hour 5
6
7
Creating and Designing Basic Reports
Selecting and Grouping Data
Filtering, Sorting, and Summarizing Data
87
107
131
P
ART
III
Formatting Reports
Hour 8
9
10
11
12
Fundamentals of Report Formatting
Working with Report Sections
Understanding and Implementing Formulas
Visualizing Your Data with Charts and Maps
Implementing Parameters for Dynamic Reporting
147
149
169
189
219
243
P
ART
IV
Enhancing Crystal Reports
Hour 13
14
15
16
17
18
19
Custom Formatting Techniques
Using Cross-Tabs for Summarized Reporting
Using Record Selections and Alerts for Interactive Reporting
Using Subreports
Using Formulas and Custom Functions to Implement Complex
Business Logic
Working with the Report Component Repository
Designing Effective Report Templates
259
261
273
289
303
319
333
345
P
ART
V
Advanced Report Design Concepts
Hour 20
21
22
Multidimensional Reporting Against OLAP Data
Additional Data Sources for Crystal Reports
Optimizing SQL Queries in Crystal Reports
363
365
391
401
Part VI Sharing and Distributing Crystal Reports
Hour 23
24
Distributing Crystal Reports
Crystal Reports in Applications—a Developer’s Perspective
411
413
431
P
ART
VII
Supplemental Crystal Reports Technologies
Appendix A
Appendix B
Crystal Reports for Visual Studio .NET
Common Crystal Reports FAQs and Tips
Index
447
449
463
473

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin