Get Total Fields

salemm
salemm Member Posts: 38
edited 2012-04-30 in NAV/Navision Classic Client
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

  • Chinmoy
    Chinmoy 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
  • salemm
    salemm 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,
  • Savatage
    Savatage Member Posts: 7,142
    See here:
    http://msdn.microsoft.com/en-us/library/dd301337.aspx
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org

Categories