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

Web reporting -- Table interface --Sorting table

12 Views

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