SSDN - grouping in Stylus Studio Publisher

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Roger roger

Subject: grouping in Stylus Studio Publisher
Author: Roger roger
Date: 29 Feb 2012 11:41 AM

Hello,
We are trying Stylus Studio Publisher version for generating XSL-Fo that will display PDF. We have data something like this in the XML source file that need to be grouped and displayed.

<items>
<item>
<name>product1</name>
<category>charge</category>
<amount>8.5</amount>
</item>
<item>
<name>product12</name>
<category>usage</category>
<amount>5.5</amount>
</item>
<item>
<name>product28</name>
<category>calls</category>
<amount>5.5</amount>
</item>
<item>
<name>product29</name>
<category>usage</category>
<amount>10.0</amount>
</item>
...
</items>

The displayed data should be the sum of Amount grouped on category, should look like this:

charge: 8.5
usage: 15.5
calls: 5.5

Can this be done with Stylus Studio publisher when working with a report? We want to avoid to need to generate the XSL-Fo code and manually add XSLT instruction to do this. Is this possible to do from the visual tool? We have been trying to do this by using diferent XPath statement in the tool but to no success. We are using the latest trial version.

Thanks in advance!

Ivan Pedruzzi

Subject: grouping in Stylus Studio Publisher
Author: Ivan Pedruzzi
Date: 29 Feb 2012 03:09 PM

Yes, have a look at the screenshot attached.

Ivan Pedruzzi
Stylus Studio Team

Roger roger

Subject: grouping in Stylus Studio Publisher
Author: Roger roger
Date: 29 Feb 2012 09:55 PM

Thanks for quick response. This works fine if you in advance know the number of categories that exist in each xml data source, then you can create one row for each and display sum.
But if there is a diferent number of item categories for each xml data source, how to do to dynamic create the number of categories with its sum?

Ivan Pedruzzi

Subject: grouping in Stylus Studio Publisher
Author: Ivan Pedruzzi
Date: 29 Feb 2012 11:04 PM

Here is a solution that groups dynamic values.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Roger roger

Subject: grouping in Stylus Studio Publisher
Author: Roger roger
Date: 01 Mar 2012 02:16 AM

Thanks! this worked

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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-2016 All Rights Reserved.