Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Reporting Services

Sharing datasources

I have 2 datasources in the home folder. But when I import a new report in a subfolder it doesn't find the datasource. How can I reference a datasource in other folder?
[170 byte] By [VectorR3] at [2007-12-16]
«« How to fix the Development server's port number across different PCs?
»» VS2k5/WinXpx64 - connection strings and other ADO problems
# 1
The data source in the report designer is always located in the same folder as the report (report designer does not support folders).

As such, when you publish just your report, the data source settings will reference a data source that is in the same folder as the report. Obviously this will fail as such a data source doesn't exist.

You'll need to go to the report manager or the sql management studio and set the report data source after you publish to the desired shared data source.

-Lukasz

LukaszPawlowski at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
SQL Server
SQL Server Reporting Services

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified