View Full Version : Sum in reports


kicken18
05-05-2005, 08:15 AM
I have a report that is an invoice for a customers order. It displays the orders that the customer has placed and the cost of each order. At the bottom in the Page Footer i have put a text field with =sum([Cost] but all i get is #error and I have tried changing it to Running sum over group and all but i still get the #error. <a href="http://chris.sbd-clan.net/InvoiceDesign.JPG">Here</a> is a screen shot of the design and <a href="http://chris.sbd-clan.net/InvoiceOutput.JPG">here</a> is one for the output

Thanks
Chris

KeithIT
05-05-2005, 09:31 AM
Have you tried placing the code in the report footer? Or is this something that needs to exist on each page?

kicken18
05-05-2005, 10:51 AM
haha no idear why I didnt try that, thats been bugging me for ages now

Thanks alot
Chris