title: Combining data from Project Server and SharePoint into a single report
body: <p>I need to combine data from the <strong>Project Server reporting database</strong> with data from <strong>custom lists in SharePoint workspaces</strong>. The results need to be displayed within a single report. How should this be done? Options I've thought of:</p>
  
  <ol>
  <li><p>Extend the reporting database with the custom list data (if this is possible). Use Reporting Services to display the output.</p></li>
  <li><p>Query the reporting database and the SharePoint workspaces and combine results in memory. Write custom code to display the output.</p></li>
  </ol>
  
  <p>Any other ideas? I have the skills to develop this but am very open to purchasing a product if it solves the problem.</p>