Skip to Content
Former Member
Mar 27, 2006 at 08:58 PM

Web reporting -- Table interface --Sorting table



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,