title: Transposing Row Data as Columns in Crystal Reports
body: <p>I have the following data returned from a stored procedure</p>
  
  <pre><code>Staff  Category   Amount
  -----  -------    ------
  Bob    Art        123
  Bob    Sport      777
  Bob    Music      342 
  Jeff   Art        0
  Jeff   Sport      11
  Jeff   Music      27
  </code></pre>
  
  <p>All Categories will always be returned for all Staff even is the Amount is zero</p>
  
  <p>What I want to do on my Crystal Report is output this:-</p>
  
  <pre><code>Staff   Art     Sport   Music   
  -----   ---     -----   -----   
  Bob     123     777     342
  Jeff    0       11      27
  </code></pre>
  
  <p>I effectively want to Transpose the data in the Category rows as headers or columns in my report.</p>
  
  <p>I do not want to use a Cross Tab as I have other things I need to add which will not fit nicely into a Cross Tab</p>
  
  <p>Any thoughts on how I can do this in Crystal?  I'm using version 11</p>