Crystal Reports 10 - The Complete Reference

George Peck

McGraw-Hill /Osborne 2100 Powell Street, 10th Floor Emeryville, California 94608 U.S.A.

To arrange bulk purchase discounts for sales promotions, premiums, or fund-raisers, please contact McGraw-Hill/ Osborne at the above address. For information on translations or book distributors outside the U.S.A., please see the International Contact Information page immediately following the index of this book.

Crystal Reports 10: The Complete Reference

Copyright 2004 by The McGraw-Hill Companies. All rights reserved. Printed in the United States of America. Except as permitted under the Copyright Act of 1976, no part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without the prior written permission of publisher, with the exception that the program listings may be entered, stored, and executed in a computer system, but they may not be reproduced for publication.

1234567890 CUS CUS 01987654

ISBN 0-07-223166-1

Publisher Brandon A. Nordin

Vice President & Associate Publisher Scott Rogers

Acquisitions Editor Lisa McClain

Project Editors Carolyn Welch, Janet Walden

Acquisitions Coordinator Athena Honore

Contributing Writers Brian Norris, Jim Keogh

Technical Editors Julia Hennelly, Brian Norris, Mandeep Jassal, Daniel Paulsen, Sean Johnson

Copy Editor Robert Campbell

Proofreader Susie Elkind

Indexer Claire Splan

Composition Apollo Publishing Services

Illustrators Kathleen Edwards, Melinda Lytle

Series Design Peter F. Hancik, Lyssa Wald

This book was composed with Corel VENTURA ¢ Publisher.

Information has been obtained by McGraw-Hill /Osborne from sources believed to be reliable. However, because of the possibility of human or mechanical error by our sources, McGraw-Hill /Osborne, or others, McGraw-Hill /Osborne does not guarantee the accuracy, adequacy, or completeness of any information and is not responsible for any errors or omissions or the results obtained from the use of such information.

For Denise We made it through fifteen. Then, we finished 10.

About the Author

After more than ten years as an internal consultant and trainer in a large corporation, George Peck founded his own consulting and training firm, The Ablaze Group, in 1994 (www.AblazeGroup.com). He has trained, consulted, and developed custom software for large and small organizations throughout the United States, Canada, the United Kingdom, and Puerto Rico.

George works as both a trainer and consultant exclusively with Crystal Reports, Crystal Enterprise, and Crystal/Seagate Info . This is his fifth title in the Crystal Reports: The Complet e Reference series, best-sellers published by McGraw-Hill/Osborne. He is also the author of Crystal Reports Professiona l Results, also published by McGraw-Hill/Osborne.

Prior to his computer career, George was a broadcaster . His voice may still be heard in various national radio and TV commercial and promotional campaigns .

Acknowledgments

Writing a sixth book means gathering my thoughts of acknowledgment for the sixth time. Each time it gets a little harder (not that there aren t sufficient numbers of people to thank, but getting creative about it becomes more challenging). So, while the creative approach may be dulled, the heartfelt thanks aren t.

The first acknowledgment has to go to one of the most helpful, responsive folks that Business Objects could hope to employ . Thanks so much to Jaylene Crick for keeping me in software, and keeping me in answers. This book wouldn t be close to possible without all the help you gave me during the whole development process. Thank you.

There are a few people who helped me put some of the finishing touches on the chapters. First, thanks to Jim Keogh for putting the Java chapter together. Now I know what J2EE stands for! And, Brian Norris deserves gratitude for not only helping write and edit the Crystal Enterprise materials, but for being a good and valuable friend and colleague.

McGraw-Hill/Osborne believes in these books so deeply. I truly appreciate your loyalty. Particular appreciation is due my acquisitions editor Lisa McClain. Thanks for the breathing room this time around. Bob Campbell is a very capable editor. I appreciate yet another stellar job. Not only is Carolyn Welch a great project editor, but we actually see eye to eye politically ” no question on whom we re voting for this fall! Much appreciation goes to Janet Walden, who came in on a white horse at the last minute. And, Athena Honore deserves thanks for keeping all the pieces together. Finally, editorial director Wendy Rinaldi started it all. I m so glad we can stay in touch and have an occasional great meal when I m in the Bay Area.

Once I write the words, there are some dedicated folks who double-check my work technically. Thanks to Julia Hennelly, Mandeep Jassal, Sean Johnson, and Dan Paulsen for keeping me on track and providing little tidbits of great technical stuff that make the book just that much better.

And, for the sixth time, I offer special acknowledgment to Dad. Thanks for all your help, support, and love. I hope you re proud of me.

George Peck, April 2004 [e-mail] www.CrystalBook.com