topic Re: about reports sorting in Application Development and Automation Discussions

about reports sorting

Former Member — Thu, 07 Feb 2008 16:57:15 GMT

Hi ,

i have three fields field1 , field2 , field3 .They are from some database table.

i want to prepare a report that field1 values are in ascending order and field2 values are in descending order and field values are in ascending order .

Thanks in advance.

Re: about reports sorting

Laxmana_Appana_ — Thu, 07 Feb 2008 17:07:12 GMT

Hi,

Use below statement to do sorting as per your req.

SORT i_tab BY field1 ASCENDING field2 DESENDING field3 ASCENDING.

Regards

L Appana

Re: about reports sorting

Former Member — Thu, 07 Feb 2008 17:09:13 GMT

Hi Kaladhar,

Store those values in an internal table

then SORT ITAB BY FIELD1 FIELD3 ASCENDING FIELD2 DESCENDING.