sql server reporting services: I have created and deployed Shared Data Sources two different ways, through
Report Manager (New Data Source) and also using Visual Studio .Net (deployed
the data source). Now, I want to create a new project in Visual Studio and
want to access either of the Data Sources. I select New, Project , give it a
name and the Report Wizard pops up with the first screen to Select the Data
Source. I am unable to select Shared Data Source as it is not selectable.
How do I point to the Shared Data Sources I have created? Thanks in advance!

Dave,

When working with the VS.NET Designer the shared data source file has to
present in the business intelligence project. Once the report is deployed
the admnistrator can de-associate the data source to point to another data
source located in an arbitrary folder. When this happens, the report RDL
file is not changed. Rather, an association is made to the new data source
in the report catalog (DataSource table) . This allows the report author to
use a data source pointing to a development database server wthout
overriding the report administrator selection.
--
Hope this helps.

----------------------------------------------
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com


[quoted text, click to view]