XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Conferences Close Tree View
+ Stylus Studio Feature Requests (1123)
- Stylus Studio Technical Forum (13809)
-> + Flat File (From mainframe COBO... (8)
-> + X12 Validation (5)
-> + Schema replacement in Microsof... (2)
-> + [OT] XML fragment - error expl... (3)
-> + Re-using a simple type definit... (2)
-> + What is "Java bult-in" XSLT Pr... (2)
-> + Error when generating .NET cod... (6)
-> + options for sum(function) - to... (2)
-> + [OT] XSD - is this valid XML o... (2)
-> + Multiple page sequences (2)
-> + License disabled (3)
-> + EDIFACT to XML with multiple Q... (5)
-> + Viewing Web Service Call http ... (2)
-> - keyref handling by different p... (1)
-> + Running transform in SS UI com... (9)
-> + Mapping from one schema to ano... (3)
-> - Using document() to lookup fro... (1)
-> + Can not open a xml file in IE ... (2)
-> + Stylus Studio detected a chang... (3)
-> + Customer Support for Stylus St... (2)
-- Previous [1021-1040] [1041-1060] [1061-1080] Next
+ Website Feedback (243)
+ XSLT Help and Discussion (7447)
+ XQuery Help and Discussion (1861)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (361)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Alexis ArrowsmithSubject: XML Report Table Problem
Author: Alexis Arrowsmith
Date: 06 Dec 2007 04:22 PM
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>


UnknownSourceFile.zip
XML Source fille and Report file

Posttop
Alberto MassariSubject: XML Report Table Problem
Author: Alberto Massari
Date: 11 Dec 2007 06:36 AM
Hi Alexis,
have you tried drag & dropping the same @ZA02 attribute in the two columns, and then editing XPath entry in the Dynamic Value property tab to say ZA[@ZA01='QA']/@ZA02 for the second column, and ZA[@ZA01='QS']/@ZA02 for the third one?

Alberto

   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2011 All Rights Reserved.