General information
Category:
Reports & Report designer
Title:
Sum amounts in previous footer, not detail
I have a result set that was created from joining two tables. The result set was created in some third party software so I can not change the Query.
I am using the first footer band as the detail band (cust#+order# below). Now i want my second footer to sum the amounts that are in the first foot, not to sum the detail record amounts.
thanks
brenda
cust# order# order_tot item#
12345 4444 100.00 331
12345 4444 100.00 332
12345 4455 40.00 787
12345 4455 40.00 787
32434 4322 20.00 656
I want the report to be
12345 4444 100.00 2
12345 4455 40.00 2
------- ----
140.00
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