title: Group By Report With Column From Different Dataset in SSRS
body: <p>I have 2 Datasets. Dataset 1- SQL Server which has columns such as Incidentid,assignedto,ApplicationName. Now I have another Dataset2 which is a sharepoint list which categorizes these applicationnames into pillars. I was able to use lookup and display the pillarname against the application name but now I want to be able to Group by Pillar and show a report containing all incidents in that parituclar pillar. A pillar is nothing but a group of similar applications and we have multiple pillars.The report should look something like: </p>
  
  <p>Pillar A   IncidentId ApplicationName Assignedperson
             IncidentId ApplicationName Assignedperson</p>
  
  <p>Pillar B   IncidentId ApplicationName Assignedperon
             IncidentId ApplicationName Assignedperon
             IncidentId ApplicationName Assignedperon</p>
  
  <p>Is it possible in SSRS 2008 R2? What are my options? Obviously I tried doing it and it gives error.Re Fields withing the current dataset scope. </p>
  
  <p>I also tried using lookup in the group but no help.</p>