Crystal Reports 7.0 Professional<br>Report Type: Custom / SQL-ODBC<br>Data Source: Lawson Procurement Application<br>Database Type: Oracle<br>Table Count= 5<br><br>Problem: inconsistent data population in single table field<br><br>The report is extracting data from Purchase Order related tables and the specific field that is inconsistently populated is an "POLINE.DESCRIPTION" field. <br><br>There are four data "ITEM" type classifications:<br>a) "INVENTORY" or "I"<br>b) "NON-STOCK" or "N"<br>c) "SPECIAL" or "X"<br>d) "SERVICE" or "S"<br><br>The inconsistency occurs when the "ITEM" type is one of the following types:<br>a) "INVENTORY" or "I"<br>b) "NON-STOCK" or "N"<br><br>The same item may be displayed on one report line and not on the very next report line.<br><br>Is this a Oracle Database issue or what?<br><br>Thanks <br>Alan L. Moore<br>Mayo Foundation<br><A HREF="mailto:moore.alan@mayo.edu">moore.alan@mayo.edu</A><br><br><br><br><br><br>