Crystal Report: Oracle stored Proc

[DannyT]

I am trying to populate a crystal report (vs.net 2003) with a dataset that i am dynamically creating and populating with the results from an oracle stored procedure.

 

So far i can create the Crystal report but only by using the Report Expert, this only lets me select tables and fields with which to populate the report and not a stored procedure (which i believe is the case with a mssql db). So the report always shows all records for the linked tables' fields that i wish to present.

 

In my app I create and populate a database from a complex stored proc that is based on many parameters. I would ideally like to use the data in this dataset to populate my report.

 

I've been searching all day for something to help with this but can't find anything.

 

Any help VERY much appreciated!

 

Cheers,

 

Dan

[DannyT]

Had to fudge it by creating a dataset at design time that was the same scheme as the results returned from my query.

 

If anyone knows of a better way then please let me know.