title: Using shared datasets across different projects
body: <p>facts: Visual Studio 2010, SQL Server 2008 R2, SQL Server 2008 R2 Reporting Services</p>
  
  <p>I have a solution that consists of several projects. This is because of the inability to create nested deploy folders.</p>
  
  <p>So my solution looks like this:</p>
  
  <ul>
  <li>Students -> reports deploy to Students</li>
  <li>StudentsGraduated -> reports    deploy to Students/Graduated </li>
  <li>StudentsGraduatedWithHonours _> reports    deploy to Students/Graduated/WithHonours</li>
  <li>StudentsBlueEyes -> reports    deploy to Students/BlueEyes   </li>
  <li>StudentsGreenEyes -> reports deploy to    Students/GreenEyes</li>
  </ul>
  
  <p>All reports should use one dataset, with proper filters.</p>
  
  <p>So I set up deployment so that each project deploys its datasets in /Student/DataSets. I made sure that each project has a identical dataset so that, when deployed, they all use the same dataset.</p>
  
  <p>But apparently this does not work. Only the last deployed report can use the dataset :(</p>
  
  <ul>
  <li>If I put all reports using a dataset in the same project it works but I have manually to move all reports to their proper locations. </li>
  <li>Setting up all projects to deploy their reports in their own DataSet folder works too, but then I have a lot of identical DataSets lying around, which kinda beats the purpose. </li>
  <li>After deployment manually resetting the dataset using the reportmanager works but is rather a tedious exercise when you have like 7 datasets on avg in each report and 19 reports......</li>
  </ul>
  
  <p>Is this  known phenomenon? Is it possible to have reports from different projects use the same dataset? If so, how?</p>
  
  <p>I really would like to know your thoughts on this......</p>