Changing Data Source Properties

[tshad]

I am trying to make changes to the Data Source in my report and it works fine but I can't seem to save it.

In the Report Data tab, you set up your Data Source and set the Connection String which would point to one server or another as well as permissions.

What I was doing was making a copy of the report that would be 90% the same on another server for another database.

I can make the changes manually and it works fine while working with it. The changes stay there until you close VS. Sometimes it will ask if you want to change the .sln file for the project. But it doesn't keep these changes.

Even when you say "Save All" or when you close the VS and it asks if you want to save all - it doesn't save it.

Why is that? It is a real problem since I first build and run this on my development server and then want to move it to a production server - it won't work. It ends up pointing at the originally database (the development machine).

Thanks,

Tom

 

[xlbo]

Standard working practice for this is to have DEV/STG/PROD report servers with the servers / databases set up appropriately for each. The data sources don;t tend to deploy with the report except for the 1st time it is deployed so after setting it up initially, the report simply picks up the appropriate setting from the configuration on the reportserver

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question