Re: [xsl] Pivot Reports

Subject: Re: [xsl] Pivot Reports
From: Vitaliy Paykov <vpay@xxxxxxxxx>
Date: Fri, 05 Jan 2007 17:17:48 +0200
I want build picture like this:


* Software SW Change total B-Evaluated 4 1 5 C-Open 1 - 1 E-Reviewed 1 - 1 total 6 1 7




* Deficiency Enhancement Environment External - SCC Not a Defect Software SW Change Test Case total
B-Evaluated 90 48 - 7 3 1 18 33 200
E-Reviewed 1 - - - - - - - 1
J-Rework 4 - 5 - - - - - 9
total 7 3 1 33 18 95 48 5 210






* Deficiency Enhancement External - SCC Not a Defect Software SW Change Test Case total
A-New 1 - - - - - - 1
B-Evaluated 15 3 1 2 1 3 3 28
E-Reviewed 1 - - 1 - - - 2
total 3 1 3 3 17 3 1 31




*
Deficiency Enhancement Environment External - 3rd party External - SCC Installation Not a Defect Software SW Change Test Case total
A-New 2 - 2 - - - - - - - - 4
B-Evaluated - 175 66 1 44 29 1 1 19 16 2 354
C-Open - 3 1 - 1 - - - - - - 5
D-Implemented - - 1 - - - - - - - - 1
E-Reviewed - 39 3 - 5 5 - - - - - 52
F-Loaded - - 1 - - - - - - - - 1
G-Fixed - - 8 - - - - - - - - 8
H-Tested - 16 1 - 1 1 - - - - - 19
J-Rework - - 4 - - - - - - - - 4
total 2 51 35 1 2 16 1 19 233 87 1 448







D O wrote:
Do you have a sample html of the output you want, given the test data?
This way we can see what exactly you are trying to do...

thanks, dan


Dan Ochs, Principal Consultant Wrycan, Inc http://www.wrycan.com dan(dot)ochs(at)wrycan(dot)com

On 1/5/07, Vitaliy Paykov <vpay@xxxxxxxxx> wrote:
This is my XSL template:

<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
<xsl:key name="b" match="pivotrow" use="."/>
<xsl:key name="c" match="pivotcol" use="."/>
<xsl:template match="/">
<xsl:for-each select="/notice/records/record/row">
  <br/>
<xsl:for-each select="pivot1">
      <table border="1" cellspacing="0" class="stn">
          <tr>
            <th>*</th>
            <xsl:for-each select="item/pivotrow">
              <xsl:sort select="."/>
              <xsl:variable name="vpivotrow" select="."/>
              <th>
                <xsl:value-of select="."/>
              </th>
            </xsl:for-each>
            <th>total</th>
          </tr>
        <xsl:for-each
select="item/pivotcol[generate-id(.)=generate-id(key('c',.)[1])]">
          <xsl:sort select="."/>
          <xsl:variable name="vpivotcol" select="."/>
          <tr>
            <th><xsl:value-of select="."/></th>
            <xsl:for-each
select="../../item/pivotrow[generate-id(.)=generate-id(key('b',.)[1])]">
              <xsl:variable name="vpivotrow" select="."/>
              <td>
                <xsl:if test="not(../../item[pivotcol=$vpivotcol and
pivotrow=$vpivotrow])">-</xsl:if>
                <xsl:if test="../../item[pivotcol=$vpivotcol and
pivotrow=$vpivotrow]"><xsl:value-of
select="../../item[pivotcol=$vpivotcol and
pivotrow=$vpivotrow]/TOTALS"/></xsl:if>
              </td>
            </xsl:for-each>
            <td><xsl:value-of
select="sum(../../item[pivotcol=$vpivotcol]/TOTALS)"/></td>
          </tr>
        </xsl:for-each>
          <tr>
            <th>total</th>
            <xsl:for-each
select="item/pivotrow[generate-id(.)=generate-id(key('b',.)[1])]">
              <xsl:sort select="."/>
              <xsl:variable name="vpivotrow" select="."/>
              <td>
                <xsl:value-of
select="sum(../../item[pivotrow=$vpivotrow]/TOTALS)"/>
              </td>
            </xsl:for-each>
            <td><xsl:value-of select="sum(item/TOTALS)"/></td>
          </tr>
      </table>
</xsl:for-each>

<xsl:for-each select="pivot2">
      <table border="1" cellspacing="0" class="stn">
          <tr>
            <th>*</th>
            <xsl:for-each select="item/pivotrow">
              <xsl:sort select="."/>
              <xsl:variable name="vpivotrow" select="."/>
              <th>
                <xsl:value-of select="."/>
              </th>
            </xsl:for-each>
            <th>total</th>
          </tr>
        <xsl:for-each
select="item/pivotcol[generate-id(.)=generate-id(key('c',.)[1])]">
          <xsl:sort select="."/>
          <xsl:variable name="vpivotcol" select="."/>
          <tr>
            <th><xsl:value-of select="."/></th>
            <xsl:for-each
select="../../item/pivotrow[generate-id(.)=generate-id(key('b',.)[1])]">
              <xsl:variable name="vpivotrow" select="."/>
              <td>
                <xsl:if test="not(../../item[pivotcol=$vpivotcol and
pivotrow=$vpivotrow])">-</xsl:if>
                <xsl:if test="../../item[pivotcol=$vpivotcol and
pivotrow=$vpivotrow]"><xsl:value-of
select="../../item[pivotcol=$vpivotcol and
pivotrow=$vpivotrow]/TOTALS"/></xsl:if>
              </td>
            </xsl:for-each>
            <td><xsl:value-of
select="sum(../../item[pivotcol=$vpivotcol]/TOTALS)"/></td>
          </tr>
        </xsl:for-each>
          <tr>
            <th>total</th>
            <xsl:for-each
select="item/pivotrow[generate-id(.)=generate-id(key('b',.)[1])]">
              <xsl:sort select="."/>
              <xsl:variable name="vpivotrow" select="."/>
              <td>
                <xsl:value-of
select="sum(../../item[pivotrow=$vpivotrow]/TOTALS)"/>
              </td>
            </xsl:for-each>
            <td><xsl:value-of select="sum(item/TOTALS)"/></td>
          </tr>
      </table>
</xsl:for-each>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

In result i have right view of first table, in second table i have only
columns and rows which not exists in first table etc.

Seems I have version 1.0

Abel Braaksma wrote:
> Vitaliy Paykov wrote:
>> I need xsl template for crosstab building.
>>
>> But not for one table, i need several crosstabs in one xsl template.
>>
>> My XML:
>
> Where is your XSLT that you've got so far and where did you get stuck?
> What is the XSLT version you use?
>
> -- Abel
>
>


-- */Best regards, Vitaliy Paykov/* e-mail: vpay@xxxxxxxxx ext: 1120 ICQ: 220022522 */ISD QA/*




--
*/Best regards,
Vitaliy Paykov/*
e-mail: vpay@xxxxxxxxx
ext: 1120
ICQ: 220022522
*/ISD QA/*

Current Thread