CISPro 2023 has a new, preferred method for how report parameters are passed to the database.  Previously, parameters were passed within a string, now they can alternatively be passed via an Oracle bind variable.  This functionality is controlled by the parameterized_reports configuration variable.  If parameterized_reports is enabled then how parameters are setup in reports must be changed.

The feature will apply automatically to all new customers and to upgrading customers where the "Is New" setting is enabled.  The "Is New" setting is set on the CISPro application server in the CSWConfigUX.exe tool under the Customers tab, it is however recommended to be disabled for customers running CISPro in production.  When "Is New" is enabled then during the CISPro upgrade all existing reports are scanned and automatically updated to convert the string based parameters to bind variable parameters.  For other customers who wish to apply this feature, the parameterized_reports configuration variable will need to be enabled and then all reports containing parameters will need to be manually updated.

In order to update an existing report, a parameter passed within a string will need to have the surrounding single quotes removed.  For example:

where c.barcode = '{Barcode}'

would be updated to:

where c.barcode = {Barcode}

Wild cards that are currently passed automatically would need to be concatenated to a string, for example:

where c.location like '{Full Path Begins}%'

would be updated to:

where c.location like {Full Path Begins}||'%'

This information is also published as Technote T72-2022