>>>>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 :).
It happens to the best of us. So think of yourself as belonging to an exclusive club :)
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham