Hi All,
My doubt is, how to get gand total in SQL Reporting Services2005 for the following scenario
Sample report content:
CustomerId Product Name Price
123 Apple $100.00
Orange $77.00
SUB TOTAL $177.00
124 Apple $105.00
Orange $70.00
Olive $450.00
SUB TOTAL $625.00 // sum(Fields!Price)
GRAND TOTAL $802.00 //How to get Grand total please..
Regards,
Pragash
put the expression "=sum(Fields!Price)" in the report footer
Put it in the footer like in this way:Sum(Fields!Price,"Datset name").
Hope this helps.
Hi Jon,
I tried with the following data but I am getting different result.
CustomerId Product Name Price
123 Apple $100.00
Orange $77.00
SUB TOTAL $177.00
124 Apple $105.00
Orange $70.00
Olive $450.00
SUB TOTAL $625.00
125 Apple $100.00
Orange $10.00
Olive $10.00
SUB TOTAL $120.00 // sum(Fields!Price.value)
GRAND TOTAL $328.00 // sum(Fields!Price.value) ---but it has to be $922.00 right but what its giving is subtotal2-subtotal1-subtotal3=$328.00 Why
Hi Mahima,
Its giving #Errr output when I used sum(Fields!Price,"Dataset_Name"), any other way
Hi ,
I am getting it now by puting sum(Fields!Price.Value) in the Table footer not in the report footer(page footer).
Thanks