I am trying to perform a minimum summary on a 2nd pass formula and not entirely sure how to go about this.

Ive previously performed Grand Totals on 2nd pass formulas by using variables and running totals, so assume it will be a similar process.

My formula looks like:

if previous ({po_srvc_prdct.prdct_cd}) = {po_srvc_prdct.prdct_cd}
and previous({po_order_line.order_line_amnt}) = 0
and {po_order_line.order_line_amnt} > 0
then {po_order.dspch_dt}

I am trying to return the minimum date of when prices changed from £0 to > £0

Any help or alternatives would be appreciated!!

I am using Crystal Reports 8.5, Crystal Syntax

Edited by greengo - 07 Apr 2009 at 4:20am

I've grouped by customer, Sorted by product code ACS then date ACS

customer are given units (Multiple Specific Products, some product may be charged) to use free of charge once these units have run out they get charged base rates.

At current my formula above works on the detail line, but i am trying to avoid using the detail section and summarise on a group level. Some customers may have 1000's of orders, so this info is not needed.

If its possible could you point me in the right direction for use of stored procs, it may be of some use. Even if my SQL is limited