title: Is it possible to produce a report matrix as a result set in sql query given a singe database table
body: <p>Given the following SQL table:</p>
  
  <pre><code>GroupAvailable, GroupAssigned, Title
  ----------------------------------------
  GroupA,GroupA,Widget1
  GroupA,GroupB,Widget1
  GroupB,GroupA,Widget1
  </code></pre>
  
  <p>Need a report to look like:</p>
  
  <pre><code>Widget1
                 GroupA     GroupB
  
  GroupA           X          X
  GroupB           X
  
  
  Widget2
  etc.
  </code></pre>
  
  <p>Is this possible to do in query? Or something pretty close? Or would a combination of code and sql be better?</p>