RW - Report Writer
Activate Fast Report Writer Usage Table Update (Y/N): | When it is set to N or blank, then in order to find how many times the report was used the system performs a query - select count(*)- for that particular report and then counts the number of occurrences. If it is a frequently used report that query can have a significant impact on the speed of the report each time it is run and if many people are running it frequently or many such reports frequently, it causes a general lag in performance. Setting this profile to Y, writes a count to a header record for that report definition and each time it is run, that number is incremented instead of having to query and count all the occurrences The only drawback with that is you lose track initially of how many times the report has actually been run because the count starts again at 1 for all reports when you initially change this profile. |
Batch File Java Command Line Settings for Batch Report Writer: | Do not change unless directed. Affects long-running report performance. |
Display Document Storage Fields in HRW (Y/N): | |
*Comma separated list of Form Codes to display in Employee Form Data Table: | |
*Comma separated list of Form Codes to display in Final Form Data Table: | |
Display E-Form Fields in HRW (Y/N): | |
Characters to be converted to double quotes in RW Merge: | |
Report Names that are exempt from the embedded report limit (separated with commas): | Obsolete |
Warehouse Report Names that are exempt from the embedded report limit (separated with commas): | Obsolete |
Embedded Report Limit (number of embedded report instances to allow per report): | Obsolete |
Embedded Warehouse Report Limit (number of embedded report instances to allow per report): | Obsolete |
FRW-Use NVL Function on period during left joins to FIN_GL_PERIOD: | |
FRW-Ignore PRM Assignment Authorizer Locations (Y/N/O): |
|
HRW-Ignore PRM Assignment Authorizer Locations (Y/N/O): |
|
PRW-Ignore PRM Assignment Authorizer Locations (Y/N/O): |
|
RRW-Ignore PRM Assignment Authorizer Locations (Y/N/O): |
|
*[Inline Parameter Reports] Comma separated list of employee numbers that should be allowed to access employees at their location(s): | |
*[Inline Parameter Reports] Comma separated list of position codes that should be allowed to access employees at their location(s): | |
*[Inline Parameter Reports] Comma separated list of role codes that should be allowed to access employees at their location(s): | |
*[Inline Parameter Reports] Secure Inline Employee Numbers (Y/N): | |
Maximum records to return from Report Writer query: | |
*Select Box Height i.e. number of rows to display in select boxes: | Can be used to increase the height of select boxes in report writer when selection fields are prompted at run time, during report creation, and during report edit. |
Characters to be converted to single quotes in RW Merge: | |
SQL Server Double Keyword for CONVERT function (will default to DOUBLE if blank, should probably enter SQL_DOUBLE if driver is newer): | |
Milliseconds for performance timing purposes - blank or zero turns off timing : | |
Turn on folders in Report Viewer (Y/N): | |
Write troubleshooting confirmation records - RW (Y/N): | Captures the query and provides details about the report in the HR Web Confirmation Report. This information is stored in the HRWEB2 file. |