Avatar of deanlee17
deanlee17
 asked on

Linking to Report Server Shared Data Source

Hi guys,

As the title suggests, I have created a shared data source on the report server . Is it possible to link to this data source on a report I have created on my local machine? If so how is this done? Or does the report need to be published and exist on the report server to use the data source?

Many Thanks,
Dean
SSRSDB Reporting Tools

Avatar of undefined
Last Comment
ValentinoV

8/22/2022 - Mon
deanlee17

ASKER
It's just occurred to me, do most people create the shared data source locally and then just publish that to the report server?
ValentinoV

If I recall well you're using BIDS (Visual Studio) for your report development.  In that case it's recommended to create a shared data source in your project.  Once you've got that created you can select the Use shared data source reference radio button on the Data Source properties (this is the data source in your report).  This allows you to select the shared data source from a dropdown list.
deanlee17

ASKER
Hi Valentino,

Yes that's correct I am using Visual Studio. My problem being that I need this Data Source shared amongst various projects so as per one of your previous comments on another post i have setup a shared data source on the report server. I am now creating my first project on my local machine and wish to access the shared data source on the report server?

Thanks,
Dean.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER CERTIFIED SOLUTION
ValentinoV

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question