In the Report Designer, I would like to group my data and create sub-totals for them. How can I do this?
In the wizard to create the report, after right clicking on the data grid with your data and selecting Send To | Data Report Designer, there are two options you can select that should get you what you want. The first one is the group by option. If you select to group by the column you want grouped, it will display each type of value in that column in its own section. After selecting to group by, the next window asks if you want to have any values calculated. If you select to sum them, it will give you a subtotal for each value type.