Manual centura

Gupta Report Builder
Business Reporting

Trademarks
GUPTA, SQLBase, SQLRouter, and SQLTalk are trademarks of Gupta Technologies, LLC registered in the United States and/or other countries. SQLWindows is a registered trademark of Microsoft Corporation, and is used under license to Gupta Technologies, LLC. Centura and Centura Software are registered trademarks of Centura Software Corporation,and are used under license to Gupta Technologies, LLC. Team Developer, Team Object Manager, Web Developer, QuickObjects, Object Nationalizer, Report Builder, Connectivity Administrator, Development Kit, Component Development Kit, SQLBase Resource Manager, and SQLConsole are names of products from Gupta Technologies, LLC. Adobe is a trademark of Adobe Systems, Incorporated. IBM, OS/2, NetBIOS, andAIX are registered trademarks of International Business Machines Corporation. Linux is a trademark of Linus Torvalds. Red Hat is a trademark of Red Hat, Incorporated. Novell and Netware are trademarks of Novell, Inc. SUSE is a trademark of SUSE LINUX AG. Java, JavaScript, and Solaris are trademarks of Sun Microsystems, Incorporated. Microsoft, Outlook, PowerPoint, Visual C++, Visual Studio,Internet Explorer, Internet Information Server, DOS, Win 32, Windows, ActiveX, MSDN, SQL Server, and Visual Basic are either registered trademarks or trademarks of Microsoft Corporation in the United States of America and/or other countries. Netscape FastTrack and Navigator are trademarks of Netscape Communications Corporation. All other product or service names mentioned herein are trademarks orregistered trademarks of their respective owners.

Copyright
Copyright © 20054 by Gupta Technologies LLC. All rights reserved. Business Reporting 20-6219-0001 June 2005

Contents
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii
Who should read this manual . . . . . . . . . . . . . . . . . . 1-viii What is in this manual . . . . . . . . . . . . . . . . . . . . . .. . 1-viii Notation conventions. . . . . . . . . . . . . . . . . . . . . . . . . 1-viii Other helpful resources. . . . . . . . . . . . . . . . . . . . . . . . 1-x Send comments to... . . . . . . . . . . . . . . . . . . . . . . . . . . 1-x

1 Introducing Gupta Report Builder. . . . . . .

1

Building reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2 Types of reports . .. . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2 Multi-column reports . . . . . . . . . . . . . . . . . . . . . . . . . . 1-3 Form letters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-3 Break group summary reports. . . . . . . . . . . . . . . . . . . 1-3 Two pass totals reports . . . . . . . . . . . . . . . . . . . . . . . . 1-3 Input cross tabular reports . . . .. . . . . . . . . . . . . . . . . 1-3 Report templates. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-4 Parts of a report template . . . . . . . . . . . . . . . . . . . . . . 1-5 Running existing reports . . . . . . . . . . . . . . . . . . . . . . . 1-8 Examples of running Report Builder from a command line1-9 Where to get more information . . . . . . . . . . . . . . . . . . 1-9

2Creating Reports

........................ 1

Report data sources . . . . . . . . . . . . . . . . . . . . . . . . . . 2-2 Data source requirements . . . . . . . . . . . . . . . . . . . . . . 2-2 Using an integrated query . . . . . . . . . . . . . . . . . . . . . . 2-2 Using SQLWindows as a data source. . . . . . . . . . . . . 2-3 Importing Quest files . . . . . . . . . . . . . . . . . . . . . .. . . . 2-3 Defining a query . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-6 Source property page . . . . . . . . . . . . . . . . . . . . . . . . . 2-7 Conditions property page . . . . . . . . . . . . . . . . . . . . . . 2-9

iii

Sort property page . . . . . . . . . . . . . . . . . . . . . . . . . . 2-10 Group By property page . . . . . . . . . . . . . . . . . . . . . . 2-11...