Number field on crystal report displays Exponential form.


Number Type field on crystal report printed in Exponential form when digits in this field are more than 17.


Hi Jay,
The same issue is addressed in the K-Base article c2005336. This is the limitation in Crystal, If you have more than 15 digits of numberic field it will convert into Exponential
Use database-level syntax to convert the numeric database field to a string so that Crystal Reports will interpret it as a string type, and display all of the characters.
For example, in Oracle, cast the number using to_char() and in Microsoft SQL Server use CAST() or STR() prior to adding the field to the report.
As a workaround to display all the number, I would suggest you to convert it to text using a SQL Expression Field. A SQL Expression field will be evaluated on the database server.
I would suggest you to follow the below mentioned steps to create SQL Expression field and convert a database field to a string:
1. Open the report.
2. Right click the SQL Expression field which is present in the Field Explorer.
3. Select New and copy and past the below-mentioned text.
CAST ("Database Field" as varchar)
Note u201CDatabase Fieldu201D Here you have to mention your database field.
After you create the SQL Expression Field, insert it on the report and it will display the full number.
Please note that no calculation can be made on that field since it is now a string.
I hope this helps you.

November 30, -0001

Number field on crystal report displays Exponential form.

Number Type field on crystal report printed in Exponential form when digits in this field are more than 17.Hi Jay, The same issue is addressed in the K-Base article c2005336. This is the limitation in Crystal, If you have more than 15 digits of numbe

Calling Crystal Reports from Oracle Forms 10G

Hi everyone, I am trying to call a crystal report from Oracle Forms 10G. I have a button on my Form which when clicked calls a Crystal Report which the uaser then wants to save as a PDf file. Can someone please send me the code to do this and also th

How to invoke crystal reports from Oracle forms 11g R2 along with passing p

How to invoke crystal reports from Oracle forms 11g R2 along with passing parameter to it. how to pass parameters to crystal report, please to pass parameters to crystal report, please help.This would entirely depend on crystal reports and y

Sum the sum of fields in crystal report

In crystal report 2008, i have rows of data grouped by document number. Sum of each document (RTotal1) display at Group Footer. At the Report Footer level, I want to display the Grand Total. In formula workshop, I tried to add a formula to sum RTotal

Binary field in crystal report.

Dear all expert, i have a binary field in my crystal report, how can i display it as image in crystal report? or how can i make a hyperlink on it so when user click on it, it will open a new window for them to view the image? Thank You.Drop the field

How to group by more than one fields in crystal reports

Hi How to create groups in crystal reports by more than one fields, like select fields,aggregate functions from table group by a,b,cNot sure if I understand your question, but you you could create a formula to generate the string of data you want to

Printing Crystal Reports from UDO form

Dear Experts, I want to open a Crystal report from an addon. I've already found [the following thread|] and the [mentioned blog post|

Crystal report display problem--urgent

i am trying to display to display crystal report in jsp page.. i have mentioned the entries in web.xml as below <env-entry>           <env-entry-name>clientSDKOptions</env-entry-name>           <env-entry-value>C:\ProgramFiles\Comm

How to Assign Image field in crystal report through Image UDF

Hi All, I want to capture the Image UDF in crystal report. How can i assign the field in report. Can any body help me. regards, Kiran KumarHi kiran Kumar, IPost a message to SAP Businessone Reporting & Printing Forum and also check this link Re: SAP

Need to sum hh:mm:ss in crystal report using Running Total Fields

Hello, I am new to .Net and crystal reports so please go easy on me. I am trying to develop a crystal report using Visual Basic .NET. I have a column which displays the "Inbound Time" in "hh:mm:ss" format. I have to sum the total inbou

Oracle Forms 6i and Crystal Reports XI

Hi All, Has anybody had any success in calling crystal reports xi from oracle forms 6i? I have noticed there has been a number of threads on this for previous versions of crystal. Any help would be appreciated. Regards, Scott.Did u Succeed in calling

Crystal Report V9 do not display decimal value HELP!

<p>I have a field in Informix data type is Decimal(6,2)</p><p>when i used the field in the report, the decimal is not displayed</p><p>example: field1 = 305.50, in crystal report it only displayed 305.00, already setup the for

SAP Crystal reports formula fields

hi,     how to use formula fields in crystal report.                      thanks & regards,vinothHi Vinoth, That's a very vague question. You can create formulae via the Field Explorer > Formula option. After you save and close the formula editor,

How to get Description of parameter filed in Crystal report 2008

Hi expert, I am creating a crystal report from Query ,which is created in BEX    Query designer 7. In query designer i have some selection variable. The requirement from clint is that they want to see what value is selected for all  variable. when i

Casting of crystal report viewer

I want to load crystal report in SAP B One.For this I have created a form through screen painter.I am trying to load crystal report on this form.I am using following code- Dim objCRViewer As New CrystalActiveXReportViewerLib10.CrystalActiveXReportVie

TruncateClippedFieldStrings for Crystal Reports Server 2008?

When we were running Crystal Reports XI, we had to add the registry key "TruncateClippedFieldStrings" on our server, because text fields on Crystal Reports were overlapping rather than truncating.  Now that we are on Crystal Reports Server 2008,

Error exporting to PDF from Crystal Reports 2008

Hi, We are getting following error while exporting Crystal report to the PDF and preview in IE: Description: Failed to export to a pdf file -- Selected exporter does not support one of the features used in this report. MyReport {DCA37817-1414-45A7-8D

Blank number field

This is probably a really simple question there a way to return a blank number field in Crystal Syntax like "" for a string?you can do else 0 and then go to format field -> suppress -> type currentfieldvalue=0 this will suppress t

JNDI error while generating pdf from crystal reports in java

Hi, i want to generate PDF from crystal reports in java. I have the .PDF file with database configured into the report. Following details are available in report. 1. Server Name      = testdb 2. Database Name  = testdb 3. User 4. Password I am using

Crystal reports Doubt

Hi All Can you please tell me how to create a crystal report on top of stored procedure with an example. and what are sql expression fields in crystal reports. Thank you in advance.hi, Please refer below link.