Wednesday, January 2, 2013

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P


Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. NQODBC SQL_STATE: HY000 nQSError: 10058 A general error has occurred. nQSError: 42038 A REPORT totalling function must be in a leaf query block. (HY000)
Cause: A Report totalling function, e.g., REPORT_SUM or REPORT_MAX, is included in a non-leaf query block. This is not allowed.
Remedy is: De-select the option Report-Based Total (when applicable) for all grand totals or subtotals you have applied.
This option is available after you click on sigma button.