Is there a way to set the data source in Report Manager for whole folder rather than each report?
I have few reports under different folders in Report Manager. Is there a way to set the data source for the whole folder rather than each report individually? There is also a folder where reports generate dynamically. Since the report project doesn't exist anymore, I can't set the data source through code. How can I set the data source for the whole folder? Please advi
August 28th, 2015 2:14am

Hi,

There is no way to assign the datasource at the folder level in SSRS.

Free Windows Admin Tool Kit Click here and download it now
August 28th, 2015 2:20am

Hi Mayooran99, 

According to your description, you want to set data source at folder level, right? 

In Reporting Services, if you want to design a report, you need to create a data source so that you can connect to the database. In you scenario, if you want to create a data source at the folder level, it cannot be achieved currently in Reporting Services. It is because data source is meaningful only for the report level. For your requirement, you can use a shared data source for each report. For more detail information, please refer to the link below: 

Create, Delete, or Modify a Shared Data Source (Report Manager)

If you have any other question, please feel free to ask. 

Regards,
Shrek Li

August 28th, 2015 3:10am

Currently I do have a shared data source. Is it possible to make it applicable to all reports in a folder by default? Without having to set the shared data source for each report individually?
Free Windows Admin Tool Kit Click here and download it now
August 28th, 2015 3:50am

I have a folder in which reports are getting created dynamically. Is there a way to set a default data source to all the reports that get created in that folder?
August 28th, 2015 7:07am

You could write some custom code in .NET, PowerShell, etc. to work against the ReportService2010 API.

https://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.aspx?f=255&MSPPError=-2147217396

More specifically, look at the SetItemDataSources method

https://msdn.microsoft.com/en-us/library/mt213551.aspx#M:ReportService2010.ReportingService2010.SetItemDataSources(System.String,ReportService2010.DataSource[])

Free Windows Admin Tool Kit Click here and download it now
August 28th, 2015 9:10am

This looks like you are asking for a new feature in Reporting Services. You could suggest this to the product team at: https://support.powerbi.com/forums/282523-bi-in-sql-vnext
August 28th, 2015 1:52pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics