Retrieve previous summary value 1

[TonyFoo]

Hi All,

I am using Crystal Reports 11 and need to retrieve a previous group summary.

I have the first group "Parts" and a second group "Invoices". I need to present the Amounts for the current invoice and the previous invoice so they can be compared:
Previous Amount Current Amount
Part 1
Invoice 1 50000
Invoice 2 90000

What I need is tos how it like this:

Previous Amount Current Amount
Part 1
Invoice 2 50000 90000


If i can provide any addiotnal information please let me know.

Thanks,
Kyle

 

[IanWaterman]

Group report by Part and sort report by invoice ascending.

Place Invoice and amount field in Part group footer and suppress details.


create formual
@previous

previous(amountfield)

Place this in group footer

Ian