Accessing Shared Data Source in VS.net

How can i get the shared data sources i created in the report manager to be available in VS.net to be able to assign to a report. I want to be able to create the shared data source first in Report manager and then be able to assign it a report in VS.Net

Thanks.

You need to find where it stores the .rds file. Then in Visual Studio, you could add the existing data source. I'm not sure where it stores the file though.

|||

Wouldnt it be stored on the Report Services server?

|||

Yes, but I mean where would the .rds file be stored in windows? Try creating a new data source from report manager then searching for the name of the data source in windows. Once you find where it typically stores the files, you can just go to that path and use the existing data source to add it to Visual Studio.

I would think anyway....

|||

If you created a shared datasource in the report manager, you can script it using RS Build (http://www.codeplex.com/RSBuild/) or RS Scriptor (http://www.sqldbatips.com/showarticle.asp?ID=62).

Alternatively, you can take the low-level approach and read the appropriate table in the ReportServer database <g>.

The point of these scripts is supposed to be to publish to a different server, etc, and as backup -- not specifically for creating a VS definition file, but it will give you what you need to create an .rds file, nonetheless, because that's just an XML file with the same contents as the properties that the scripting tools are extracting out.

Either way, you will almost definitely need to supply the credential information again.

>L<