how to subtotal matrix row
can anyone help me about reporting services on how to sum the coloumn and put it on a textbox... but the case is like this,
Stud Name Fee Name Fee Amt. Amt Paid
John Doe Registration 1000 1000
Tuition Fee 5000 3500
1500
Jane Bake Tuition Fee 5000 5000
when i aggregate the Fee Amt. using Sum function i get the result of 16000 because john doe break his payment in to two. any help would be appreciated. tnx
|