title: crystal report group on multiple criteria
body: <p>This is a strange scenario that I'm having trouble working out: </p>
  
  <p>I have a report that needs to show the summary of donations that each board member gave/got in any fiscal year. They get credit for hard credit donations, soft credit donations, and solicited donations. Meaning their record ID number is in 3 columns throughout the spreadsheet.</p>
  
  <p>So, my data looks like this:</p>
  
  <p>Soft Credit ID/Hard Credit ID/Solicitor ID/Gift Amount</p>
  
  <p>1/-/-/$50</p>
  
  <p>-/1/-/$100</p>
  
  <p>-/-/1/$250</p>
  
  <p>I need to be able to group these records together because they each have the ID # "1" in the record (but in a different column each time). I need to group these records together, so that it shows the summary for each board member, with the details below: </p>
  
  <p>Board member ID 1: Total Giving $400</p>
  
  <p>Soft credit - $50 - 4/1/13</p>
  
  <p>Hard Credit - $100 - 3/29/13</p>
  
  <p>Solicitor Credit - $250 - 7/2/13
  (^These don't need to be summaries, this just needs to list all gifts and which kind of credit they give)</p>
  
  <p>I'm having trouble because I don't see a way to group based on the ID, in different fields. I tried grouping based on a formula for each board member (formula read {Hard Credit ID}="1" OR {Soft credit ID}="1" OR {solicitor credit}="1") but it didn't work and it creates a hierarchy that I'm not looking for. Apologies for the formatting - I can't find instructions on how to make that block above appear as a table.</p>