General information
Category:
Reports & Report designer
Title:
Can not get the correct Grand Total
I have the following SQL-result :
Name Limit Payment
John 100 5
John 100 10
John 100 30
Marry 300 20
Mary 300 50
Tony 300 80
I want the Report Design to print / preview as follows:
Name Limit Payment
John 100 5
10
30
--------------------------------------------------
100 45
Marry 300 20
50
---------------------------------------------------
300 70
Tony 300 80
---------------------------------------------------
300 80
---------------------------------------------------
TOTAL 700 195
How can I do that using Report Designer ? I have tried using variables but still can't get the correct TOTAL (700).
I asked my friend (a Delphi developer) to do this using Delphi report designer just to get an idea. I saw that he used variables in the report designer then I tried using variables in VFP report designer but I failed. What have I done wrong ?
Your help is highly appreciated.
Regards,
Andi Hidajat
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only