Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
muzzettemm
Posting Yak Master
212 Posts |
 Posted - 2009-06-10 : 15:18:20
|
| I have a report that I need to create subtotals in. Each category needs a subtotal before the grand total for instance[services covered] [Hours Earned] Parenting 1 Parenting 3 Parenting 4 Subtotal 8 hoursCultural 1Cultural 1 subtotal 2 hoursGrand total 10 hoursHow do I do that in reporting services?? When I try to do it, it just gives me the grand total. |
|
|
Wozer
Starting Member
29 Posts |
Posted - 2009-06-11 : 11:28:58
|
| If you right click on the row with Services and Hours earned (the three Lines) there is an option to insert a group. Under expression choose the field you want to group on (=Fields!ServicesCovered.Value) and hit Ok.This will give you a field above and below your data fields that has a 1 next to it instead of the three lines, put a label in the one below your data (Services Subtotal for example) and then for the cell next to it do =SUM(Fields!Hours.Value) and it should so the subtotals. You will want to put the grand total in the footer of the table |
 |
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2009-06-11 : 13:33:34
|
| thank you so much for your help I think the problem was as soon as the extra lines came in after the grouping I would move what I was trying to group to that line and it wasnt turning out right. Thank yoiu very much |
|
|
|
|
|
|
Subtotals in Reporting Services