Professional Crystal Reports for Visual Studio .NET, 2nd Edition

386 Pages·2004·16.278 MB·English

by  David McAmis

557300 FM.qxd 3/24/04 4:27 PM Page i
Professional Crystal Reports®
for Visual Studio®.NET
Second Edition
David McAmis
557300 FM.qxd 3/24/04 4:27 PM Page iv
557300 FM.qxd 3/24/04 4:27 PM Page i
Professional Crystal Reports®
for Visual Studio®.NET
Second Edition
David McAmis
557300 FM.qxd 3/24/04 4:27 PM Page ii
Vice President and Executive Group Publisher: Richard Swadley
Vice President and Executive Publisher: Bob Ipsen
Vice President and Publisher: Joseph B. Wikert
Executive Editorial Director: Mary Bednarek
Senior Acquisitions Editor: Jim Minatel
Editorial Manager: Kathryn A. Malm
Senior Production Editor: Fred Bernardi
Development Editor: Adaobi Obi Tulton
Production Editor: Felicia Robinson
Media Development Specialist: Kit Malone
Text Design & Composition: Wiley Composition Services
Copyright © 2004 by Wiley Publishing, Inc., Indianapolis, Indiana. All rights reserved.
Published simultaneously in Canada
No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any
means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under Section
107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or
authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc., 222 Rose­
wood Drive, Danvers, MA 01923, [phone], fax [phone]. Requests to the Publisher for permission
should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN
46256, [phone], fax [phone], E-mail: [email protected].
LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND THE AUTHOR MAKE NO REP­
RESENTATIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CON­
TENTS OF THIS WORK AND SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT
LIMITATION WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED
OR EXTENDED BY SALES OR PROMOTIONAL MATERIALS. THE ADVICE AND STRATEGIES CONTAINED
HEREIN MAY NOT BE SUITABLE FOR EVERY SITUATION. THIS WORK IS SOLD WITH THE UNDERSTAND­
ING THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING LEGAL, ACCOUNTING, OR OTHER PROFES­
SIONAL SERVICES. IF PROFESSIONAL ASSISTANCE IS REQUIRED, THE SERVICES OF A COMPETENT
PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER NOT THE AUTHOR SHALL BE
LIABLE FOR DAMAGES ARISING HEREFROM. THE FACT THAT AN ORGANIZATION OR WEB SITE IS
REFERRED TO IN THIS WORK AS A CITATION AND/OR A POTENTIAL SOURCE OF FURTHER INFORMA­
TION DOES NOT MEAN THAT THE AUTHOR OR THE PUBLISHER ENDORSES THE INFORMATION THE
ORGANIZATION OR WEB SITE MAY PROVIDE OR THE RECOMMENDATIONS IT MAY MAKE. FURTHER,
READERS SHOULD BE AWARE THAT INTERNET WEB SITES LISTED IN THIS WORK MIGHT HAVE
CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS WRITTEN AND WHEN IT IS READ.
For general information on our other products and services, please contact our Customer Care Department within
the United States at [phone], outside the United States at [phone], or fax [phone].
Trademarks: Wiley, the Wiley Publishing logo, Wrox, the Wrox logo, Programmer to Programmer, and related trade
dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates. Crystal Reports is a
registered trademark of Seagate Software, Inc. Visual Studio is a registered trademark of Microsoft Corporation in
the United States and/or other countries. All other trademarks are the property of their respective owners. Wiley
Publishing, Inc., is not associated with any product or vendor mentioned in this book.
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be
available in electronic books.
Library of Congress Control Number: 2004003621
ISBN: 0-7645-5730-0
Printed in the United States of America
10 9 8 7 6 5 4 3 2 1
557300 FM.qxd 3/24/04 4:27 PM Page iii
To Tony Breese, who is still keeping the faith,
waiting for that sci-fi book.
557300 FM.qxd 3/24/04 4:27 PM Page iv
557300 FM.qxd 3/24/04 4:27 PM Page v
Acknowledgments

As with any book, there was incredible team of people who brought this project to life. First and foremost,
thanks to Sharon Cox for guiding this book through the transition to Wiley. And special thanks to Adaobi
Obi Tulton, who was the glue that held this project together and who had to put up with me for so long!
To everyone else from the Wiley/WROX team who was involved in the book, a heart-felt thank you.
Behind the scenes, there are many people I work with, especially Colin, Alice, and Lisa, who have been a
sounding board and have had to hear about this project for going on two years now. As always, a big
thank you needs to go out to the Crystal Decisions Asia Pacific team for their support and assistance,
and to Craig in particular for his faith and confidence in me and for continually keeping me challenged.
And on a personal note, there is a worldwide network of friends and family who offer their support and
encouragement on a daily basis, which I couldn’t do without. Nunc scio quit sit amor.
557300 FM.qxd 3/24/04 4:27 PM Page vi
557300 FM.qxd 3/24/04 4:27 PM Page vii
About the Author
David McAmis is a Crystal Certified Consultant and trainer, living and working in Sydney, Australia as
a partner in Avantis Information Systems. As a consultant for Avantis and on behalf of Crystal Decisions,
David creates Windows, Web, and mobile applications incorporating Crystal technology across a wide
number of platforms, databases, and ERP systems to deliver innovate solutions for common business
problems.
In his varied career, he has held the roles of consultant, technical trainer, university lecturer, and consult­
ing services manager and has served as vice-president of a software and services company in the United
States. David holds a B.S. degree in Management Information Systems and is a Microsoft Certified
Professional, as well as a certified trainer and consultant for numerous software products.
David has been working with Crystal Reports since version 4.5 and is an active member of the beta and
user group community and a self-confessed “raving fan.” In his career as a Crystal developer and trainer,
he has traveled the world and taught over 800 students. You can reach him at [email protected].