Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

NUMBER formatting with more than 10-decimals

Status
Not open for further replies.

MJRBIM

MIS
May 30, 2003
1,579
CA
Crystal Reports XI or 2008

The NUMBER formatting options for decimals supports a MAXIMUM of Ten (10) decimals.

1.0000000000

We have database fields that have up to Fifteen (15) decimals that can be used.

1.000000000000000

Is there any way to support that increased level of decimal-detail in Crystal Report NUMBER formatting...?

Maybe a REGEDIT setting...?

Thanks in advance!

Senior Business Intelligence Consultant
Toronto, Canada

SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) | Crystal ( 7 -> 2008) design | WebI design | Best practices for Java / .Net / Web Services
 
Could you convert it to a text string for display? Maybe a formula that declares it as a string rather than a number. Just don't use the tex string in any calculations for the report.
 
If we convert it to a string then it is no good for anyone who exports the RPT to CSV or EXCEL as it is not shown as a NUMBER.

There's lots of Science and Financial applications that use more than 10 digits of decimals. Kind of surprised that this is the Crystal limit.

Senior Business Intelligence Consultant
Toronto, Canada

SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) | Crystal ( 7 -> 2008) design | WebI design | Best practices for Java / .Net / Web Services
 
The field would "show" as a number in .csv and excel. You could sort or search the text field in csv or excel. You could not use it for calculations in Excel unless the user converted it, which seems plausible if they had the expertise to export the report from crystal. Anyway, wouldn't scientific notation be a better way to display a real "number" that had 15 digits after the decimal point?

Here is another post that cover this. 'ToText' or the corresponding sql expression will work for displaying your number in crystal reports.

It sounds like you would need to use sql expressions even to use the entire number in calculations within Crystal. Sorry you can't get exactly what you need.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top