today one question (http://forums.oracle.com/forums/thread.jspa?threadID=941347) in OTN, how to fix the following error.
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.