PragashVasa

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

### Re: How to arrive at Grand total?

Jon Royales

put the expression "=sum(Fields!Price)" in the report footer

### Re: How to arrive at Grand total?

mahima

Put it in the footer like in this way:Sum(Fields!Price,"Datset name").

Hope this helps.

### Re: How to arrive at Grand total?

PragashVasa

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

### Re: How to arrive at Grand total?

PragashVasa

Hi Mahima,

Its giving #Errr output when I used sum(Fields!Price,"Dataset_Name"), any other way

### Re: How to arrive at Grand total?

PragashVasa

Hi ,

I am getting it now by puting sum(Fields!Price.Value) in the Table footer not in the report footer(page footer).

Thanks