Re: Default data source for reports folder in SQL Server 2005

Question

Re: Default data source for reports folder in SQL Server 2005

jlp3630

Hall of Fame

Points: 3243
More actions
January 3, 2009 at 8:31 pm

#204702

Is there a way to assign a "default data source" for all reports uploaded to a given folder? I have over 40 folders in my Reporting Services directory structure with 5 unique data sources. Even though most folders utilize the same data source, I'm creating a new data source copy for each folder. Ideally, I would like to have a centrally located folder containing all the data sources. By default, each "folder" would use the preassigned data source.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Niraj-627298 Hall of Fame Points: 3641 More actions · Answer 1

Hi...:)..

I guess..while deployment of data sources and reports itself...you can deploy the respective data sources in an individual folder..the reports must access their concerned data sources....

Please let me knw...if this is the solution..u looking for...:)

Thanks alot,

Niraj

jlp3630 Hall of Fame Points: 3243 More actions · Answer 2

Niraj (1/4/2009)
Hi...:)..
I guess..while deployment of data sources and reports itself...you can deploy the respective data sources in an individual folder..the reports must access their concerned data sources....
Please let me knw...if this is the solution..u looking for...:)
Thanks alot,
Niraj

How would you get the reports to automatically associate themselves with a data source?

For example, if I want to upload 10 new reports to folder A via the web-based SQL Server Reporting Services, how do I automatically associate it with folder B's "X" datasource? Do I have to go to each newly uploaded report and manually select the correct data source? Or is there an "automated" way of accomplishing this?

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

Actually you can create a shared datasource if you use Enterprise Library which must install in your C drive but if you use a shared datasource you need to just copy the RDL and associated solution files for each report and can deploy to anywhere in the world remotely, assuming a copy of your database is running with your stored procedures or sql statements.

One more thing if you are not using shared datasource you may have to take care of all your datasources individually which may not be easy.

http://msdn.microsoft.com/en-us/library/cc512464.aspx

Kind regards,
Gift Peddie

RMehta-704576 SSC Enthusiast Points: 112 More actions · Answer 4

Assuming that you are using Report Designer. In the project you can create shared data sources. These data sources could be used for multiple reports in your project. Also at the project properties level you can choose to deploy the data source to a specific folder. This is the ideal way of deploying. If you have data sources in your 40+ folders it will be nightmare for you to maintain them.