Hi,

I'm currently creating reports in Excel through VBA. The data resides in Oracle and I have no problems connecting and getting the data I need for creating the report in Excel.

I'd like to try and create one of these reports through VB using Crystal.

I want the user to be able select From and To Date, plus other criterias from my form. Then when the 'Run' botton is clicked the SQL is run on the Oracle database and the results passed back and shown in Crystal Reports.

Can anyone tell me where to start, and if the above is possible?

Regards