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.
Ive been searching all day for something to help with this but cant find anything.
Any help VERY much appreciated!
Cheers,
Dan
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.
Ive been searching all day for something to help with this but cant find anything.
Any help VERY much appreciated!
Cheers,
Dan