Report sum()

[TamedTech]

Hi there guys,

I'm hoping you can help, i'm using a MIS based on SAGE, and i'm new to creating reports.

I've got a report that generates a list of items for an invoice, and it lists the total cost for each item.

I'm looking to create a field that will generate a total for the entire invoice, so it'll add up the price for all the indevidual items listed.

Any ideas on how this is done? i'd imagine i'll be using the sum() script, but this is as far as my knowledge extends.

Thanks chaps,

Rob

 

[dgillz]

What type of report is this? Crystal Report? You give very little to go on.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[TamedTech]

Morning dgrillz,

Thanks for the speedy reply, sorry if i was a little vauge, i'm a web developer trying to implement this MIS for a customer and the tech support from the software developer is terrible.

All i can tell you is that it looks the same as a report that would be generated by SageLine 50, so on the left i have a list of fields from the database that i can drag into the design page which is in the center of the screen, on the right hand side i then have the "property" tool box where i can change the properties of the fields and things.

Any help you can give would be appreciated.

Thanks,

Rob

 

[BigLouie]

Sage Line 50 is ENTIRELY different from MAS90/200. The only thing similar is that they are both owned by the same company. Not sure if anyone here can assist.

 

[TamedTech]

ah ok BigLouie .. thanks for the advice.

I just saw the (sage) in the forum title and hoped they might be similar.

Not too worry.

Rob

 

[diogenes10]

Maybe this forum would be of help.

http://sageforum.co.uk/index.php?sid=ac3980cf1d19e337e5c0ee73c725059e