Getting data from Oracle DB into Crystal Report

[ianoctdec]

Can anyone help me to find out how can I get data from oracle db into crystal report passing a parameter from the crystal report to be used in the selection criteria.
For example: I want to build a summary data from table1 based on Date parameter, also building another summary data from table2 based on the same Date parameter, then I want to join the two summary data and return them to crystal reports.

What I did is I used two Crystal SQL Commands to generate the two desired summary data and joined them in crystal, but when I run the report it was unacceptably slow, so I want to build the two summary data and join them in oracle rather than in crystal.

Can anyone help me how can I do this in oracle?

I am using Crystal reports 10, and Oracle 8i

Dana;

 

[Turkbear]

Hi,
See my answer in your other post :
Build a view in Oracle to handle the Join, pass it the params..