Skip to Content
0
Former Member
Dec 25, 2007 at 06:58 AM

Sorting problem

14 Views

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.