keywords:rprt_send(),Order By

when i add "order by whinr140.clot,whinr140.loca" into the session program scripts,but no order by in the report!
why? anybody can help me,thanks in advance!! :confused:

select whinr140.*
from whinr140
where whinr140.item =:faflx805.item
order by whinr140.clot,whinr140.loca
selectempty
whinr140cwar = ""
whinr140loca = ""
whinr140clot = "" |Troy 2005-10-20
whinr140stks = 0
whinr140stka = 0
whinr140stko = 0
selectdo
whinr140cwar = concat$(whinr140.cwar)
whinr140loca = whinr140.loca
whinr140clot = whinr140.clot |Troy 2005-10-20
whinr140stks = whinr140.stks
whinr140stka = whinr140.stka
whinr140stko = whinr140.stko
rprt_send() |Troy 2005-10-27
endselect

Hi

Check the Sort Mode in Input Fields in Maintain Report for the field which you have set order by in your program script.

Thanks & Regards

hi v_chandra,
thank you so much,the report is ok now!
by the way,is there any other method to order by the layout's field?
is it only one way to order by the layout field?
thank u a lot.

Hi

I have not seen any other method other then this in Maintain Report, if there is any other method then i will also look for it.

Thansk and Regards

The sorting options have two goals:
enable before / after field layouts
Sort modes "Ascending", "Descending" and "Presorted".

do the sorting (optionally)
Sort modes "Ascending", "Descending", not: "Presorted".
This is automatically done by the report by writing the received data to a temporary file, sorting it and reading it in again. For "Presorted", that steps aren'tt necessary.