SQL Server Performance Forum – Threads Archive

Problem with SubTotal

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????

---

]]>