>>>hi Martina,
>>>
>>>It appears that the problem is with the records that have UNIT_PRICE of 0.00 (zero). These records appear at the top of the report. Then, after all zero-unit-price items are printed, the items of higher UNIT_PRICE start to appear. I will try your suggestion to see if this will fix it.
>>
>>To push zeros to the bottom, perhaps something like this:
>>
>>

>>FIELD1 + STR(100000000 - evl(UNIT_PRICE*100, 100000000),10) + FIELD2
>>

>
>First, thank you for your suggestion.
>
>What Martina suggested
>

>FIELD1 + STR(100000000 - UNIT_PRICE*100,10) + FIELD2
>

>also works for pushing zeros to the bottom. I wonder it is different from your suggestion of using EVL(). Is there a real difference!?

Yup, I think I had a brain fart. Mine would push the zeros on top :).