guides:bfs:sql:working_with_reports

Working with Reports

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.

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.

  • guides/bfs/sql/working_with_reports.txt
  • Last modified: 2023/10/25 10:49
  • by 127.0.0.1