|
|
OnRequest™
Support: Tutorial:
Piloting OnRequest™
Report
Writing
|
| Report
Writer Window |
|
| OnRequest’s
report writer allows you to create a Report
Layout, gather data attached to objects
in a drawing, display formatted results
and print these formatted results. To
Open a Report Layout, go to the Data menu,
select Layout Report, New. This brings
up a blank Report Layout. |
|
- Selection
Tool – Use to select
fields or objects on the report
- Field
Tool – Use to add floating
fields to the header or body of the
report. A field dialogue box will
open to allow selections of records
from project fields for the header
area or project and database fields
for the body of the report. Calculated
fields can also be added
- Line
Tool – Use the line
tool to add underscores or pointers
to the report
- Label
Tool – Use the Text
Label tool to add user defined label
boxes to the report
- Rectangle
Tool – Use the Rectangle
Tool to add custom borders to text
objects
- Run
Tool – Click on the
Run Tool to exit report layout and
run the report
- Sort
Tool – Click on the
sort tool to add sorting, subtotals,
column totals etc. to the report
- Field
Tool – Use the Field
Tool to add fields or calculations
to the report columns. Fields will
be added horizontally along the header
of the report
- Save
Tool – Use the save
tool to add report layouts to the
run report pull-down menu or save
the report layout to an external file.
|
The
far right menu across the top will become
the Report menu once a report layout
has been opened. This is used to control
many aspects of report production.
- Hide Detail toggles to summary
report
- Where… creates
where statements- see below
- Use Data From defines
where the data will be gathered from
- Text Settings - Controls
the display of fields, text labels
and appearances. Includes font, size,
style and alignment. Border,
- Fill
Pattern and Line
Thickness specify appearance
of borders for fields and labels,
lines, rectangles and fill color.
- Reports can be loaded
from external files
- Report data can be output
to a text file
|
 |
Where
Statement - Selecting Where…
from this menu allows a statement
to be written to determine which records
will be included, or not included,
in the report.
This
feature performs an additional filter
of data to be included on the report
after the “Use Data From”
data selection has been made. Select
a report or database record, select
a record field, select a comparative
operator, add comparative expression
and click OK.
|
 |
Sort
Dialogue
|
Summary
Reports
Sort fields will display entered values.
Unsorted numeric fields will be totaled.
Unsorted text or date fields will be counted.
|
Calculation
Fields
A report field can be created using
calculations, which may include data
from the existing fields in the database.
Using the Calculation button on the
Add Fields dialog box does this.
|
Exporting
Data from Report - Exports
the contents of a report to an external
file.
|
|
