Hi,

Note: I am using MSXML and XSLT 1.0

I have the following XML document:

<?xml version="1.0"?>
<Reports xmlns="">
  <Report>
    <Measures>
      <Measure idx="1" heading="Total Pages"/>
      <Measure idx="2" heading="Cost"/>
    </Measures>
    <Columns>
      <ColGrp heading="Year">
        <Col heading="2003"/>
        <Col heading="2004"/>
      </ColGrp>
    </Columns>
    <Rows>
      <RowGrp heading="Journal Full Name">
        <RowGrp heading="General Medicine">
          <Row heading="Journal of Musculoskeletal Med">
            <Cell/>
            <Cell>
              <Msr idx="1" val="16.00"/>
              <Msr idx="2" val="90560"/>
            </Cell>
          </Row>
          <Row heading="Physician &amp; Sports Medicine">
            <Cell/>
            <Cell>
              <Msr idx="1" val="20.00"/>
              <Msr idx="2" val="131930"/>
            </Cell>
          </Row>
        </RowGrp>
        <RowGrp heading="Orthopedics">
          <Row heading="Jnl American Acad of Ortho Sur">
            <Cell/>
            <Cell>
              <Msr idx="1" val="8.00"/>
              <Msr idx="2" val="18440"/>
            </Cell>
          </Row>
          <Row heading="Journal of Bone &amp; Joint Surger">
            <Cell/>
            <Cell>
              <Msr idx="1" val="16.00"/>
              <Msr idx="2" val="40160"/>
            </Cell>
          </Row>
          <Row heading="Orthopedics Today">
            <Cell/>
            <Cell>
              <Msr idx="1" val="20.00"/>
              <Msr idx="2" val="48800"/>
            </Cell>
          </Row>
        </RowGrp>
        <RowGrp heading="">
         <RowGrp heading="">
          <Row heading="Totals">
            <Cell>
              <Msr idx="1" val="0"/>
              <Msr idx="2" val="0"/>
            </Cell>
            <Cell>
              <Msr idx="1" val="140"/>
              <Msr idx="2" val="455410"/>
            </Cell>
          </Row>
        </RowGrp>
      </RowGrp>
    </Rows>
  </Report>
</Reports>

I use the following code to sort it:

<xsl:param name="sortCell" select="1"/>
<xsl:param name="sortCol" select="1"/>

<xsl:template match="Report" >
   <table class="grdMain" border="0" cellspacing="1" cellpadding="0">
          <tbody>
            <xsl:choose>
              <xsl:when test="number($sortCol) != 0 and //Row[position() != last()]">
                <xsl:apply-templates select="//Row" mode="data">
                  <xsl:sort select ="Cell[number($sortCell)]/descendant::Msr[number($sortCol)]/@val" data-type="{$dataType}" order ="{$sortOrder}" />
                </xsl:apply-templates>
              </xsl:when>
              <xsl:otherwise>
                <xsl:apply-templates select="//Row" mode="data" />
              </xsl:otherwise>
            </xsl:choose>
          </tbody>
        </table>
</xsl:Template>

Please note that the value of the two parameters is passed to the xslt($sortCell and $sortCol).

The sort works fines but the problem is that it is also sorting the Totals row.

When I sort descending the Total row is being moved to the top of the table and that is wrong. I would like the Totals Row to stay always at the bottom of the table

Therefore, I am doing a test to see if the Row position is not the last before I sort but this is not working.

<xsl:when test="number($sortCol) != 0 and //Row[position() != last()]">

I appreciate any help on this.

Cheers

CP

I have tried this test but it did not work either. The Totals row is still moving to the top when sort is set to descending.

<xsl:when test="number($sortCol) != 0 and //Row[@heading != 'Totals']">

You logic is:

<xsl:when test="number($sortCol) != 0 and //Row[position() != last()]">

"if $sortCol is not zero and there is a row that is not the last row"

<xsl:apply-templates select="//Row" mode="data">
                  <xsl:sort

"then sort all the rows".

What you want to say is "sort all the rows except the last one and then output the last row". That is:

 <xsl:apply-templates select="(//Row)[position()!=last()]" mode="data">
                  <xsl:sort ... />
 </xsl:apply-templates>
 <xsl:apply-templates select="(//Row)[last()]"/>

Note also the difference between (//Row)[last()] and (//Row[last()]). The first expression selects the last of all the rows, the second expression selects every Row that is the last child of its parent.


Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Thanks a lot Michael.