Digit Precision -- displaying more than 15 digits number 2

[Gesrix]

I am using Crystal Reports XI. I have a number type database(Oracle) field that contains 16 digits, example: 1234567890123456. When viewed in Crystal Report designer, it is 123456789123460. I already try to convert it to text using ToText function but same output. Is this a bug? Is there a way to show it correctly? Thank you!

Additional Infor: Oracle 10g and Crystal Reports XI is in Windows 2003.

 

[CR85user]

If it is a number field try right clicking it - choose format field and then set the format to (1123) in the number tab. See if that makes any difference.

'J

 

[Gesrix]

Hi, Thank you for replying. I already did that and it does not change anything. Another way to duplicate the issue is by going to Select Expert in Crystal Reports then select a number type field and pick a value of "is equal to", let's say - 1234567890123456. Once the number is entered,
Go to "Show Formula, and the number should be already rounded--1234567890123460. Any thoughts?

 

[lbass]

Try inserting a sql expression like:

{fn convert("table"."number",sql_varchar)}

I can't remember whether the convert function is available in Oracle, but cast might work, too.

-LB

 

[Gesrix]

Hi LB, sorry.. I did not know where to put this sql expression. I am working only on Crystal Reports Designer and this behavior is seen in the designer itself.

 

[lbass]

Go to the field explorer->SQL expression->new and enter it there.

-LB

 

[Gesrix]

Wow! That works...
Thank you, LB!

 

[Gesrix]

Hi lbass,
Happy New Year to you...

One more favor, would you know what is the equivalent of that command in AS400 database?

Thank you!
~Gesrix

 

[lbass]

I am not familiar with AS400. Did you check the function list in the SQL expression editor to see what options might be available? You could try using cast().

-LB

 

[Gesrix]

Thanks to all who respond, particularly to Lbass.

BO confirms that Cr can only take 15 digits.

Have a good day to all.. always!