HI!!
I am using CR 8
How can I sort a report by a formulate column?

I have a report like this

group Header1 Sale %Sale Formulate example:
----------------------------
 LOPEZ 10 16.6% (10/60)*100
 ALTAVISTA 20 33.3%
 HENEQUEN 5 8.3%
 TORRES 25 41.6%
----------------------------
group Footer1 60


I want to show the information sort by %Sale column this column is a formulate: sale/sum(sale,group1)*100

group Header1 Sale %Sale Formulate example:
----------------------------
 TORRES 25 41.6%
 ALTAVISTA 20 33.3%
 LOPEZ 10 16.6% (10/60)*100
 HENEQUEN 5 8.3%
 ----------------------------
group Footer1 60

When I uses the Sort Order Icon I don't have the option of do that, how can I sort the report using this column?

if ur %Sale is a formula fld, hen u can sort ur report on formula. in the sorting expert, select this formula.if by chance if u can'r see this formula, try to create again and then sort.