OurTown2000 Query Handbook - Creating Reports

<-Back (To Modify a Query-Selecting the Type of Output) Table of Contents Next (Creating Reports-Modifying a Report Form)->

Using the Report Setup Dialog

In the Query Overview dialog, if you have chosen to output to a report and pressed  Run Query, you will be taken to this Report Setup dialog. 

 

This screen lets you customize the appearance of your report, preview the report on screen and then print it.

 

Your options in the Report Setup dialog are as follows.

 

Button

Action

Description

Specifies where to send the report.

·     Printer- sends hard copy output to your printer.

·     Disk file- writes the report contents to a text for import into a word processor.

·     Screen- displays a screen preview of the report.

Activates report preparation.

Generates the report and sends it to the printer, disk file or screen destination you selected.

 

Displays a report form so you can edit it.

For more information on modifying report forms, see Modifying a Report Form.

NOTE: Don’t specify fields that are missing from the OT2 Query Maker dialog: Select Fields To Show In Query. Reports cannot find such fields unless they are part of the query.

Displays an on-screen table view of the query results. After viewing the browse, OT2 Query Maker returns you to this Report Setup dialog.

Dismisses the dialog without outputting the report and returns you to the prior screen.

You are returned to the Query Overview dialog.

OT2 Query Maker will restore the report form to its original state.  This is the state it was in the first time you ran the query.

Changes are eliminated:

    - Report forms return to a single-line columnar format with fields in the same order as you specified them in the Fields to Show in Query dialog.

   

Displays the contents of any ASCII text file on your computer’s disk.

The main purpose of this feature is to display the contents of text files written to disk.   If you want to view a report, it will be easier to read if you select a screen output destination rather than send it to disk and view it here.

Eject page

      at report's

      start

 

If checked, then a page eject will be sent to your printer before the report starts printing.

You will only need to do this if you notice that the first page of your report contains information from the last document that was sent to your printer.

 


<-Back (To Modify a Query-Selecting the Type of Output) Table of Contents Next (Creating Reports-Modifying a Report Form)->

OurTown2000 Query Handbook - Creating Reports