Evaluation on records outside a parameter.

[crywrite]

Is there a way to evaluate records that do not fit in a parameter?
I have several shipments for one order. I only want to show the very first shipment for each order. Say the first shipment goes out 12/12 and the second goes out 12/13. If I run my report(by using a parameter by shipdate) for shipments only on 12/13, since the 12/13 shipment is not the first shipment for the order I don't want to show it, but Crystal can't see that 12/12 shipment is the first(because it doesn't fall within the parameter).

Is there a way to get around it? I was thinking a subreport but my parameter field is ship date and that's the same field I'm using to evaluate 1st and 2nd shipments.

 

[synapsevampire]

Post the version of Crystal and the database you're using.

Some theory that might help you is to consider using a min(ship_Date) for each order and compare to that.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[crywrite]

Crystal Version 8.5 and Centura SQLBase db.

I can pull all the minimum shipdates on the order but I need to view all the records in the db to determine the min.

Using a parameter is what is tripping me up. Is there a way to just "show" records within a date range rather than "selecting"?