create a global data source

Hi guys,

I have a number of reports deployed on the report server. I want to point all these reports to another data source. Currently, what I am doing is go to the individual report on the report server and change the data source property to point to the new data source. It is very tedious to do the same thing for all of the reports.

So, Is there any way to point all the reports under a project at one time.

Any idea is appreciated.

Thx!

I would use global replace. That's the only way that I know of.

|||

would u explain that a lil bit

thx

|||

At the top menu, click Edit -> quick replace.

In the find box, enter the old dataset name.

In the replace box, enter the new dataset name.

You may want to do a find next and replace on a case by case basis instead of replace all, because I'm not exactly sure how your project is set up.

|||This is exactly how we have our reports configured.

1. In your business intelligence projects, create a new "shared" data source that points to the database your are pulling your data from. If you are using more than once database, create a single shared data source for each database. Each data source will have a name. For this example, lets assume you created a datasource called "DS_TEST" that points to a database called "MY_DATA"

2. When you build your reports, always use the shared datasources that you created from step 1.

3. When you deploy the reports, they will still be looking for the datasources by name. From step 1, the reports are all looking for a datasource called "DS_TEST". If you developed the reports on the same machine that hosts reporting services, everything should work (although my environment is not set up this way so I have not tested this). If you developed the reports on one machine and deployed to another, you must create the datasource on the deployment machine. To do this, navigate to the reporting services home page where the reports are deployed and click the "Add New Datasource" link (if you do not see this link, then you do not have the correct permissions). Point the datasource to the database you want the reports to pull from, but make sure and name it "DS_TEST" or whatever name you choose in step 1. The reports will now use the datasource called DS_TEST on the server the report is deployed on..

By having the global data source, it makes it easy during development to point the reports to test data so we do not effect the performance of the live system, and later when the reports are deployed to the live system they naturally point to the correct data.