Get Total Fields

salemm

Hi All

I have one report and i added in the report under Body Section a column Quantity*Cost how i can get the sum (Total) of this field in Footer Section

Regards,

Chinmoy

Hi,

Declare a decimal variable in the report, sum it in the OnAfterGetRecord of the dataitem from where you are reading the Quantity and Cost fields and then print the variable in the footer section.

Did I understand your question?

Chn

salemm

Chinmoy wrote:

Hi,

Declare a decimal variable in the report, sum it in the OnAfterGetRecord of the dataitem from where you are reading the Quantity and Cost fields and then print the variable in the footer section.

Did I understand your question?

Chn

Thanks a lot for replying

I added a text box in report in body section then i go to text box properties in SourceExpr i added qty*cost now how i can get total of this field in footer.

I can get total qty and cost separate in footer but what i need the total of qty*cost

Regards,

Savatage

See here:
http://msdn.microsoft.com/en-us/library/dd301337.aspx