Use DataSet as datasource for Crystal Reports in C# 2005
Posted on 2007-11-18
I am getting close to the deployment stage with a C# project and have run into a few snags. My project has many Crystal reports which I connect to sql Sprocs using OLEDB for SQL SERVER. This works well once everything is connected but...
If I want to change the database location to a new server it can take a couple of hours re-connecting each crystal report in my project to the new server with OLEDB in Field explorer. It is a MAJOR headache with the reports with subreports and passed params. This NEVER seems to work well.
I know there must be an easier way to connect Crystal Reports to a datasource in order to achieve a more "seamless" transition to a new datasource (or the same stored procedure on a different server - my case).
I thought that creating a dataset in my project which harbors the correct stored procedure might be a solution. So I created a datset , added the appropriate stored procedure and connected the new dataset as the datasource for the crystal reports.
I am having trouble getting the dataset to work.
1. Crystal Reports does not recognize the SPROC's parameters and it gives erroneous values for some of the fields.
Does anyone know what may be going on here??