title: Listing all Data Sources and their Dependencies (reports, items, etc) in SQL Server 2008 R2
body: <p>I am new to SQL Server, and I am sorry if there is an obvious solution to my question but I can't seem to find it.</p>
  
  <p>I am looking to generate a report (or list) of all the data sources and their individual dependencies on an SQL Server 2008 R2 (reporting server).</p>
  
  <p>I know that I can access each individual data source to get a list of all the items that are dependent on it. I have done this in the past but it is time consuming.</p>
  
  <p>Is there a way to get a report that would display all the data sources and their dependent items?</p>
  
  <p>Thanks in advance,</p>
  
  <p>Marwan</p>