Skip to Content
0
Former Member
Mar 05, 2009 at 06:49 AM

NUMBER Column

88 Views

Hello,

I have CR 2008 report which is using an Oracle 10G view to return/display data. The view has 2 columns:

ORDER_NUMBER VARCHAR2(40)

ORDER_ID NUMBER(38)

A parameter is passed to the report for the order number. Order number is displayed correctly on the report but the ORDER_ID being displayed is NOT the one which is linked to the order number

ORDER_NUMBER 1234 -> ORDER_ID 6757598464312354

Above is the correct ORDER_ID but the report displays

ORDER_NUMBER 1234 -> ORDER_ID 6757598464312360

If I change ORDER_ID to VARCHAR2 the data displays correctly but this gives a huge performance hit so it's preferable that the column is a NUMBER type.

Any ideas on what's going on in the report?

Thanks & Regards - CAG