Crystal Report 11 with Dynamic SQL using Javascript.

[Malekii]

Hi.

Well is seems the more I look at this the more confused I seem to get.

My company is looking to change it's product to use Oracle as it's back end (vs PostgreSQL) for a particular client. Since there are quite a few stored procedures (1000+) they're not keen on maintaining 2 sets of them so creating the SQL directly from the application seems to be the way to go. They're also looking to be able to port the app to other backends as well in the future.

My question is this: how can I pass a SQL statement directly to crystal report 11 so that it can run it? I know that I can use SQL expression fields but that appears to be only for one column.

Oh and here's the kicker...they're using Javascript to run the report.

Thanks in advance,

M
=

 

[Turkbear]

Hi,
A Crystal Report can be 'built' using just a Sql statement..Use the Command option after choosing the database instead of selecting a table, view or stored procedure...Alternatively, you can recreate the SPs in Oracle and have them return a REFCURSOR with the dataset and choose this SP as the report source.





To Paraphrase:"The Help you get is proportional to the Help you give.."