REPORT - Run a report within this report (Reports & Settings Report Generator function)

Syntax

$REPORT{system, report code, range, column}

Description

Runs a report within this report, the output can then be analysed or manipulated further. This allows you to call report generators for other modules, giving you access to information that you may not from this report generator.

Parameters

system

A text parameter that can be omitted (it defaults to " ").

The system of the report generator you want to call. Leave blank to use the system of the report generator this function is used from.

CC

Contract Costings

TI

Logistics Management

MA

Asset Management

OP

Order Processing

PR

Payroll

PP

Personnel Planning

RP

Reports & Settings

SP

Sales Prospecting

ST

Stock Control

TC

Vehicle Costings

VS

Unit Sales

WS

Unit Workshop

report code

A text parameter that can be omitted (it defaults to " ").

The 3 character code for the report you want to run. This report must exist in the system you choose. Alternatively, you may leave the code blank to run a "temporary report" which will be created and deleted as it runs. If you run a temporary report, you must supply a range and a column for the report

range

A text parameter that can be omitted (it defaults to " ").

The range criteria for the report. If you run a specific report, this will overwrite any range that exists for this report. If you are running a temporary report the range must be defined here. See the knowledge base support pages for information on how to write a detailed range.

column

A text parameter that can be omitted (it defaults to " ").

The output you want from the report. This is limited to one column for a temporary report. You will need to define the column as a "Text" type. See the knowledge base support pages for information on how to create a column.

Returns

A text value. A string containing the output of the report. This will be the final line output by the report.