Web reporting -- Table interface --Sorting table

[Former Member]

Hi.

We want to display an extremely complex query in the Web, which returns about 40.000 rows.

Our users are however only interested in the fifteen 'Overall result'-rows of this query. Therefore we try to find a possibility to suppress all the 'normal' data rows.

I have an idea, where in the Table Interface would like to try to "mark" these 15 rows each with a unique number (from 1..15, in an added column in my table). I would then want to sort this table according to my new column, thus giving me a table that first displays these 15 rows. Now I can set in the WAD: Display the first 15 rows.

Is this achievable? Could anyone provide coding examples that could help me do this?

Thank you,

Jon

[Former Member · Accepted solution]

hi,

have a look at this help doc, u will get a n idea of how to do it.

http://help.sap.com/saphelp_nw04/helpdata/en/50/0a433ab9fb960ee10000000a11402f/content.htm

regards

sham'm

[former_member184494]

Jon,

I do not think that would be possible. The table interface is something like a line by line interpreter which interprets the data coming and converts it to HTML.

Hence for you to be able to mark the result rows would mean that the whole query of 40,000 rows has to be rendered.

Another option is to use a prequery to retrieve the result rows , and if you display only the result rows of the query , will your purpose be satisfied ?

Arun

[Former Member]

Arun,

Any means of getting out only the result rows is great, as long as it works.

What do you mean by using a prequery? I am not familiar with that. Could you please explain?

Thanks,

Jon