Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to write sql in crystal report to order by record?
Message
From
19/04/2011 00:09:46
 
 
To
All
General information
Forum:
ASP.NET
Category:
Reporting
Title:
How to write sql in crystal report to order by record?
Environment versions
Environment:
VB 9.0
OS:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01507784
Message ID:
01507784
Views:
125
Hi, all
i have a difficult problem......Can i wirte sql in crystal report to order by record?
i know crystal reports plus-in Record Sort Expert function , but can' t use sql ....
Because, i want to order by linenum , but this struct is char(4), i want change to integer to sort ......
How can i do , please
SELECT  *
FROM      quodtl
ORDER BY CONVERT(int, linenum)
Next
Reply
Map
View

Click here to load this message in the networking platform