Wednesday, March 28, 2012

How to arrive at Grand total?

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

No comments:

Post a Comment