AnsweredAssumed Answered

Report won't run doe to 'Order by' clause!

Question asked by ca.portal.admin on May 6, 2010
Latest reply on May 7, 2010 by another_martink
Hi All,  We're using Clarity 12, and using 'Actuate' software to create our reports and then run them from Clarity front-end.  A couple of our reports come up with the error message 'RPT-002: Report not configured properly'at run-time, and looing at the log files on the unix box, shows that this was due to the error"Database Error
2: Error generated by the connected data source ...
933: ORA-00933: SQL command not properly ended"  Now, the report runs fine with Actuate, and the SQL runs fine within SQL*Plus.We noticed that when we take away the 'Order by' clause, the report runs fine on Clarity too.  This doesn't seem logical as the 'Order by' is a simple "Order by a.name", however, when puttingthis report on Clarity, something about it makes the whole SQL fail.  My question is - is there was way to seeing what  SQL is generated by Clarity at run-time?  Or, failing that, does anyone have any ideas please?  Many thanks in advance!  H      

Outcomes