WinSpool/400 Web Report Server Revision History
From Support
1.0.22
2002-02-06
Added debugging code to Web Report Server to check for ODBC errors. ? Created LogRequestsToScreen INI setting to display errors in the web browser.
1.0.21
2001-11-16
Added ability to port report index database to SQL server and use ODBC to access the WSPINDEX table in the SQL server database. The following INI settings control the new ODBC capability: UseODBC (1=Enabled, 0=Disabled) ODBCUserID - Enter the appropriate SQL Server User IS (Default=sa) ODBCPassword - Enter the appropriate SQL Server User Password (Default=blank) ODBCConnectionString - Enter the appropriate SQL Server connection string. **Note**: You should use the Windows ODBC Administrator (ODBCAD32.EXE) to create a DSN called: WSPINDEX that points to the WSPINDEX database on the SQL server system.
1.0.20
2001-11-16
Added document type field to the report list screen. The IncludeDocType INI setting can be set to 0 to disable this setting if needed. This setting will be on by default.
Changed database recordsets to use dbForwardOnly setting. This should insure that tables are opened only for read-only access when querying for report lists.
Added DBReadOnly INI setting and defaulted = 1 (True). This flag tells the OpenDatabase command whether the database is read-only or not. This setting doesn't appear to be necessary because the OpenRecordSet method for opening a database appears to supercede this setting.
Implemented the ability to sort reports from the report list page. Up to ten different sort orders can be selected. The following INI settings control the new sort feature, which is enabled by default.
- EnableSort (1=Enabled, 0=Disabled)
- SortOption1 - SortOption10 - Description for the selected sort selection.
- SortOrderBy1 - SortOrderBy10 - fields to sort by.
- SortOrderByDft - Default sort order for Web Report Server. Always enabled.
Example sort setting in INI file:
SortOption1=Report Description/Date - Descending SortOrderBy1=Spool_TextDescription,Spool_Date DESC
This example sorts by text description and then by date in descending order.
Report Fields that can be sorted:
- Spool_TextDescription - Report Description
- Spool_File - Spool file name
- Spool_UserID - Spool File User ID
- Spool_UserData - Spool File User Data
- Spool_FormType - Spool File Form Type
- Spool_Job - Spool File Job Name
- Spool_Date - Spool File Date
- Spool_OutputQueue - Output Queue Name
1.0.19
2001-11-01
Added AltSearchPage flag INI setting to allow users to see an alternate search page based on the user logging in. The search page names will be formed as follows: Search: <USER>SEARCH.HTM (Ex: JIMSEARCH.HTM) ? The AltPageDir INI setting must be set with the directory name where the alternate pages will be stored on the web server PC.
1.0.18
2001-08-09
Use alternative computer ID checking logic for timelock. This should prevent potential timelock checking lockups of the EXE when running.
1.0.17
2001-08-09'
Soft-coded EXE name in URL's generated. This allows the EXE to be renamed or copied if a company wants to run multiple versions of the Web Report Server EXE on the same server. Each Web Report Server EXE would then have a unique name and INI file. **Note**: If the EXE is renamed, the WSPLOGIN.HTM and WSPISRV2.HTM files must also be changed to link to the appropriate EXE name.
1.0.16
2001-04-11
Soft-coded EXE name in URL's generated. This allows the EXE to be renamed or copied if a company wants to run multiple versions of the Web Report Server EXE on the same server. Each Web Report Server EXE would then have a unique name and INI file. **Note**: If the EXE is renamed, the WSPLOGIN.HTM and WSPISRV2.HTM files must also be changed to link to the appropriate EXE name.
1.0.15
2001-02-02'
Changed file download mechanism to download reports in blocks instead of loading the entire file into memory at the same time. This should be an extreme efficiency enhancement to the report downloading process when there are multiple users downloading at the same time. This also resolves potential problems if the download process dies when downloading large report files. To change the data block settings, set the following settings in the Web Report Server INI file: WSPISRV2.INI DataBlockSize=200000 (Default)
1.0.14
2001-01-21
Removed temporary code added in V1.0.13. We simply commented it out so we can use it later if necessary. ? Added soft coded settings for Web Report Server Screen Colors and for the title of the report list screen. Also added ability to place a log at the top of the report list screen as well. To change these settings, set the following settings in the Web Report Server INI file: WSPISRV2.INI ListTitleColor=#000080 (Default) ListDescTitleColor=#800000 (Default) ListHeaderBGColor=#800000 (Default) ListHeaderFGColor=#ffffff (Default) ListBGColor=#f7efde (Default) ListFGColor=#000000 (Default) ListLogoImage= (Default = No Image) Example: <img src="
" width="200" height="89"> ListTitle=AS/400 Report and Document Listing (Default)
1.0.13
2000-11-14
Temporarily removed timelock check and also always send out the unlicensed demo message. Remove after testing is complete.
1.0.12
2000-07-17
Added optional Job Number and Spool Number values to column display. This allows users to display spool file job number and spool number values when troubleshooting. To enable these settings, set the following settings in the Web Report Server INI file: WSPISRV2.INI IncludeJobNumber = 1 (Default=0) IncludeSpoolNumber = 1 (Default=0)
1.0.11
1999-12-30
Added "checkparms" action for checkin parameters passed. Especially the action code.
1.0.10
1999-11-10
Added LoginRedirectURL option for login. If a form field named: "loginredirect" is passed in, the user is redirected back to the passed URL if the user login fails.
HTML Example passing LoginRedirectURL:
<form NAME="MyForm" onSubmit="return(encrypt())" ACTION="/cgi-bin/wspisrv2.exe?action=login" ETHOD="post"> <input type="hidden" name="input1" value="guest"> <input type="hidden" name="input2" value="password"> <input type="hidden" name="inwebu" value="thrfg"> <input type="hidden" name="inwebp" value="cnffgbeq"> <input type="hidden" name="loginredirect" value="http://www.rjssoft.com"</form>
1.0.09
1999-11-05
Added login action code "checkdb" to for settings database. This was added mainly to allow users to check against the AS/400 NetServer to see if files exist. There is a bug in IIS if used with AS/400 NetServer to store the settings databases. The Web Report Server will report that the file is not found even though it's actually on the NetServer. This must be an IIS problem because the Apache Server works fine with files stored on the NetServer drives of the AS/400.
Added login action code "version" to check software version.
1.0.8
1999-10-26
Added NT REMOTE_USER authentication. This allows us to check the NT user against the Web Report Server user list. The login action code for this is: "initauth" ? Added login action code "checkuser" to check the user information being passed to the CGI variables for remote user authentication.
1.0.7
1999-09-30'
Added Hit Counter for login hit counts.
1.0.6
1999-09-17'
Added support for WSPISRV2.RJS license file. In some cases, customers were getting errors from machnm1.exe which is part of the protection plus mechanism. My speculation is that running many instances of the protection plus code at the same time is possibly what caused this problem.
1.0.5
1999-08-09
Added ability to selectively leave columns out of the report list. The following columns can be selectively eliminated: Report Date, Time, Pages, Spool File Name, User Data, Job, User ID, Form Type, Output Queue, Output Queue Library
1.0.4
1999-08-04
Added ability to selectively leave columns out of the report list. The following columns can be selectively eliminated: Report Date, Time, Pages, Spool File Name, User Data, Job, User ID, Form Type, Output Queue, Output Queue Library
1.0.3
1999-05-22
Added support for User Filters that we check to allow reports to be filtered based on a selected criteria such as: SPOOLFILE, FORMTYPE, USERDATA, JOBNAME, USERID
1.0.2
1999-04-30
Distinguish plain text/html reports from other content. Internet Explorer 5.0 was locking up when standard HTML reports were retuned in the browser with the application/HTML header instead of the text/html header. Who knows why ?? That's Microsoft.
1.0.1
1999-04-09
Distinguish plain text/html reports from other content. Internet Explorer 5.0 was locking up when standard HTML reports were retuned in the browser with the application/HTML header instead of the text/html header. Who knows why ?? That's Microsoft.
