cancel
Showing results for 
Search instead for 
Did you mean: 

Need help in sorting a alphanumeric DB column in BO report.

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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.