Skip to Content
0
Former Member
Dec 04, 2008 at 07:52 PM

Crystal Reports and XML File

36 Views

Is there a way that I can take a file that looks somewhat like the following and generate a crystal report?

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

<!DOCTYPE Packouts (View Source for full doctype...)>

- <Packouts>

<Company Desc="">HB</Company>

<Line>L1</Line>

- <RunGroup>

<Date>2008-09-09</Date>

<Run>5</Run>

<PoolID>09D2102</PoolID>

<GrowerID Desc="English Bros">ENGLISH</GrowerID>

<GrowerBlock>8-1S</GrowerBlock>

<Commodity Desc="Red Grapefruit">G</Commodity>

<Variety Desc="Sprdk Red Gft">21</Variety>

<ReceivedUofM Desc="Field Box">BOX</ReceivedUofM>

<ClearedUofM Desc="4/5 Bushel">4D</ClearedUofM>

<Received>522</Received>

<Cleared>1044</Cleared>

<Packed>1369</Packed>

- <Sizes>

<Size Desc="12" Total="0" EquivTotal="">012</Size>

<Size Desc="18" Total="0" EquivTotal="">018</Size>

<Size Desc="23" Total="57" EquivTotal="">023</Size>

<Size Desc="27" Total="130" EquivTotal="">027</Size>

<Size Desc="32" Total="245" EquivTotal="">032</Size>

<Size Desc="36" Total="294" EquivTotal="">036</Size>

<Size Desc="40" Total="295" EquivTotal="">040</Size>

<Size Desc="48" Total="185" EquivTotal="">048</Size>

<Size Desc="56" Total="163" EquivTotal="">056</Size>

<Size Desc="64" Total="0" EquivTotal="">064</Size>

<Size Desc="" Total="0" EquivTotal="">222</Size>

</Sizes>

- <Row>

<Label Desc="Heller">1</Label>

<Grade Desc="Us1">US1</Grade>

<UofM Desc="4/5 Bushel">4D</UofM>

<Count Size="023">57</Count>

<Count Size="027">130</Count>

<Count Size="032">245</Count>

<Count Size="036">294</Count>

<Count Size="040">295</Count>

<Count Size="048">185</Count>

<Count Size="056">163</Count>

</Row>

</RunGroup>

- <RunGroup>

<Date>2008-09-09</Date>

<Run>6</Run>

<PoolID>09D2102</PoolID>

<GrowerID Desc="English Bros">ENGLISH</GrowerID>

<GrowerBlock>8-1S</GrowerBlock>

<Commodity Desc="Red Grapefruit">G</Commodity>

<Variety Desc="Sprdk Red Gft">21</Variety>

<ReceivedUofM Desc="Field Box">BOX</ReceivedUofM>

<ClearedUofM Desc="4/5 Bushel">4D</ClearedUofM>

<Received>522</Received>

<Cleared>1044</Cleared>

<Packed>507</Packed>

- <Sizes>

<Size Desc="12" Total="0" EquivTotal="">012</Size>

<Size Desc="18" Total="0" EquivTotal="">018</Size>

<Size Desc="23" Total="21" EquivTotal="">023</Size>

<Size Desc="27" Total="53" EquivTotal="">027</Size>

<Size Desc="32" Total="90" EquivTotal="">032</Size>

<Size Desc="36" Total="107" EquivTotal="">036</Size>

<Size Desc="40" Total="108" EquivTotal="">040</Size>

<Size Desc="48" Total="59" EquivTotal="">048</Size>

<Size Desc="56" Total="59" EquivTotal="">056</Size>

<Size Desc="64" Total="0" EquivTotal="">064</Size>

<Size Desc="" Total="10" EquivTotal="">222</Size>

</Sizes>

</RunGroup>

</Packouts>

Thanks,

Jim