 |
|
|
I meant specifically for the test data you provided previously, what
is the desired output for that test data? If I copy and paste the
html result, this is what I see right now:
* Closed Closed Closed Closed Closed total
1.0.0.5 1 1
4.0.3.5 22 22
4.0.3.x 1 1
4.0.4.0 1 1
4.0.5.0 7 7
total 32 32
* Critical Non Critical Non Critical total
4.0.0.0 - 1 1
total 3 4 7
* Closed Closed Closed Closed Closed total
total 32
* Critical Non Critical Non Critical total
total 7
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:
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/*
|
|
| |
These Archives are provided for informational purposes only and have been generated directly from the Altova mailing list archive system and are comprised of the lists set forth on www.altova.com/list/index.html. Therefore, Altova does not warrant or guarantee the accuracy, reliability, completeness, usefulness, non-infringement of intellectual property rights, or quality of any content on the Altova Mailing List Archive(s), regardless of who originates that content. You expressly understand and agree that you bear all risks associated with using or relying on that content. Altova will not be liable or responsible in any way for any content posted including, but not limited to, any errors or omissions in content, or for any losses or damage of any kind incurred as a result of the use of or reliance on any content. This disclaimer and limitation on liability is in addition to the disclaimers and limitations contained in the Website Terms of Use and elsewhere on the site.
| |
| |
|
|
|
