I am trying to generate a simple report.
WANTED:
Part # | QA Qty | QS Qty
part1 1 10
part2 2
GETTING:
Part # | QA Qty | QS Qty
part1 1 10
2
part2 1 2
I want for each line item to return the QA Quantity into column2 and the QS quantity in column3. It appears to returning all the QA values for each item. I know how to do this in XSL but the report generator always sets the loop from the root node.
<LINLoop1>
<LIN LIN02="part1"/>
<ZALoop1>
<ZA ZA01='QA' ZA02='1'/>
<ZA ZA01='QS' ZA02='10'/>
</ZALoop1>
</LINLoop1>
<LINLoop1>
<LIN LIN02="part2"/>
<ZALoop1>
<ZA ZA01='QS' ZA02='2'/>
</ZALoop1>
</LINLoop1>
SourceFile.zip XML Source fille and Report file
|