I need help understanding ‘Shared Data Source’
My thought was that I would create shared data sources in Report Manager, then my report developer would link to this source using BIDS and be provided the latest-n-greatest tables, views, stored procs, etc. for the reports. I have provided the credentials needed to run the reports via our office web portal in Report Manager.
However when I start a report in BIDS and I go to Shared Data Sources > Add > Existing item, there is no way for me to link to this existing data source. If I choose New > Data Source from the Report Data window, there is a radio button for ‘Use shared data source reference’ – but my only option is New, then the database information and credentials have to be added again.
I’m sure I’m missing the obvious … will someone please point me in the right direction?