locked
SSDT and ssrs using shared datasets and datasources RRS feed

  • Question

  • User683176063 posted

    I want to be able to create data sets on my works station using SSDT 2015 and have other report writers access and use the data sources that i have published to the SSRS server. However it looks like there is no way in SSDT 2015 to access these resources on the SSRS ? Is that true how do the other report writers access them in SSDT

    I try to go to the ssrs server http://sql2016demo.company.com/reportserver to access the shared data datasources and datasets

    I get this error

    Cannot open this location

    Tuesday, September 6, 2016 3:12 AM

Answers

  • User-2057865890 posted

    Hi Merrittr,

    I want to be able to create data sets on my works station using SSDT 2015 and have other report writers access and use the data sources that i have published to the SSRS server. However it looks like there is no way in SSDT 2015 to access these resources on the SSRS ? Is that true how do the other report writers access them in SSDT

    You can create an embedded dataset for use in a single report or a shared dataset to save to a report server, for use by multiple reports.

    #Create a Shared Dataset or Embedded Dataset (Report Builder and SSRS)

    https://msdn.microsoft.com/en-us/library/dd239345.aspx

    #Creating a Shared Dataset

    https://blogs.technet.microsoft.com/microsoft_in_education/2013/02/26/ssrs-101-creating-a-shared-dataset/

    I try to go to the ssrs server http://sql2016demo.company.com/reportserver to access the shared data datasources and datasets

    I get this error

    Cannot open this location

    If you try to access Report Manager on a remote computer and you receive connection error messages in your browser, a common cause is Firewall settings. For more information, see Configure a Firewall for Report Server Access.

    Best Regards,

    Chris

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, September 6, 2016 2:01 PM