How to Sort Category in SAP Report connector

[#1]

Hi,

Right now i'm trying to pull a report for SAP using report connector, the report runs over million records. I was able to see a category 19, but I'm not able to find the category's from 7 to 18 also I'm not sure if 19 is the last category in the report array. Its practically impossible to scan through each record to check for the category type.

Can we sort the Category while pulling the data from SAP Report.

Please suggest if there is a better way to do it.

Regards,

Vikram.

[#2]

Hi,

Try to set the order by criteria within the SAP SQL statement.

You will find the syntax here:

http://help.sap.com/abapdocu_70/en/ABAPORDERBY_CLAUSE.htm

Regards,

Björn