Problem With Simple Grouping Subtotal

In SRS2000, I have a simple grouping matrix report setup like the following:




Code Snippet
=Fields!Date.Value Total
=Fields!Section.Value =Fields!Count.Value
Total

It's essentially a table of departmental statistics that would report like this:




Code Snippet
5/1/08 5/2/08 5/3/08 5/4/08 Total
Dept1 0 99 33 4 XX
Dept2 1 0 2 1 XX
Total XX XX XX XX XX






The report has 2 groups - 1 for the dates and 1 for the departments.

The report data itself displays correctly. My problem comes in when I try to add the Subtotals.

I simply right-click on each of the two Groups and chose "Subtotal". This action inserts the Total column & row respectively and you would think everything is just fine.

Unfortunately when I actually run the report, I see that the Totals it's coming up with are incorrect. In fact, they are the totals of the FIRST row/column only.

Meaning - (using the previous example) - I'd see this:



Code Snippet
5/1/08 5/2/08 5/3/08 5/4/08 Total
Dept1 0 99 33 4 0
Dept2 1 0 2 1 1
Total 0 99 33 4 0


It's like it's not taking anything into account except the first instance.

And it's not like you can actually *see* the expression or formula being used for the Total function. The data cells are just grayed.. all you can really change is the "Total" text.

I must be doing something really stupid here, but for the life of me I don't see what it is.

Any ideas?

Thanks!