Search code examples
crystal-reportsreport

Getting sum of multiple fields in crystal reports

how to calculate {SUM} of multiple columns into a one column in In my Crystal reports.

Total=(VAT+TAX)

Solution

  • ok this how in general it works:

    Place your data in detail section and take simmary in report footer, You can take that by right click ojn field and use insert summary option.

    Now create a formula @Total

    sum(Vat)+sum(tax)+sum(duty)  //you can select the summary fields from report fields

    Place the formula in report footer