Sort by formula 1

[LT2]

Hello,

Using CRXI w/SQL Svr 2005

Report is populated by SQL command and displays client, admitdate, @LOS, auth, authexp, @AuthRenew & Agency in the details.

@AuthRenew (whileprintingrecords; CurrentDate - {Command.AuthExp})

I'd like to sort in desc order by the results of @AuthRenew but it doesn't show as a selection in the Record Sort Expert.

How can I make this happen?

LT

 

[lbass]

Remove the "whileprintingrecords"--it is not necessary.

-LB

 

[LT2]

That was easy! Thanks LB.

LT