Browser sort problem

[atuldalvi]

I am having a browser which is populating dynamically. There is field in that browser from which data is coming like 'ABC', 'Total' , 'PQR' etc.. Now i want to sort that browser in such a way that 'Total' record should always come at the bottom as that 'total' field has sum of rest of the data.

e.g. browser display

Name Data
ABC 100
DEF 100
Total 450
GHI 50
PQR 200


Please help

 

[Cringer]

Does it use a temp table to build the actual data? If so, just add a field on the temp table as sort order (integer) and generate that when you retrieve the data.

 

[atuldalvi]

No that browser is directly populating from DB table

 

[rzr]

Looking at the example you gave above.. you have two columns "Name" and "Data" ... so, can't you sort it using the "Data" column then and it should show the total at the end...

 

[atuldalvi]

but some times data is coming like

Name Data


ABC 100
DQr -150
Total 50
WXY 100

 

[rzr]

populate data to temp-table, do as suggested by Cringer and then display the temp-table in the browser....