Skip to Content
0
Former Member
Feb 15, 2013 at 04:02 PM

Importing subreport formula to a main report...again

149 Views

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?