General information
Category:
Reports & Report designer
>>>I guess you have the wrong file or alias name when the report form executes. Because based on your latest data, the SUM is 1200.
>>>Try to check the alias at the deactivate method of the form.
>>>Another possible solution, just group the SELECT by name to get the 3 rows only, bec. as I understand, you're just trying to get the unique rows right?
The following data is the result of SQL from two tables (customer table and payment table) where each customer can have partial payments. e.g: John has a credit limit of 100 and he's paid three times (5, 10 and 30). I want the Grand Total to show only the actual total of credit limit of each customer (John=100, Marry=300, Tony = 300) which comes to 700. But the total on the summary band always shows 1200. How can I get the sum of 700 of 3 customers' credit limits ?
Name Limit Payment
John 100 5
John 100 10
John 100 30
Marry 300 20
Mary 300 50
Tony 300 80
Thanks a lot for your help,
Regards,
Andi Hidajat
Previous
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