>>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!?
"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
