====== 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?1024x689}}

 

The Banded Report will output to the Print Preview window.

 

 

{{SQL_085.jpg?1024x688}}

 

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.