From Wiki
Jump to: navigation, search
Name Universal Report Generator - Setup
Area Utilities

See the NOVUS Walkthrough Guide for general information about the system.

Universal Report Generator - Setup

The REPSETUP program enables reports to be accessed using the REPGEN program.

Field name Description
Report Name This is the name of the SQL script in execlibrary/scripts without the _p or _x and excluding the extension (.sql)
Description This is a full description of the script.
RGrp This determines the tab in the REPGEN program where the report will appear.
MIS 'P' specifies that the report is only for viewing or printing, 'E' that it is only available for export to Excel. If the field is left blank then the report is available for viewing, printing and exporting to Excel. The MIS program has been retired so option 'Y' is no longer applicable.
Flg This is set to 'Y' if the exported Excel report requires a pre-formatted worksheet.
Lev Set this if the report can only be run by a user with an authorisation level equal or higher than the number entered.
Grp Set this if the user has to be a member of this security group in order to run the report.

Clicking the Proceed button will display the parameters for the report name selected.


Orientation can either be 'P'ortrait or 'L'andscape.

Font Size can be between 6 and 12 and specifies the size of the text in the report.

Field name Description
No This is the parameter passed through to the SQL script. Number 1 is reserved by the system so the first number must be 2.
Parameter Description This describes what the parameter is. Please make this as descriptive as possible.
Type This is the type of parameter. On the right hand side of the screen a list of valid parameter types is shown.

The 'Save Report' will update the database and make the report available in the REPGEN program.

Version History

v4.2.0 – Updated to latest version

V11J - all reports where is_standalone is 'Y' have been removed from REPSETUP.

V10T - First version of this form to use the new style. No other updates except the restyle.