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