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?
IP Logged