Questions:
How can mathematical operations between two or more columns in a report be performed?
Solution:
Reports are generated from handling and including Text and Data Field objects into PageHeader, Detail, and/or PageFooter sections. The column printed in a report shows the results from filling the DataField property of a Data Field inserted in a Detail section. This property will establish what will be queried from the Database, and how this information will be presented in the report. Therefore, to perform mathematical operations between columns in your report, just write the desired formula in DataField property and the result will be displayed in the respective Data Field.
The example below shows you how to add two values between a report’s column: