Hi,
Some one on the list has already helped me out.
He sent it to me directly.
Here is the XML and the XSL.
When I try to sort on th MRC, it was not sorted. My guess was
because of the comma in the dollar amount. So I used
<xsl:sort select="translate(MRC, ',', '')" data-type="number"
order="ascending"/>
It did not work, probably because some thing else worng in my
enviromnet.
Senthil pointed out that it works for him. Now it works fine for me.
Thanks for you help,
Sreeni
The XML:
*********************
<StatementLocations>
<Locations>
<Location>
<LocationName/>
<LocationName/>
<LocationName>Location1</LocationName>
<LocationAccount>2395693</LocationAccount>
<MRC>48,002.76 </MRC>
<NRC>12,686.38 </NRC>
<Local/>
<LD/>
<OCC/>
<Taxes>8,893.97 </Taxes>
<LocationAmount>69,583.11</LocationAmount>
</Location>
<Location>
<LocationName/>
<LocationName/>
<LocationName>Location2</LocationName>
<LocationAccount>2395691</LocationAccount>
<MRC>187,604.40 </MRC>
<NRC>39,209.00 </NRC>
<Local/>
<LD>31.35 </LD>
<OCC/>
<Taxes>2,239.59 </Taxes>
<LocationAmount>229,084.34</LocationAmount>
</Location>
.
.
.
</Locations>
<StatementLocations>
*************************
The correspondign XSL
<xsl:template match="StatementLocations">
<xsl:choose>
<xsl:when test="$location-sort-mode='name'">
<xsl:apply-templates
select="Location[./LocationName/text()]">
<xsl:sort select="LocationName"
data-type="text" order="{$location-sort-order}"/>
</xsl:apply-templates>
</xsl:when>
<xsl:when test="$location-sort-mode='account'">
<xsl:apply-templates select="Location[./LocationName/text()]">
<xsl:sort select="LocationAccount"
data-type="number" order="{$location-sort-order}"/>
</xsl:apply-templates>
</xsl:when>
<xsl:when test="$location-sort-mode='mrc'">
<xsl:apply-templates
select="Location[./LocationName/text()]">
<xsl:sort select="MRC"
data-type="number" order="ascending"/>
</xsl:apply-templates>
</xsl:when>
<xsl:otherwise>
<xsl:apply-templates
select="Location[./LocationName/text()]"/>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
************************************
Expected Result:
Name Account MRC NRC Taxes Charges
Location1 2395690 50.00 200.00 8.80 258.80
Location2 2395694 8,762.00 2,325.78 1,733.15 12,820.93
Location3 2395693 48,002.76 12,686.38 8,893.97 69,583.11
Location4 2395692 65,128.66 10,419.00 10,743.35 86,291.01
Location5 2395691 187,604.40 39,209.00 2,239.59 229,084.34
-----Original Message-----
From: Vasu Chakkera [mailto:vasucv(_at_)hotmail(_dot_)com]
Sent: Sunday, October 27, 2002 8:07 AM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: Re: [xsl] Need help on sorting a dollar amount.
You have to be a little more elaborative about your problem.
do the following.
1. Give an example of your XML file.
2. Give an example of what you would expect out of the transformation
3. Show us what you are getting.
Thanks
Vasu
From: Sreeni Chippada <sreeni(_at_)edocs(_dot_)com>
Reply-To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
To: "'xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com'"
<xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Subject: [xsl] Need help on sorting a dollar amount.
Date: Sat, 26 Oct 2002 17:34:04 -0400
Hi,
I am trying to sort on dollar amount. The value is
grouped by comma.
I tried to do like this:
<xsl:when test="$location-sort-mode='mrc'">
<xsl:apply-templates
select="Location[./LocationName/text()]/MRC">
<xsl:sort select="traslate(., ',', '')"
data-type="number" order="{$location-sort-order}"/>
</xsl:apply-templates>
</xsl:when>
That does not work. Appreciate any help.
Thanks,
Sreeni
XSL-List info and archive:
http://www.mulberrytech.com/xsl/xsl-list
_________________________________________________________________
Unlimited Internet access for only $21.95/month. Try MSN!
http://resourcecenter.msn.com/access/plans/2monthsfree.asp
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list