Skip to Content
0
Former Member
Mar 08, 2011 at 06:51 AM

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

63 Views

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