Crystal reports - alpha to numeric

Create a formula called something like OrderRelNum.
The formula would be ToNumber(OrderRel.OrderRelnum)

Then sort the report using the formula @OrderRelNum instead of the field.


Troy Funte
Liberty Electronics


----- Original Message -----
From: Dunn, Nancy
To: Vantage Onelist (E-mail)
Sent: Tuesday, March 13, 2001 4:36 PM
Subject: [Vantage] Crystal reports - alpha to numeric


I'm sorry to have to ask again, but I can't find the answer in the archives.
I am trying to change the OrderRel.OrderRelnum field to a numeric field in
Crystal reports so the Release numbes sort correctly.
Sort like this Instead of this
1 1
2 10
3 11
What was the formula?
On version 4.904 Crystal reports ver8
Thanks
Nancy Dunn
Winco Industries Inc
ndunn@...


Yahoo! Groups Sponsor

Click Here to Find Software Faster


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
I'm sorry to have to ask again, but I can't find the answer in the archives.
I am trying to change the OrderRel.OrderRelnum field to a numeric field in
Crystal reports so the Release numbes sort correctly.
Sort like this Instead of this
1 1
2 10
3 11
What was the formula?
On version 4.904 Crystal reports ver8
Thanks
Nancy Dunn
Winco Industries Inc
ndunn@...