Solved

Share Data Source between multiple projects

Posted on 2009-05-08
5
286 Views
Last Modified: 2012-05-06
Hi, is it possible to share a data source between multiple projects in the same solution? If so, how?

Thanks
0
Comment
Question by:mr_patel
  • 2
  • 2
5 Comments
 
LVL 9

Expert Comment

by:Hwkranger
ID: 24339109
No you cant.  But you can use your source control, write a script, or hand copy them to keep them in sync.
0
 
LVL 26

Accepted Solution

by:
Chris Luttrell earned 100 total points
ID: 24339975
As stated you can not share them, but you can import them from an existing item.  In Solution Explorer right click on the Project or Shared Data Sources > Add > Existing Item  and go find one or more data souces to include.  It will copy the rds file to this project.
SSRS-Add-Existing-DataSource.png
0
 

Author Comment

by:mr_patel
ID: 24339989
Hi CGLuttrell, I tried doing that, but it doesn't save the credentials. Is there anyway to save the credentials when I add an existing one?
Thanks.
0
 
LVL 26

Expert Comment

by:Chris Luttrell
ID: 24340984
I believe that is a security consideration that MS does not maintain supplied credentials with just the .rds file.  It seems that I read that in MS documentation some where but I can not find it now.  I see references to "Credentials stored securely in the report server" though.  If it did keep username/password someone could just copy your rds file and gain access to a database.
0
 

Author Closing Comment

by:mr_patel
ID: 31579587
I ended up "adding existing" data source for 10 projects!
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now