title: Add "Total" per row and column in Crystal Reports without CrossTab
body: <p>I have a simple question.</p>
  
  <p>Suppose I have a Stored Proceudre that returns a table with the following columns: (Item, GreenColour, RedColour), corresponding to all the possible Items and how many of them are "Green" or "Red". i.e, a possible output could be {(Apple, 4, 2), (Chair, 1, 2)}.</p>
  
  <p>What I want to do in the report is the following:</p>
  
  <p>In the header section, write four columns: "Item", "Green", "Red" and "Total"; where "Total" corresponds to the total per row. Then in the "Details" section adding the "GreenColour", "RedColour" and some other "TotalColours" field (Which I don't know well). And also adding an additional line at the bottom with the totals per column.</p>
  
  <p>This sounds very similar to the "CrossTab" tool, but it can't be done that way.
  I know a possible answer is modifying the StoredProcedure by adding the "Total" column and compute it in the query. And adding the "Total" per column with a UNION after the query, where "Item" is "Total" and values of "Green" and "Sum" are "SUM" of another query. But I don't want to do it this way, I want Crystal Reports to solve it.</p>
  
  <p>Thanks and I apologize of writing so much for asking such a simple question.</p>
  
  <p>Edit: The wanted output for my example would be:</p>
  
  <pre><code>Item      Green Colour    Red Colour    Total
  Apple          4              2           6
  Chair          1              2           3
  Total          5              4           ¿9?
  </code></pre>
  
  <p>Also would like to know if it's possible to make both ways with the '9' and without it.</p>