I have below xslt file and want to implement code for altenet color row.

I'm implementing below code, but it will color out coloumns and not the rows.

I think I'm applying style on <TableCells>...where need to put code..please help..thnx

<xsl:if test="position() mod 2 = 1">
							<BackgroundColor>#e0e0e0</BackgroundColor>
						</xsl:if>
						<xsl:if test="position() mod 2 = 0">
							<BackgroundColor>blue</BackgroundColor>
						</xsl:if>

and here the xslt....

<?xml version="1.0"?>
<!-- Stylesheet for creating ReportViewer RDLC documents -->
<xsl:stylesheet version="1.0"  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"  xmlns:msxsl="urn:schemas-microsoft-com:xslt"  xmlns:xs="http://www.w3.org/2001/XMLSchema"  xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"  xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"  xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"  >
	<xsl:variable name="mvarName" select="/xs:schema/@Name"/>
	<xsl:variable name="mvarFontSize">8pt</xsl:variable>
	<xsl:variable name="mvarFontWeight">500</xsl:variable>
	<xsl:variable name="mvarFontWeightBold">700</xsl:variable>

	<xsl:template match="/">
		<xsl:apply-templates select="/xs:schema/xs:element/xs:complexType/xs:choice/xs:element/xs:complexType/xs:sequence">  </xsl:apply-templates>
	</xsl:template>
	<xsl:template match="xs:sequence">
		<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition">
			<BottomMargin>1in</BottomMargin>
			<RightMargin>1in</RightMargin>
			<LeftMargin>1in</LeftMargin>
			<TopMargin>1in</TopMargin>
			<InteractiveHeight>11in</InteractiveHeight>
			<InteractiveWidth>8.5in</InteractiveWidth>
			<Width>6.5in</Width>
			<Language>en-US</Language>
			<rd:DrawGrid>true</rd:DrawGrid>
			<rd:SnapToGrid>true</rd:SnapToGrid>
			<rd:ReportID>7358b654-3ca3-44a0-8677-efe0a55c7c45</rd:ReportID>
			<xsl:call-template name="BuildDataSource">   </xsl:call-template>
			<xsl:call-template name="BuildDataSet">   </xsl:call-template>
			<Body>
				<Height>0.50in</Height>
				<ReportItems>
					<Table Name="table1">
						<DataSetName>
							<xsl:value-of select="$mvarName" />
						</DataSetName>
						<Top>0.5in</Top>
						<Height>0.50in</Height>
						<Header>
							<TableRows>
								<TableRow>
									<Height>0.25in</Height>
									<TableCells>
										<xsl:apply-templates select="xs:element" mode="HeaderTableCell"></xsl:apply-templates>
									</TableCells>
								</TableRow>
							</TableRows>
						</Header>
						<Details>
							<TableRows>
								<TableRow>
									<Height>0.25in</Height>
									<TableCells>
										<xsl:apply-templates select="xs:element" mode="DetailTableCell"></xsl:apply-templates>
									</TableCells>
								</TableRow>
							</TableRows>
						</Details>
						<TableColumns>
							<xsl:apply-templates select="xs:element" mode="TableColumn"></xsl:apply-templates>
						</TableColumns>
					</Table>
				</ReportItems>

			</Body>
		</Report>
	</xsl:template>
	<xsl:template name="BuildDataSource">
		<DataSources>
			<DataSource Name="DummyDataSource">
				<ConnectionProperties>
					<ConnectString/>
					<DataProvider>SQL</DataProvider>
				</ConnectionProperties>
				<rd:DataSourceID>84635ff8-d177-4a25-9aa5-5a921652c79c</rd:DataSourceID>
			</DataSource>
		</DataSources>
	</xsl:template>
	<xsl:template name="BuildDataSet">
		<DataSets>
			<DataSet Name="{$mvarName}">
				<Query>
					<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
					<CommandText/>
					<DataSourceName>DummyDataSource</DataSourceName>
				</Query>
				<Fields>
					<xsl:apply-templates select="xs:element" mode="Field">     </xsl:apply-templates>
				</Fields>
			</DataSet>
		</DataSets>
	</xsl:template>
	<xsl:template match="xs:element" mode="Field">
		<xsl:variable name="varFieldName">
			<xsl:value-of select="@name" />
		</xsl:variable>
		<xsl:variable name="varDataType">
			<xsl:choose>
				<xsl:when test="@type='xs:int'">System.Int32</xsl:when>
				<xsl:when test="@type='xs:string'">System.String</xsl:when>
				<xsl:when test="@type='xs:dateTime'">System.DateTime</xsl:when>
				<xsl:when test="@type='xs:boolean'">System.Boolean</xsl:when>
			</xsl:choose>
		</xsl:variable>
		<Field Name="{$varFieldName}">
			<rd:TypeName>
				<xsl:value-of select="$varDataType"/>
			</rd:TypeName>
			<DataField>
				<xsl:value-of select="$varFieldName"/>
			</DataField>
		</Field>
	</xsl:template>
	<xsl:template match="xs:element" mode="HeaderTableCell">
		<xsl:variable name="varFieldName">
			<xsl:value-of select="@name" />
		</xsl:variable>
		<TableCell>
			<ReportItems>
				<Textbox Name="textbox{position()}">
					<rd:DefaultName>
						textbox<xsl:value-of select="position()"/>
					</rd:DefaultName>
					<Value>
						<xsl:value-of select="$varFieldName"/>
					</Value>
					<CanGrow>true</CanGrow>
					<ZIndex>7</ZIndex>
					<Style>
						<TextAlign>Center</TextAlign>
						<PaddingLeft>2pt</PaddingLeft>
						<PaddingBottom>2pt</PaddingBottom>
						<PaddingRight>2pt</PaddingRight>
						<PaddingTop>2pt</PaddingTop>
						<FontSize>
							<xsl:value-of select="$mvarFontSize"/>
						</FontSize>
						<FontWeight>
							<xsl:value-of select="$mvarFontWeightBold"/>
						</FontWeight>
						<BackgroundColor>#000000</BackgroundColor>
						<Color>#ffffff</Color>
						<BorderColor>
							<Default>#ffffff</Default>
						</BorderColor>
						<BorderStyle>
							<Default>Solid</Default>
						</BorderStyle>
					</Style>
					<UserSort>
					<SortExpression>
						=Fields!<xsl:value-of select="$varFieldName"/>.Value
					</SortExpression>
					</UserSort>
				</Textbox>
			</ReportItems>
		</TableCell>
	</xsl:template>

	
	<xsl:template match="xs:element" mode="DetailTableCell">
		<xsl:variable name="varFieldName">
			<xsl:value-of select="@name" />
		</xsl:variable>
		<TableCell>
			<ReportItems>
				<Textbox Name="{$varFieldName}">
					<rd:DefaultName>
						<xsl:value-of select="$varFieldName"/>
					</rd:DefaultName>
					<Value>
						=Fields!<xsl:value-of select="$varFieldName"/>.Value
					</Value>
					<CanGrow>true</CanGrow>
					<ZIndex>7</ZIndex>
					<Style>
						<TextAlign>Left</TextAlign>
						<PaddingLeft>2pt</PaddingLeft>
						<PaddingBottom>2pt</PaddingBottom>
						<PaddingRight>2pt</PaddingRight>
						<PaddingTop>2pt</PaddingTop>
						<FontSize>
							<xsl:value-of select="$mvarFontSize"/>
						</FontSize>
						<FontWeight>
							<xsl:value-of select="$mvarFontWeight"/>
						</FontWeight>

						[B]<!-- comment by Ajmal-->
						<!-- <BackgroundColor>#e0e0e0</BackgroundColor>-->

						<xsl:if test="position() mod 2 = 1">
							<BackgroundColor>#e0e0e0</BackgroundColor>
						</xsl:if>
						<xsl:if test="position() mod 2 = 0">
							<BackgroundColor>blue</BackgroundColor>
						</xsl:if>[/B]						
						<Color>#000000</Color>
						<BorderColor>
							<Default>#ffffff</Default>
						</BorderColor>
						<BorderStyle>
							<Default>Solid</Default>
						</BorderStyle>
					</Style>
				</Textbox>
			</ReportItems>
		</TableCell>
		
	</xsl:template>
	<xsl:template match="xs:element" mode="TableColumn">
		<TableColumn>
			<Width>0.75in</Width>
			
		</TableColumn>
	
		
	</xsl:template>
	<xsl:template name="replace-string">
		<xsl:param name="text"/>
		<xsl:param name="from"/>
		<xsl:param name="to"/>
		<xsl:choose>
			<xsl:when test="contains($text, $from)">
				<xsl:variable name="before" select="substring-before($text, $from)"/>
				<xsl:variable name="after" select="substring-after($text, $from)"/>
				<xsl:variable name="prefix" select="concat($before, $to)"/>
				<xsl:value-of select="$before"/>
				<xsl:value-of select="$to"/>
				<xsl:call-template name="replace-string">
					<xsl:with-param name="text" select="$after"/>
					<xsl:with-param name="from" select="$from"/>
					<xsl:with-param name="to" select="$to"/>
				</xsl:call-template>
			</xsl:when>
			<xsl:otherwise>
				<xsl:value-of select="$text"/>
			</xsl:otherwise>
		</xsl:choose>

	</xsl:template>



