水晶报告自定义排序顺序 [英] crystal report custom sort order
问题描述
请回复...
我正在使用Crystal Report 10使用ODBC访问oracle db。
在我的一个报告中,我将数据分组在"站名"上。及其子记录。例如。站" ABC"在序列中有Sub记录吗? A10,A100,A110,A120,A20,A30,A40,A50,A60,A70,A80,A90"
但我希望将其打印在报告中,如下所示:
Please reply...
I am using Crystal Report 10 using ODBC to access oracle db.
In one of my reports, I grouped my data on "station name" and its sub records.
For eg. Station " ABC " have Sub records in the sequence
" A10, A100, A110, A120, A20,A30,A40,A50,A60,A70,A80,A90".
But I want this to be printed in the report as below:
" A10,A20,A30,A40,A50,A60,A70,A80,A90,A100,A110,A120"。
"A10,A20,A30,A40,A50,A60,A70,A80,A90,A100,A110,A120".
如果我尝试排序方向,我可以只看两个选项,
升序或升序。这两个都不符合我的目的。
If I try this with sort direction, I can see only two option,
either ascending or dscending order. Both of them will not serve my purpose.
Crystal Reports 10中是否有任何方法可以获得所需格式的报告。
Is there any method in crystal Report 10 to get report in the required format.
请回复。 。
Please reply..
推荐答案
创建公式并放置字段并使用以下公式
ToNumber(替换("A10" ;,"A",""")。
然后在报告中使用公式 - >记录排序专家。
哪个将按编号排序。不要仅显示用于排序的公式。
Create a formula and place the Fields and use the following formula
ToNumber(Replace("A10","A","")).
Then use the formula in
Report -> Record Sort Expert.
Which will sort by number. Don't display the formula use only for sorting.
这篇关于水晶报告自定义排序顺序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!