Table of Contents

Working with Reports

I. Banded Report Writer

The OpenInsight Banded Report Writer is a tool used for creating and editing powerful and easy-to-use banded reports that are compatible with Access and Crystal models. Using the OpenInsight BRW the developer or end-user can create columnar reports on any attached table with a minimum of effort.

II Creating a Report

In this procedure you’ll create a columnar report based on the SALES_SALESTERRITORY table.

From the OpenInsight IDE choose New, Reports, Banded Report Writer.

sql_077.jpg

Choose New Report from the File menu. The BRW Design Wizard is displayed.

sql_078.jpg

sql_079.jpg

Select the Data Source for the new report. Select the SALES_SALESTERRITORY table.

sql_080.jpg

Select the Fields that will be included in the new report. Choose TERRITORYID, NAME, GROUP, SALESYTD, COSTYTD, NETSALESYTD.

sql_081.jpg

Select the layout for the new report.

sql_082.jpg

Select the style for the new report.

sql_083.jpg

Enter the title for the new report and click the Finish button.

sql_084.jpg

The Banded Report will output to the Print Preview window.

sql_085.jpg

Click on the Design button to edit the report.

sql_086.jpg

Choose File, Save to save the report.

sql_087.jpg

Assign your report to a Report Group and click OK.