Skip to Content
0
Former Member
Feb 16, 2009 at 03:06 AM

Data is not correct with java and CRJ SDK 12 run time

26 Views

I have a problem below:

when i create the crystal report 2008 with xml schema and xml data below, then i run with java and CRJ SDK 12 run time to export to PDF, but it just show 4 records instead of 6 records.

Please help me to explain and fix this error.

xml schema:

<?xml version="1.0" encoding="iso-8859-1"?>

http://www.w3.org/2001/XMLSchema">

<xs:element name="Document_Policy">

<xs:complexType>

<xs:sequence>

<xs:element name="PrimaryKey" type="xs:unsignedByte" />

<xs:element maxOccurs="unbounded" name="Policy_AllCoverages">

<xs:complexType>

<xs:sequence>

<xs:element name="ForeignKey" type="xs:unsignedByte" />

<xs:element name="PrimaryKey" type="xs:unsignedShort" />

<xs:element name="CVG_NUM" type="xs:string" />

</xs:sequence>

</xs:complexType>

</xs:element>

<xs:element maxOccurs="unbounded" name="Policy_Beneficiary">

<xs:complexType>

<xs:sequence>

<xs:element name="ForeignKey" type="xs:unsignedByte" />

<xs:element name="PrimaryKey" type="xs:string" />

<xs:element name="BNFY_NM" type="xs:string" />

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:schema>

xml data:

<?xml version="1.0" encoding="ISO-8859-1"?>

<Document_Policy>

<PrimaryKey>000</PrimaryKey>

<Policy_AllCoverages>

<ForeignKey>000</ForeignKey>

<PrimaryKey>111</PrimaryKey>

<CVG_NUM>A</CVG_NUM>

</Policy_AllCoverages>

<Policy_AllCoverages>

<ForeignKey>000</ForeignKey>

<PrimaryKey>222</PrimaryKey>

<CVG_NUM>B</CVG_NUM>

</Policy_AllCoverages>

<Policy_AllCoverages>

<ForeignKey>000</ForeignKey>

<PrimaryKey>333</PrimaryKey>

<CVG_NUM>C</CVG_NUM>

</Policy_AllCoverages>

<Policy_Beneficiary>

<ForeignKey>000</ForeignKey>

<PrimaryKey>ID1</PrimaryKey>

<BNFY_NM>Bill Gate</BNFY_NM>

</Policy_Beneficiary>

<Policy_Beneficiary>

<ForeignKey>000</ForeignKey>

<PrimaryKey>ID2</PrimaryKey>

<BNFY_NM>Michael Dell</BNFY_NM>

</Policy_Beneficiary>

</Document_Policy>