Options

Get Total Fields

salemmsalemm Member Posts: 38
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,

Comments

  • Options
    ChinmoyChinmoy Member Posts: 359
    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
  • Options
    salemmsalemm Member Posts: 38
    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,
Sign In or Register to comment.