Skip to Content
0
Former Member
May 12, 2010 at 11:32 PM

conversion from number to hexadecimal

804 Views

Hi,

I have a number in a report column and I want to display hexadecimal value for that number.

For example, "SELECT MyNumber FROM MyTable" gives me a column of numbers and I would like:

24586 to be displayed as h600A

2637 as h0A4D

Is there a built-in function that I can use in Crystal Reports XI R2 ? My database is Oracle 10g R2.

It seems that I cannot use SQL Expression Field because I already have an SQL Command in my report.

Thank you,

Milan