Report Builder

Report Builder Guide To Creating Reports

Unify Corporation

Table of Contents

Abstract...............................................................................................4 Introduction.........................................................................................4 Requirements......................................................................................4Creating Different Types of Reports...................................................5 Multi-Column Reports..........................................................................5 Form Letters........................................................................................5 Break Group Summary Reports..........................................................5 Two-Pass TotalReports......................................................................6 Input Cross-Tabular Reports...............................................................6 Getting Started....................................................................................7 Creating a Query..................................................................................7 The Source PropertyTab....................................................................8 The Conditions Property Tab............................................................12 To Define a Condition........................................................................13 The Sort Property Tab.......................................................................15 Defining a Group ByCondition..........................................................16 Defining a Group Condition…………...................................................17 The SQL Property Tab.......................................................................17 The Result Property Tab...................................................................18 Input Totals.......................................................................................19Defining Totals for Your Report........................................................19 Adding Input Totals to Your Template.............................................20 Input Crosstabs.................................................................................23 Formatting Your Crosstab Matrix.....................................................23 Creating CrosstabReports...............................................................23 Picture Objects.................................................................................33 Importing a Static Object to Your Report........................................33 Formatting Picture Objects……………………………………………………...36 Creating Graphs in Reports...............................................................36 Creating Form LetterReports...........................................................41 Creating Reports with Conditional Display…………………………….....46 Creating Reports with LONG Data Stored in Databases..................48 Conclusions.......................................................................................50

2

Abstract
This paper is written as a tutorial to help the reader create reports with ReportBuilder using easy-to-follow steps and examples.

Introduction
Report Builder is an easy-to-use dynamic reporting tool that creates on-demand reports to improve your business IQ. Report Builder works both on the Microsoft Windows and Linux operating systems. Organizations are always searching for tools to transform data into valuable information which enables better decision making. Report Builderaffords organizations of any size the competitive advantage of working smarter and more effectively.
Requirements To easily understand the steps in this guide it is strongly recommended that the reader has the following: Report Builder 2005.1 SQLBase 9.0.1 with the sample database ISLAND installed

SQLBase should be running and Report Builder must be able to connect to the ISLAND database. If...