Post Author: sahinp
CA Forum: Crystal Reports
Hello all,
I have a problem about sorting. There is a report consisting of, "part number", "unit price", "purchase order creation date".
I have grouped according to part number, then got maximum of "purchase order creation date". I want to get the unit price of that specific date but I couldn't. When I move the "unit price" column next to purchase date summary, it brings the unit price of first date but not of max. of "purchase order creation date".
Is there any way to do that?
Thank you.
Please see below for the data.
************************************************************************************************************************
I want to bring 12,70 USD which is the unit price for the latest purchase order.
When I drag unit price in design section, here is the result. not 12,70 USD but unit price of first record in the group.