Formatting Numeric Values in Crystal Reports !!

Hi there,

Am designing a report in Crystal Reports to display Sales Order information (DOCO,DCTO,LNID, AN8, UORG and AEXP).
Am unable to format numeric fields like UORG and AEXP (for example: If an order has Quantity of 2.0000 and Amount as 43.96, they are shown as 20000 and 4396.00 in Crystal reports).

Any help on fixing this issue would be greatly appreciated. Thanks in Advance.

Jay

You have a couple of options.

1. Use ODA rather then ODBC. You will need a JDE Client to get the ODA
(unless someone has a work around to that) and will be prompted to logon
to OneWorld. You will then be able to use OneWorld views and it will use
the formats called out in the data dictionary.

2. In you SQL statement divide each field by a value that corresponds to
the display decimals in the data dictionary. For example: if the display
decimal is 2, then divide by 100, if 3 then by 1000, etc.... We use
Cognos and have our catalogs and have predefined qty, amount and date
fields so the end-users don't have to remember to do this.

Sue
Xe Update 6, sp18.1 Oracle 8.1.7

This is due to the precision being defined in the DD. The easiest would be
to hard-code the appropriate division operation (ie: "UORG / 10000" instead
of "UORG") in the report...

Regards,
Alexander Pastuhov

All jde number are stored with 0 decimal places. Jde convert to the
correct using the Data Dictionary value.



jdeuser2000 wrote:



Consultant Programmer Analyst Functional for 25 years in manufacturing Industrial Engineering by training and programmer by training

Jay,

I'd like to add the following to the other good suggestions you've received.

Why not create a database view for each of the common tables you report on that:
1. Provides meaningful names for the fields instead of "UORG".
2. Does the required division on numerics so you don't have to repeatedly set up formulas in Crystal.
3. Converts date fields from JDE's Julian numbers to real dates.

You'd be investing a little effort up front - but the payback easily justifies the effort.

Regards,