Problem with SubTotal

[liorlankril]

I have a SQL report that contain matrix. One of it's Column Group contain SubTotal column but it's not work. If I get on the Dynamic Column Group results 2 columns that Data values are 5 and 3, I get in the SubTotal column only 5 and not 8 (=5+3)!!!! It's always show me the value of the first column on the group and not operate Subtotal of all of them.

What is the problem????

 

[Sheco]

Does it need a Sum() ?

 

[Catadmin]

Look at the value for the box in question. Does it have a dataset.Field value or an <Expression> value?

If Expression, let us know what it is so we can take a look at it. If value, that's the problem. You need an expression to calculate a total.

What version of RS are you using?



Catadmin - MCDBA, MCSA
"The only stupid question is the one that *wasn't* asked.