Data Source question

How would be the best way to do this? We are creating reports (the development teams) that run against a Development SQL server (2005). We then send the rdl files to our QA team who then upload the files to their ReportServer (which we do not have access to and this is why we are not deploying the reports). They created their datasource on their ReportServer (using the report manager), but when they go into our reports and try to point to their datasource, they are getting errors.

This is the rdl:

<DataSources>

<DataSource Name="QADataSource">

<DataSourceReference>QADataSource</DataSourceReference>

<rd: DataSourceID>6a2ce78a-db44-4f00-8ec9-6658459ea989</rd: DataSourceID>

</DataSource>

</DataSources>

When I went in and deleted the <rd: DataSourceID> reference, this seemed to work.

Any suggestions?

That is because the dataset is referenced within the current project. If you open the WebBrowser and change the data source pointer to the data source on the report server, it should be fine. The changes to the reference is automatically changed during the VS deployment process.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

So what I should be able to do is to supply a user with an rdl file and then they will set up their datasource on their report manager, upload the rdl file and then they should be able to set their own datasource that they created?

This is the functionality that we want.

|||Let them upload the rdl file you provide from Visual Studio and change them the data source to the actual olne on the server.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

What we do is to create a set number of datasources on the report server that point to the various DB's we use.

E.g

Datasource 1

Datasource 2

Datasource 3

When creating a report, we set up a shared datasource with the same name as the datasource on the report server. This means when we upload the report, it will use the selected datasource and use the connection details that are stored within it. it doesnt matter what connection details we set in the shared data source within visual studio, it will use the details on the report server.