I'm currently in the process of creating an invoice document and seem to have hit a bit of a stumbling block.
My report (a sales invoice) is based on a view which is looking at data derived from 2 tables:
InvoiceHead - a single record per job listed on the invoice.
InvoiceLines - a record per line on the invoice (each job COULD have multiple lines)
The issue I've run into is that carriage is only recorded at the Head level... which means I can't simply sum it up.
To get around this in Crystal (which I've been using for pushing 20 years now), I'd either:
create a running total which would add the carriage value in when the InvoiceHeadID changes
create a numberVar and manually add the value when required.
... but I can't see any way to do either of these in the designer and Google doesn't seem to have any apparent examples.
Any help will be gratefully appreciated.
Cheers in advance,