We are using Crystal 2008 with Oracle database as the report source.
We are having problems with some report queries in that they don't return any data. We think that they are passing multi valued string data in incorrect format with respect quotes, etc. There are no errors. We need to see exact what queries are being submitted by Crystal to the database which can help us fix our apps passing in parameter values to reports.
Are there any log files or audit tables that capture SQL queries submitted by Crystal to Oracle? If so could you please tell us how and where we can get at them ?
These are production issues therefore we are looking for some quick answers.
We appreciate any help, thanks in advance.