Show a total in a report

Hi,

There are two options for displaying the balance amount or Edit1.
1. In the Edit1 properties, clear the TableName and FieldName fields. Go to the properties of Button5 (Report). Add Edit1 to the list of components participating in the search. You should have TableGrid1 and Edit1 in the list. Let's launch the program. Let's go to the report designer. In the right window, behind the “Data” tab, click on the “Variables” tab. In the list we see the Edit1 component. Drag it to the desired place in the report.
This is all.
2. We calculate the balance amount directly in the report.
Add Band ColumnFooter. Add a Memo to it with the formula

[SUM(<Report."tenucompte.entree">,DetailData1)-SUM(<Report."tenucompte.Depense">,DetailData1)] 

This is all.

But be careful. You may get different results with the first method if you select one row and run the report. You will see your row highlighted and the balance amount will reflect the amount for all records in the table.