on 03-08-2011 6:51 AM
Hi All,
We have a DB column (Data type = varchar2).. with values..
1
1
1.1
1.1.1
1.1.1.1
1.2
1.2.1
1.3
1.3.1
1.3.1.1.1
Desired
1
1.1
1.1.1
1.1.1.1
1.2
1.2.1
1.3
1.3.1
1.3.1.1.1
2
etc..
We need to sort this column in BO report.. any idea.. we have sorted it in the Query which is giving right output in pl/sql developer but in BO sorting is not showing properly.
Could you help please to achieve this?
Thanks and Regards,
Priyashree
Hello Priyashree,
In this situation, I would use "Record Sort Expert" to sort the records in ascending order . I will also select distinct records from 'Report Options'.
Regards,
Chinmay Athavale
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chinmay,
Thanks for your reply.
If possible, could you please ellaborate more on how can we implement "Record Sort Expert" in BO. Actually I am new to BO thats why dont have idea about this. IF you will explain us; it would be of great help.
Thanks and Regards,
Priyashree
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The Record Sort Expert appears when you choose the Record Sort Expert command from the Report menu.
Use the Record Sort Expert to define how you want the records in your report to be sorted for printing. You can add and remove a sort field and define the sort direction (ascending or descending) for the data in your report.
In my version Record Sort appears as a A over a Z with Arrows pointing from A to Z, and Z to A. It is next to group expert, which looks like a mountain with an arrow pointing up. Both are on the "Expert" tool bar.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.