Web Report Server/400 Revision History
From Support
1.28
2006-05-25
Implemented changes that will allow the *AS400 or *as400 option to work with OS V5R3.
1.27
2006-05-22
Corrected problem that resulted in 'PDF' not being able to be set as an output type on option 3, Edit User Output Queue Listing.
1.26
2006-05-18
Made correction so error messages will display on the Edit Output Queue option.
1.25
2006-04-03
CSV has been added as an output type to Web Report Server/400.
1.24
2004-11-26
Turned off debug SQL. This had been hard coded as on in V1.23. Added data area WRSDEBUG to condition the SQL debug mode. Default value: *NO
Added WRSORDER data area to set default sort order to date/descending. Default value: ORDER BY WRDATE DESC
Added WRSHITS data area to set the default number of hits returned when bypassing search. Default value: 300
Removed command call from user entry. The actual field was allow delete which has not been implemented yet, so the screen value was showing the wrong text and the field was not needed at this point since it's not implemented yet.
Added option to bypass search screen to the new user entry screen. If the global bypass search data area WRSBYSRCH is set to *NO, the user setting determines whether to bypass the search screen. This makes bypassing the search screen much more flexible by user.
1.23
2004-11-15
Added WRSUSRCHK setting to check user access against AS/400 security. Added WRSURL data area to allow users to specify the main URL to call when calling the Web Report Server software. If blanks, the required URL path becomes: /rjswrs/wrs200r This feature has not been tested and released yet. If new user is created and *AS400 or *as400 is entered for the password value, the user ID is checked to make sure it matches an existing AS/400 user profile and the AS/400 user password is correct.
If WRSBYSRCH data area value is set to *YES, users will be taken to the search result list right away after logging in. This setting may later need to be moved to the use table so not all users have this setting.
1.22
2004-09-01
Changed CGI service program to use QZHBCGI instead of QTMHCGI to avoid problems with the Apache Web Server on V5R3. On V5R3 the original HTTP server is no longer available. Programs affected: WRS200R.
QTMHCGI now copies from QHTTPSVR library instead of QTCP.
1.21
2003-09-23
Added spool overrides to PDF converter. Page Orientation Override values: *PORTRAIT = portrait page orientation *LANDSCAPE = landscape page orientation Font Size Override (1-20) Line Space Override suggested values: 80 col portrait = 8 132 col landscape = 7 198 col landscape = 6
Changed QUSRSPLA data area default from 1411 to 1600 so we pick up the user defined options correctly. Thes fields are used for overriding spool file info.
1.20
2002-09-14
Major Change: Implemented the ability to handle up to 999999 spool file entries per AS/400 job. This is to comply with V5R1 update to allow this.
Note: If users are using any of the report server commands in their own programs, they will need to test their programs to make sure the programs don't need to be updated to handle the new 6 digit spool file numbers. User was having problems with downloaded TXT reports doubling information and also doubling in file size. Report also had a garbage line of data in the middle of the report. The problem started occurring after upgrading to V5R1. V5R1 now includes the Apache Web Server and AS/400 HTTP Web Server. It turns out there was a logic error in the report download program that was causing the report doubling if the Apache Web Server was being used and the AS400HTTP setting was set in the WRSWEBSVR data area.
1.19
2002-09-02
Added initial F1 help panel implementation to selected commands.
1.18
2002-08-17
Added WRSUPG command to upgrade settings to new library if installed.
1.17
2002-08-16
Added WRSWEBSVR command to choose which web server you are using: AS400HTTP - AS/400 HTTP Server APACHE - AS/400 Apache HTTP Server. Also added WRSWEBSVR data area to hold the setting. WRS202 was changed to handle the APACHE web server. It wasn't returning HTML reports correctly. They were being converted to EBCDIC prior to returning the HTML report to the browser. Added Apache config commands WRSAPACH1 to add directives to config and WRSAPACH2 to edit the Apache config IFS file.
1.16
2002-05-11
Added new PDF converter program to create PDF files that are updateable. Also added WRSPDFPGM data area to tell the email report server which PDF converter to use. If set to WRS008R, the regular PDF converter is used. If set to WRS018R, the new PDF converter will be used.
1.15
2002-05-11
Added page scaling info for call to PDF converter WRS008R to prevent MCH3601 error. Added &PAGESIZE PARM for program call to WRS004R in the WRS004 command to prevent a pointer error.
1.14
2001-12-27
Added page size for *LETTER or *A4 paper to the RTF Converter. Also added paragraph point spacing for 80, 132 or 198 column reports to RTF Converter.
1.13
2001-09-19
Removed no-cache header from WRS200R to avoid page expiration errors when the back button is selected in Internet Explorer.
1.12
2001-09-19
Fixed problem where IE 5.x is not returning html files correctly. It is instead opening a file open/save as dialog box. This is happening because we were returning HTML files with the disposition header. Changed WRS005 to support 100 char IFS file.
1.11
2001-08-07
Fixed CPYAFPPDF command to keep it from locking up when called from a java environment the RJSTIFF service program has been compiled for release V4R1 compatibility. We changed it to V4R2 compatibility and it now works. Java was added to the AS/400 in V4R2.
1.10
2001-07-23
Created WRS205L/WRS205C for data encryption. Also modified WRS302R to make sure that password field cannot be blank and cannot be changed. A new password must always be entered when updating a user into the system.
Lengthened passwords to 20 characters in the WRSUSERS table. Also allow lower case password.
Updated WRS200R to handle password checking. Also modified WRS302R to make sure that password field cannot be blank and cannot be changed. A new password must always be entered when updating a user into the system.
1.09
2001-06-27
Fixed WHERESQL15 to not use % in the like selection statement. This was causing users to have access to reports they should not see in situations where the criteria was short, but there where other longer, similar entries.
Example: field to check = userdata and where criteria=a5 if there was a report with user data a5060, the user could see it even though they should not. They should only have access to a5.
1.08
2001-06-14
Updated report index entry program to allow lower case data entry.
1.07
2001-05-29
Updated user access entry screen to display criteria info on subfile screen. Also added copy/paste feature as well.
Changed SQL buffer 3000 bytes to 28000 bytes. Users were getting errors if more than 18-19 user access entries were added for a user. This should raise the limit to several hundred entries per user.
1.06
2001-05-19
Added WRSPURGE command and WRSSQL commands to be used for purging reports from system.
Reports in IFS are automatically deleted when a record is manually deleted from WRSINDEX.
1.05
2001-05-19
Added LPAR access code checking option.
1.04
2001-04-15
Added ability to pass flag settings to the PCL to PDF converter. These are set via the new WRSPCLCMD command and they are stored in the wrspclcmd1, 2, 3, 4 data areas.
Updated PGM WRSMONC2 to support WRSPCLCMD data areas for PCL to PDF conversion.
1.03
2001-04-15
Soft coded content type passed to browser. We were passing application/octet instead of passing the file type, thus causing problems for Netscape users.
1.02
2001-04-09
Fixed WRSMON001 so that report desc's get set correctly. We now set desc from field WSR006 instead of WSR003.
1.01
2001-03-29
Added TIF output type to WRS301R.
