Crystal Reports Set Location stuff and it pisses me off...

[scavenger]

Yellow,

I am using Crystal Reports for Visual Studio .NET

I have this Report where the connection to the database uses a Data link file.

When I change the Data link file's server name.... will the report changes it's location automatically? because in my experience it doesn't conform to the data link file... and bad news is I have to change each and every report the location. I really really wanna know how to automatically set it's location whenever I have mad changes to the .udl file that the report references to... please help!


Thanks guys...

[billcoupe]

I ran into this same sort of problem when I started developing reports for clients and their data environment (obviously) did not match mine.

I created empty, strongly typed datasets in the project and associated the report(s) with the correct dataset at design time.

Then, at runtime I create/open the required SQLConnection(s) and DataAdapters, fill the dataset, instantiate the report point the DataSource to the current dataset and run the report.

That allowed me to set up various 'data locations' and identify which one to use at application startup.

I hope this helps.

-Bill
Web Site (http://www.expert-code.com)