Suppressing Subtotals (need help with formula) based on first record

[jcash35010]

I am trying to supress a subtotal on a subreport, and I can suppress it correctly using the formula below....however I have a problem with it when it doensn't have a next record to compare it to.

if ({sp_POEntry_PurchaseOrderDetails.Colorcd}) <> Next ({sp_POEntry_PurchaseOrderDetails.Colorcd}) then
False
else if onlastrecord then
false
else
true

Help! The onlastrecord is not working. Any suggestions?

 

[synapsevampire]

Try something like:

not(onlastrecord) and {sp_POEntry_PurchaseOrderDetails.Colorcd} = Next ({sp_POEntry_PurchaseOrderDetails.Colorcd})

-k

 

[jcash35010]

Thanks! That worked!