In this section: |
The only requirement for reporting is identifying a data source. Beyond that, the structure of a report request is very flexible and you only need to include the report elements you want. For example, you only need to include sorting instructions if you want your report to be sorted, or selection criteria if you want to report on a subset of your data.
A report request begins with the TABLE FILE command and ends with the END command. The commands and phrases between the beginning and end of a request define the contents and format of a report. These parts of the request are optional; you only need to include the commands and phrases that produce the report functions you want.
The following are the most frequently used options for structuring a report request. (Except where otherwise noted, see Report Painter Basics in the Creating Reports With Report Painter manual for details about these and many other reporting features.)
You can sort information vertically, down a column, horizontally, or across a row. You can also combine vertical sorting and horizontal sorting to create a simple matrix.
For details see, Creating Temporary Fields.
For details, see Joining Data Sources.
For details, see Saving and Reusing Your Report Output.
You can run the request as an ad hoc query or save it as a procedure. Saving a report request as a procedure enables you to run or edit it at any time.
WebFOCUS |