NIPUNPETER Member since 2010 15 posts
Huntington Bancshares Inc
Posted: September 14, 2017
Last activity: February 14, 2018

Expression trend reporting causes SQL error after drilling down in summary view reports

After the report is initially run, the summary view's clipboard page's (pySumViewContentPage) SQL Query is correct without any issue.. However, upon drilling down, the SQL query of pySumViewContentPage, errors out with an invalid operator in the WHERE clause: ( ( TRND1ATRND1 ) OR ( TRND2ATRND2 ) )

The change that happens to pySumViewContentPage on the clipboard is, after the drill down, there are 2 additional index values in pyPreparedValues property of the pySumViewContentPage- .pySLADeadline (this property is defined in trend reporting expressions, twice). The 2 indexes did not appear during the initial run of the summary view report. Due to this error when the "Back" button is clicked on the drilled down report, the initial summary view report's (selection criteria) data is not retained.

Attached is the 2 trend expressions that are defined.

Using PRPC 6.3 SP1

***Edited by Moderator Marissa to update categories***

Moderation Team has archived post
Share this page LinkedIn