This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Nested Grouping problem [with links]
- To: <xsl-list at mulberrytech dot com>
- Subject: Nested Grouping problem [with links]
- From: "Alex Aguilar" <alex at pasofijo dot com>
- Date: Wed, 29 Nov 2000 02:18:29 -0800
- References: <000b01c05970$40435e60$0e6411ac@installshield.com>
- Reply-To: xsl-list at mulberrytech dot com
I apologize for the double post but I did not know the listserver stripped
out HREFs.
---------------------------------------------------------------------------
----------
This is a grouping problem. In fact its a nested grouping problem.
I've gone through your Jennison's helpful article
[http://www.jenitennison.com/xslt/grouping/muenchian.html]on the Muenchian
key technique and searched through the newsgroup messages and the XSLT FAQ
[http://www.dpawson.co.uk/xsl/sect21.html] but haven't found anything
similar.
From a flat XML structure like:
<FundList>
<Fund rowid="1">
<fundName>Sarah's MoneyMarket Fund</fundName>
<assetClass>MoneyMarket</assetClass>
<capitalization/>
<id>12845</id>
<percent>0</percent>
<risk>4</risk>
</Fund>
<Fund rowid="2">
<fundName>Will's Fund</fundName>
<allocCategory>Domestic Equity</allocCategory>
<assetClass>Growth</assetClass>
<capitalization>Small Cap</capitalization>
<id>12345</id>
<percent>0</percent>
<risk>4</risk>
</Fund>
<Fund rowid="6">
<fundName>Alex's Fund</fundName>
<allocCategory>Domestic Equity</allocCategory>
<assetClass>Aggressive Growth</assetClass>
<capitalization>Medium Cap</capitalization>
<id>17378</id>
<percent>0</percent>
<risk>5</risk>
</Fund>
</FundList>
I want to create a nice looking page that looks like this
[http://64.50.6.166/a/asdren/fundlist.htm]. I used to have it
[http://64.50.6.166/a/asdren/fundlistold.xml] working in XSL but then we
found out there wasn't an easy way to get the database to return a nice
hierarchical XML like the one I had designed ;-(
My problem is I'm relatively new to XSL and am not sure as to the best way
to go about creating keys to accommodate four levels of nested grouping. As
I stated XML cannot be modified. It has to be processed in this flat format.
I'm able to get up to one level but once I start nesting for-each loops
inside each other I don't get the desired results.
I was thinking of perhaps hardcoding the four top level categories (Cash,
Domestic Fixed, Domestic Equity and International Equity). The only thing I
don't like about that is that if ever another allocation category were added
then someone has to make a change to the XSL. Is there a way to perhaps a
make a robust XSL so that no matter how many categories are added the XSL
would still handle it?
To be honest, I'm kind of tired of spinning my wheels on this one and am
willing to monetarily compensate someone to help me solve this one.
Here are some reference files:
FundList.xml [http://64.50.6.166/a/asdren/fundlist.xml]- file containing
the current flat XML structure
FundList.xsl [http://64.50.6.166/a/asdren/fundlist.xsl]- my feeble
attempt
FundList.xls [http://64.50.6.166/a/asdren/fundlist.xls]- an Excel file
outlining the category structure
If anyone is interested, please contact me off the list at alex@pasofijo.com
thanks,
Alex Aguilar
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list