Search code examples
reporting-servicesssrs-2008ssrs-2012ssrs-2008-r2

SSRS shared datasets missing

Source files for shared datasets are lost/missing. Any way to generate these from the SSRS report definition that is referencing them?

Thanks!

Solution

  • You can just download them from the server again.

    Go to you SSRS home page (Report Manager, or Web Portal as its known in later versions of SSRS).

    You might need to show hidden items, then open the datasets folder and you will see your shared datasets.

    Click the one you need and there are options to either download the *.rsd file or open it directly in Report Builder, either way you will have *.rsd file which you can either add back into your Visual Studio project or open in a text editor and get the command text.