See the NOVUS Walkthrough Guide for general information about the system.
Universal Report Generator - Setup
|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.
|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.
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.