How to generate a report from query results with subtotals of groups of columns? (4222502)

How to generate a report from query results? User would like to see subtotals of groups of columns and summary subtotals.

1. Run a query via Editor using Execute as Statement option
2. Right-click on Data Grid and select Report
3. Go through the report and add desired columns and groups
4. Add subtotals by selecting System Text icon from left side icons and dragging/dropping the Summary field inside Group Footer or Summary Report section
5. In the System Memo popup window, select Aggregate value. Select SUM for Function and enter Data Band, DataSet and DataField values.
6. Hit OK to add the subtotal field to report