Hi my name is adam, I got your email address from the google search. I hpoe you
do not mind me contacting you directly.But I need help with some xslt.
I am constructing a table, Each GridBody0 - GridBody n
node set represents a single row of the table.Each Gridbody tag included a
number of Col0 - Col n tags
these represent each cell of the row.
The problem is that each cell that is rendered must be conditionally
formatted.Tags that need to be formatted are
include within the gridcolors section of the xml document.
<Grid0Row0Col3LimeGreen>1</Grid0Row0Col3LimeGreen>
The idea is to use a for-each loop to go through each
set of gridbody tags to render them. As I do this I
want to construct a path query to determine if the current cell is turned green
<Grid0Row0Col3LimeGreen> if this exist then green.
The question is how
xslt
<xsl:for-each select="Reports/GridBody0">
<xsl:if test="Col3 != ''" >
<xsl:variable name="rowNo"
select="concat('../GridColors/Grid0RowNo',RowNo,'Col3LimeGreen')"></xsl:variable>
<xsl:choose>
<!--If this element exist and we have to render green-->
<xsl:when test="$rowNo = 1" >-->
<td align="right" width="60" bordercolor="DarkGray"
border="1" bgcolor="LimeGreen">
<font style='FONT-WEIGHT: normal;Font-Size:XX-Small;
COLOR: Black; FONT-FAMILY:Verdana'>
<xsl:value-of
select="format-number(Col3,'#,##0.#')"></xsl:value-of>
</font>
</td>
</xsl:when>
<!--etc-->
</xsl:for-each>
Xml
<Reports>
<GridColors>
<Grid0Row0Col3LimeGreen>1</Grid0Row0Col3LimeGreen>
<Grid0Row1Col3LimeGreen>1</Grid0Row1Col3LimeGreen>
</GridColors>
<GridBody0>
<MemberUniqueName>[Product].[All Products].[Consumer
Electronics]</MemberUniqueName>
<MemberCaption>Consumer Electronics</MemberCaption>
<RowNo>0</RowNo>
<Col0>13458.26555</Col0>
<Col1>9952.06343</Col1>
<Col2>14633.765640000001</Col2>
<Col3>35.230906079544546</Col3>
<Col4>-8.032792918227992</Col4>
</GridBody0>
<GridBody0>
<MemberUniqueName>[Product].[All Products].[Domestic
Whiteware]</MemberUniqueName>
<MemberCaption>Domestic Whiteware</MemberCaption>
<RowNo>1</RowNo>
<Col0>2983.95073</Col0>
<Col1>2632.35801</Col1>
<Col2>3400.7199100000003</Col2>
<Col3>13.356569230490049</Col3>
<Col4>-12.25532213854096</Col4>
</GridBody0>
</Reports>
<%@ OutputCache Duration="60" VaryByParam="none"%>