Hi,
I've searched the forums of the internet but cannot get a definitive answer to my problem.
I've a Sales Margin Report drawn up that displays planned costs, actual costs, etc for a pre-determined period. I've also imported 2 sub reports with joined parameters on dates to show:
the invoice value for the period
the credit note value for the period
What I need to do is get these two values to a workable condition in the main report so that I can get:
Invoice value - Credit Note value = Nett value for the period.
I've used the following formula in the subreport:
WhilePrintingRecords;
Shared CurrencyVar InvoiceTotal:= Sum ({Command.DocTotal})
and the following formula in the Main Report:
WhilePrintingRecords;
Shared CurrencyVar InvoiceTotal;
InvoiceTotal
Both subreports are in the report footer as I don't want this repeated in each line of the "data dump" of the report. All I'm getting is a zero value for the shared formulae. I've not run this from within SAP B1 yet just through the preview of Crystal Reports. I'm using Crystal Reports 2008.
Any takers?