</xsl:stylesheet>

you are in the table cell

<?xml version="1.0"?>
<!-- Stylesheet for creating ReportViewer RDLC documents -->
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
                xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition">
	<xsl:variable name="mvarName" select="/xs:schema/@Name"/>
	<xsl:variable name="mvarFontSize">8pt</xsl:variable>
	<xsl:variable name="mvarFontWeight">500</xsl:variable>
	<xsl:variable name="mvarFontWeightBold">700</xsl:variable>

	<xsl:template match="/">
		<xsl:apply-templates select="/xs:schema/xs:element/xs:complexType/xs:choice/xs:element/xs:complexType/xs:sequence">
		</xsl:apply-templates>
	</xsl:template>
	<xsl:template match="xs:sequence">
		<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition">
			<BottomMargin>1in</BottomMargin>
			<RightMargin>1in</RightMargin>
			<LeftMargin>1in</LeftMargin>
			<TopMargin>1in</TopMargin>
			<InteractiveHeight>11in</InteractiveHeight>
			<InteractiveWidth>8.5in</InteractiveWidth>
			<Width>6.5in</Width>
			<Language>en-US</Language>
			<rd:DrawGrid>true</rd:DrawGrid>
			<rd:SnapToGrid>true</rd:SnapToGrid>
			<rd:ReportID>7358b654-3ca3-44a0-8677-efe0a55c7c45</rd:ReportID>
			<xsl:call-template name="BuildDataSource">
			</xsl:call-template>
			<xsl:call-template name="BuildDataSet">
			</xsl:call-template>
			<Body>
				<Height>0.50in</Height>
				<ReportItems>
					<Table Name="table1">
						<DataSetName>
							<xsl:value-of select="$mvarName"/>
						</DataSetName>
						<Top>0.5in</Top>
						<Height>0.50in</Height>
						<Header>
							<TableRows>
								<TableRow>
									<Height>0.25in</Height>
									<TableCells>
										<xsl:apply-templates select="xs:element" mode="HeaderTableCell"></xsl:apply-templates>
									</TableCells>
								</TableRow>
							</TableRows>
						</Header>
						<Details>
							<TableRows>
								<TableRow>
									<Height>0.25in</Height>
									<!-- here are row -->
									<!-- comment by Ajmal-->
									<!-- <BackgroundColor>#e0e0e0</BackgroundColor>-->
									<!--
									<xsl:if test="position() mod 2 = 1">
										<BackgroundColor>#e0e0e0</BackgroundColor>
									</xsl:if>
									<xsl:if test="position() mod 2 = 0">
									<BackgroundColor>blue</BackgroundColor>
									</xsl:if>
									-->
									<xsl:choose>
										<xsl:when test="position() mod 2 = 1">
											<BackgroundColor>#e0e0e0</BackgroundColor>
										</xsl:when>
										<xsl:otherwise>
											<BackgroundColor>blue</BackgroundColor>
										</xsl:otherwise>
									</xsl:choose>
									<TableCells>
										<xsl:apply-templates select="xs:element" mode="DetailTableCell"></xsl:apply-templates>
									</TableCells>
								</TableRow>
							</TableRows>
						</Details>
						<TableColumns>
							<xsl:apply-templates select="xs:element" mode="TableColumn"></xsl:apply-templates>
						</TableColumns>
					</Table>
				</ReportItems>
			</Body>
		</Report>
	</xsl:template>
	<xsl:template name="BuildDataSource">
		<DataSources>
			<DataSource Name="DummyDataSource">
				<ConnectionProperties>
					<ConnectString/>
					<DataProvider>SQL</DataProvider>
				</ConnectionProperties>
				<rd:DataSourceID>84635ff8-d177-4a25-9aa5-5a921652c79c</rd:DataSourceID>
			</DataSource>
		</DataSources>
	</xsl:template>
	<xsl:template name="BuildDataSet">
		<DataSets>
			<DataSet Name="{$mvarName}">
				<Query>
					<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
					<CommandText/>
					<DataSourceName>DummyDataSource</DataSourceName>
				</Query>
				<Fields>
					<xsl:apply-templates select="xs:element" mode="Field">
					</xsl:apply-templates>
				</Fields>
			</DataSet>
		</DataSets>
	</xsl:template>
	<xsl:template match="xs:element" mode="Field">
		<xsl:variable name="varFieldName">
			<xsl:value-of select="@name"/>
		</xsl:variable>
		<xsl:variable name="varDataType">
			<xsl:choose>
				<xsl:when test="@type='xs:int'">System.Int32</xsl:when>
				<xsl:when test="@type='xs:string'">System.String</xsl:when>
				<xsl:when test="@type='xs:dateTime'">System.DateTime</xsl:when>
				<xsl:when test="@type='xs:boolean'">System.Boolean</xsl:when>
			</xsl:choose>
		</xsl:variable>
		<Field Name="{$varFieldName}">
			<rd:TypeName>
				<xsl:value-of select="$varDataType"/>
			</rd:TypeName>
			<DataField>
				<xsl:value-of select="$varFieldName"/>
			</DataField>
		</Field>
	</xsl:template>
	<xsl:template match="xs:element" mode="HeaderTableCell">
		<xsl:variable name="varFieldName">
			<xsl:value-of select="@name"/>
		</xsl:variable>
		<TableCell>
			<ReportItems>
				<Textbox Name="textbox{position()}">
					<rd:DefaultName>textbox<xsl:value-of select="position()"/></rd:DefaultName>
					<Value>
						<xsl:value-of select="$varFieldName"/>
					</Value>
					<CanGrow>true</CanGrow>
					<ZIndex>7</ZIndex>
					<Style>
						<TextAlign>Center</TextAlign>
						<PaddingLeft>2pt</PaddingLeft>
						<PaddingBottom>2pt</PaddingBottom>
						<PaddingRight>2pt</PaddingRight>
						<PaddingTop>2pt</PaddingTop>
						<FontSize>
							<xsl:value-of select="$mvarFontSize"/>
						</FontSize>
						<FontWeight>
							<xsl:value-of select="$mvarFontWeightBold"/>
						</FontWeight>
						<BackgroundColor>#000000</BackgroundColor>
						<Color>#ffffff</Color>
						<BorderColor>
							<Default>#ffffff</Default>
						</BorderColor>
						<BorderStyle>
							<Default>Solid</Default>
						</BorderStyle>
					</Style>
					<UserSort>
						<SortExpression>=Fields!<xsl:value-of select="$varFieldName"/>.Value</SortExpression>
					</UserSort>
				</Textbox>
			</ReportItems>
		</TableCell>
	</xsl:template>


	<xsl:template match="xs:element" mode="DetailTableCell">
		<xsl:variable name="varFieldName">
			<xsl:value-of select="@name"/>
		</xsl:variable>
		<TableCell>
			<ReportItems>
				<Textbox Name="{$varFieldName}">
					<rd:DefaultName>
						<xsl:value-of select="$varFieldName"/>
					</rd:DefaultName>
					<Value>=Fields!<xsl:value-of select="$varFieldName"/>.Value</Value>
					<CanGrow>true</CanGrow>
					<ZIndex>7</ZIndex>
					<Style>
						<TextAlign>Left</TextAlign>
						<PaddingLeft>2pt</PaddingLeft>
						<PaddingBottom>2pt</PaddingBottom>
						<PaddingRight>2pt</PaddingRight>
						<PaddingTop>2pt</PaddingTop>
						<FontSize>
							<xsl:value-of select="$mvarFontSize"/>
						</FontSize>
						<FontWeight>
							<xsl:value-of select="$mvarFontWeight"/>
						</FontWeight>
						<!-- here are table cell -->
						<!-- comment by Ajmal-->
						<!-- <BackgroundColor>#e0e0e0</BackgroundColor>-->
						<!--
						<xsl:if test="position() mod 2 = 1">
							<BackgroundColor>#e0e0e0</BackgroundColor>
						</xsl:if>
						<xsl:if test="position() mod 2 = 0">
							<BackgroundColor>blue</BackgroundColor>
						</xsl:if>
						-->
						<Color>#000000</Color>
						<BorderColor>
							<Default>#ffffff</Default>
						</BorderColor>
						<BorderStyle>
							<Default>Solid</Default>
						</BorderStyle>
					</Style>
				</Textbox>
			</ReportItems>
		</TableCell>
	</xsl:template>
	<xsl:template match="xs:element" mode="TableColumn">
		<TableColumn>
			<Width>0.75in</Width>
		</TableColumn>
	</xsl:template>
	<xsl:template name="replace-string">
		<xsl:param name="text"/>
		<xsl:param name="from"/>
		<xsl:param name="to"/>
		<xsl:choose>
			<xsl:when test="contains($text, $from)">
				<xsl:variable name="before" select="substring-before($text, $from)"/>
				<xsl:variable name="after" select="substring-after($text, $from)"/>
				<xsl:variable name="prefix" select="concat($before, $to)"/>
				<xsl:value-of select="$before"/>
				<xsl:value-of select="$to"/>
				<xsl:call-template name="replace-string">
					<xsl:with-param name="text" select="$after"/>
					<xsl:with-param name="from" select="$from"/>
					<xsl:with-param name="to" select="$to"/>
				</xsl:call-template>
			</xsl:when>
			<xsl:otherwise>
				<xsl:value-of select="$text"/>
			</xsl:otherwise>
		</xsl:choose>
	</xsl:template>
</xsl:stylesheet>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.