I challenge any EEE to please provide me with a tried and proven simple Oracle select statement in a SQL Expression Editor that returns a sum() via a direct Crystal Reports Oracle Server database connection.
e.g. select sum(amount_balance) from accounting_finrep
I am using Crystal Reports 8.5 Developers edition on Oracle 220.127.116.11.0
I have read all recommendations in the entire universe regarding this problem and none of them work.
I continually receive ORA-????? errors without end. Please help.