Topic: Show a total in a report
Hello everyone, I would like to know how to display a total (Edit1) in a report.
My Visual Database → General → Show a total in a report
Hello everyone, I would like to know how to display a total (Edit1) 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.
Thank you sparrow it works as I wanted. I was stuck for a while, I searched a lot before posting on the forum.
Thank you very much.
Sabine
My Visual Database → General → Show a total in a report
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi