SQL Directives in Crystal Reports?

[Guest_imported]

I use Oracle as database for my reports. Because Oracle uses its internal optimizer for optimizing the used indices (or the order of the accessed tables) some reports are very slow. So I want to use SQL directives like
SELECT /*+ ordered*/
column1, column2, column3
FROM table1, table2,
WHERE .....

My problem is, that I cannot set the SQL directive for my report. If I set it in "Database>Show SQL Query" the changes take no effect. I also tried the API, but it was the same.
So my question: Is it possible, and how, to set an SQL directive for a report (for an SQL database like Oracle).

Regards,
a_name

 

[Naith]

You can't set hints and have them be passed down from Crystal.

The solution is to dump the sql into a stored procedure, where you can recreate the query and also utilise the hint for the report.

Naith

 

[Guest_imported]

Thanks for your tip, but I found out, that it is possible with Crystal Reports 9.0.

Thank you for your response.

 

[Naith]

9 is a huge leap forward as far as SQL is concerned. v9 supports any SQL statement that you may use to query the database directly. I wasn't sure which version you were using.

Naith

 

[Guest_imported]

Thanks for your help. I am currently using CR 8.5, but I hope that CR 9.0 supports SQL directives. I've already ordered it.

Thanks for your fast response.