Nested Grouping problem [with links]

["Alex Aguilar" <alex at pasofijo 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