Groups | Blog | Home
all groups > sql server reporting services > october 2004 >

sql server reporting services : subtotalling question


Kelly
10/15/2004 2:13:25 PM
Hi -

I'm drawing a blank right now on how to insert subtotals into my table on a
report. I know there's an Insert --> Subtotals *somewhere* but I'm not
finding it. I've right-clicked on my cells, rows, and columns and I'm not
seeing it.

My table is set up like (toggles shown)...

+ cust prod jan$ feb$ mar$ ...

- cust
prod jan$ feb$ mar$ ....
prod jan$ feb$ mar$ ...
prod jan$ feb$ mar$ ...

+ cust prod jan$ feb$ mar$ ...


I'd like a Total on my "cust" lines (which would show total $ for each cust)
and then a subtotal on my "prod" lines (to show total $ for each product, by
cust).

Hope that made sense. :) TIA!!

-Kelly

Kelly
10/15/2004 2:19:20 PM
Whoops. There isn't a prod showing on my collapsed rows. Once it is
expanded, the prod shows with the $$/mo.

-Kelly

[quoted text, click to view]

AddThis Social Bookmark Button