Adding a Report Viewer filter takes excessive amounts of time in IBM Datacap Taskmaster Capture

Adding a Report Viewer filter takes excessive amounts of time

in IBM Datacap Taskmaster Capture

 Abstract

Adding a Report Viewer filter takes excessive amounts of time in IBM Datacap Taskmaster Capture

Cause

In applications with large engine databases, creating filters using Report Viewer may take an excessive amount of time as Report Viewer goes through a number of records in order to display filter options within certain drop-down lists. While this pre-population of filter options is occurring, the client may appear to be frozen.

Resolving the problem

Report Viewer is not included in IBM Datacap Taskmaster Capture 8.0.0 and later. This document is specifically for Report Viewer included in Taskmaster 7.6 and earlier, and does not apply to RV2.

Deletion or archiving any unnecessary stored batches may be sufficient to significantly lower the wait time depending upon the number of batches removed or archived. Otherwise, manually adding Report Viewer filters may be done to work around this issue as stated below. It is recommended that the original rptview database be backed up prior to any modifications in case changes need to be reverted, and it is also recommended that this work arounf be first tested in a development environment.

 

Manually adding filters to Report Viewer:

1. Open rptview.mdb, usually inside the application's process folder, with Microsoft Access

2. Insert a new record into the Filters table, use the following values:

Column	Value
FilterID	Automatically generated value
Report ID	Report to add filter, use value stored in Reports table's ID column for desired report
Filter	Filter name
SQL	Short SQL statement to be used by the filter

3. Save changes and test 

Note: For SQL column, reference preexisting filters for a template. If none of the templates apply, review the Report Viewer documentation and the database's Aliases table for some available filter options.