[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Sort on calculated field



Sybase 11.0.2.1
SQR 3.0.13.2

How can I sort in descending order on a field that is created
by a calculation during processing?

I have existing fields for regular hours and overtime hours
from which I calclulate the percent of OT to Regular.  When
the report is printed, I want the highest percentage to be on
the first line.

I suspect that I need to use a bind variable in some way.

TIA

Darwin
dander03@avis.com
516-222-3064