Report Data Source

[djnickwatt]

Just a very quick query. I have a report which has a number of DataSets (for creating options for drop downs etc). In Visual Studio 2005 if I want to change the Data Source of the datasets I need to go to each one individually and select the one to use. However, if the report is uploaded to the report server and I use the web page to change the data source I only get the option for one data source. Does that mean it changes the datasource of ALL the underlying data sets?

 

[dfbonilla]

Changing the data source in the BIDS will change it for all if the Data Source: is the same. To make it independant just call your data source different DATA tab , Dataset dialog Data Source option, even that it points to the same Server, catalog, etc.