report totals for different groups

[stanja]

Hello,

i've got a table with 3 groups , store, division,subdiv.
I wont a report total for the stores , for each subdiv and each div. how can i do this.
I only manage to get a total of everything but not seperate totals for each group
I'm using Microsoft SQL Server Reporting Services Designers
Version 9.00.2047.00

any help would be great
tx

stanja

 

[xlbo]

You need to create GROUPS within your table for each level you want to sum at and then simply apply a subtotal to each group...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[stanja]

Geoff ,

i've got already subtotals for each group but what i want is a grand total of each group at the end of the report.
fe store1 tot
div1 tot
subdiv1 tot
store2
div1 tot
subdiv1 tot
subdiv2 tot
div2 tot
subdiv1 tot

grand total stores (this i have , it's a sum of every detail line value)
the lines beneath i want , how do i get this ?
grand total div1
grand total subdiv1
grand total subdiv2
grand total div2
....


tx
stanja

 

[haroldholt]

I had a similar issue, I resolved it by creating another table for the report footer using the same dataset I used for the report itself. In your case this would mean creating a second table with 2 groupings, first by division and then by sub division and creating the appropriate aggregates and placing it such that it appears at the bottom of the entire report.