Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

about reports sorting

Former Member
0 Likes
392

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.

2 REPLIES 2
Read only

Laxmana_Appana_
Active Contributor
0 Likes
375

Hi,

Use below statement to do sorting as per your req.

SORT i_tab BY field1 ASCENDING field2 DESENDING field3 ASCENDING.

Regards

L Appana

Read only

Former Member
0 Likes
375

Hi Kaladhar,

Store those values in an internal table

then SORT ITAB BY FIELD1 FIELD3 ASCENDING FIELD2 DESCENDING.