reporting server connection string
Crystal Report ==> Use a single connection string for all crystal reports in project?
Hi I'm using crystal reports for a project. (.net project)
I have to make like 30 reports.
First I tried to use datasets that use the connection string in my web config, but i couldn't get it to work.
then i tried to use the database directly and it worked perfectly.
The problem is the database that i'm currently using, is in on my local machine. and after I'm done i have to publish the project on a server, and use a remote database.
And it's gonna take a long time to change the database info for every single report.
Is there a way to use a single connection string for all my reports?
Or even use the connection string in my web config?
Thank a lot in advance
If you just send the report a disconnected recordset, you'll be doing all the database work in the VB program. That way - as long as the databases are identical - you can just change the connection string in the one place in the program you define it.
(There's information on the Crystal web site about using disconnected recordsets.)
[phpzon]reporting server connection string, 5, Electronics[/phpzon]
[phpbay]reporting server connection string, 30, "11211"[/phpbay]
Perpetuum Software - How to connect Report Sharp Shooter with a MS SQL Server database