sireesha g 0 Newbie Poster

Hi All,

i have an XML

<?xml version="1.0" encoding="UTF-8" ?> 
<Rowsets DateCreated="2011-02-14T12:24:00" EndDate="2011-02-14T12:24:00" StartDate="2011-02-14T11:24:00" Version="12.0.2 Build(88)">
	<Rowset>
		<Columns>
			<Column Description="BatchNumber" MaxRange="1" MinRange="0" Name="BatchNumber" SQLDataType="12" SourceColumn="BatchNumber" /> 
			<Column Description="VersionCode" MaxRange="1" MinRange="0" Name="VersionCode" SQLDataType="3" SourceColumn="VersionCode" /> 
			<Column Description="MaterialType" MaxRange="1" MinRange="0" Name="MaterialType" SQLDataType="12" SourceColumn="MaterialType" /> 
			<Column Description="LotNumber" MaxRange="1" MinRange="0" Name="LotNumber" SQLDataType="4" SourceColumn="LotNumber" /> 
			<Column Description="RRComplete" MaxRange="1" MinRange="0" Name="RRComplete" SQLDataType="-6" SourceColumn="RRComplete" /> 
			<Column Description="ReviewerName" MaxRange="1" MinRange="0" Name="ReviewerName" SQLDataType="12" SourceColumn="ReviewerName" /> 
			<Column Description="ReviewStartDate" MaxRange="1" MinRange="0" Name="ReviewStartDate" SQLDataType="93" SourceColumn="ReviewStartDate" /> 
			<Column Description="ReviewEndDate" MaxRange="1" MinRange="0" Name="ReviewEndDate" SQLDataType="93" SourceColumn="ReviewEndDate" /> 
			<Column Description="ProjectedEndDate" MaxRange="1" MinRange="0" Name="ProjectedEndDate" SQLDataType="93" SourceColumn="ProjectedEndDate" /> 
			<Column Description="DispositionerName" MaxRange="1" MinRange="0" Name="DispositionerName" SQLDataType="12" SourceColumn="DispositionerName" /> 
			<Column Description="ReceiptDate" MaxRange="1" MinRange="0" Name="ReceiptDate" SQLDataType="93" SourceColumn="ReceiptDate" /> 
			<Column Description="TargetDispositionDate" MaxRange="1" MinRange="0" Name="TargetDispositionDate" SQLDataType="93" SourceColumn="TargetDispositionDate" /> 
			<Column Description="DRComplete" MaxRange="1" MinRange="0" Name="DRComplete" SQLDataType="-6" SourceColumn="DRComplete" /> 
			<Column Description="DispositionedDate" MaxRange="1" MinRange="0" Name="DispositionedDate" SQLDataType="93" SourceColumn="DispositionedDate" /> 
			<Column Description="RecommendedUsageDecision" MaxRange="1" MinRange="0" Name="RecommendedUsageDecision" SQLDataType="12" SourceColumn="RecommendedUsageDecision" /> 
			<Column Description="FinalUsageDecision" MaxRange="1" MinRange="0" Name="FinalUsageDecision" SQLDataType="12" SourceColumn="FinalUsageDecision" /> 
			<Column Description="BatchStatus" MaxRange="1" MinRange="0" Name="BatchStatus" SQLDataType="12" SourceColumn="BatchStatus" /> 
			<Column Description="StockType" MaxRange="1" MinRange="0" Name="StockType" SQLDataType="12" SourceColumn="StockType" /> 
			<Column Description="Plant" MaxRange="1" MinRange="0" Name="Plant" SQLDataType="12" SourceColumn="Plant" /> 
			<Column Description="MaterialNumber" MaxRange="1" MinRange="0" Name="MaterialNumber" SQLDataType="12" SourceColumn="MaterialNumber" /> 
			<Column Description="MaterialDescription" MaxRange="1" MinRange="0" Name="MaterialDescription" SQLDataType="-1" SourceColumn="MaterialDescription" /> 
			<Column Description="DateOfManufacture" MaxRange="1" MinRange="0" Name="DateOfManufacture" SQLDataType="93" SourceColumn="DateOfManufacture" /> 
			<Column Description="ExpiryDate" MaxRange="1" MinRange="0" Name="ExpiryDate" SQLDataType="93" SourceColumn="ExpiryDate" /> 
			<Column Description="QuantityManufactured" MaxRange="1" MinRange="0" Name="QuantityManufactured" SQLDataType="12" SourceColumn="QuantityManufactured" /> 
			<Column Description="BatchComments" MaxRange="1" MinRange="0" Name="BatchComments" SQLDataType="-1" SourceColumn="BatchComments" /> 
		</Columns>
	<Row>
		<BatchNumber>A12345</BatchNumber> 
		<VersionCode>1</VersionCode> 
		<MaterialType>Raw</MaterialType> 
		<LotNumber>12345</LotNumber> 
		<RRComplete>0</RRComplete> 
		<ReviewerName>ankit</ReviewerName> 
		<ReviewStartDate>2011-02-08T00:00:00</ReviewStartDate> 
		<ReviewEndDate>2011-02-15T00:00:00</ReviewEndDate> 
		<ProjectedEndDate>TimeUnavailable</ProjectedEndDate> 
		<DispositionerName>ankit</DispositionerName> 
		<ReceiptDate>2011-02-01T00:00:00</ReceiptDate> 
		<TargetDispositionDate>2011-06-11T00:00:00</TargetDispositionDate> 
		<DRComplete>0</DRComplete> 
		<DispositionedDate>TimeUnavailable</DispositionedDate> 
		<RecommendedUsageDecision>---</RecommendedUsageDecision> 
		<FinalUsageDecision>---</FinalUsageDecision> 
		<BatchStatus>---</BatchStatus> 
		<StockType>---</StockType> 
		<Plant>PR12</Plant> 
		<MaterialNumber>A00003434</MaterialNumber> 
		<MaterialDescription>No breaks</MaterialDescription> 
		<DateOfManufacture>2010-12-02T00:00:00</DateOfManufacture> 
		<ExpiryDate>1930-03-05T00:00:00</ExpiryDate> 
		<QuantityManufactured>69.3454LT</QuantityManufactured> 
		<BatchComments>---</BatchComments> 
	</Row>
	</Rowset>
</Rowsets>

and i ahve written an xsl

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:java="http://xml.apache.org/xslt/java" exclude-result-prefixes="java">
<xsl:template match="/">
    <xsl:apply-templates select="Rowsets/Rowset"/>
</xsl:template>
<xsl:template match="Rowsets/Rowset">
<html>
<head>
<title> In Process Batch Details </title>
<style>
* {
    font: 8pt verdana;
}
BODY {
  /* Scrollbar setting */
	scrollbar-base-color:#3B5E94;
	scrollbar-arrow-color:#2F3B47;
	scrollbar-darkshadow-color:#45637F;
	scrollbar-face-color:#DDE9F5;
	scrollbar-highlight-color:#EBFCFF;
	scrollbar-shadow-color:#A1BDCB;
	scrollbar-track-color:#BBD1E8;
  /* Border Setting */
	padding: 0px; 
	margin:0px;
  /*Background filter makes problems when scrolling applets and selects*/
	background-color:	#F6F7FB
}
TABLE{
	margin: 0;
	padding: 0;
}
.ContentHeaderSection {
	border:1px solid #98B1CB;
	border-top:1px solid #DFE9F1;
	background-color: #BAD2E8;
	padding: 5px;
}
.ContentSubTitleBar { 
	height: 20px;
	border:1px solid #98B1CB;
	border-top:1px solid #DFE9F1;
	background-color: #BAD2E8;
	/* OLD: startColorStr=#A8C7E2,endColorStr=#BAD2E8 */
	FILTER: progid:DXImageTransform.Microsoft.Gradient(gradientType=0,startColorStr=#EAF1F6,endColorStr=#BAD2E8);
	padding: 5px;
	padding-top: 1px;
	padding-bottom: 0px;
}
.ContentSubTitle {
	color: #000000;
	font-weight: bold;
          text-decoration: underline;
}
</style>
</head>
<body>
<table cellpadding="0" cellspacing="0" width="100%" height="100%" border="2" class="ContentHeaderSection" >
<tr>
<td>
	<table width="60%" height="60%" class="Content" cellspacing="1" cellpadding="4" bordercolor="#FFFFFF" border="2" align="center" style="margin-top:120px;">
		<tr>
			<th colspan="2" class="ContentSubTitleBar ContentSubTitle">In Process Batch Details
			</th>
			
		</tr>
		<tr>
			<td>
				<xsl:for-each select="Columns/Column">
				<tr>
					<td><xsl:value-of select="@Name"/></td>
					<xsl:variable name="BatchDetails" select="@Name" />
					<td><xsl:value-of select="../../Row/*[local-name()=$BatchDetails]"/></td>
				</tr>
				</xsl:for-each>

			</td>
		</tr>
	</table>
</td>
</tr>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>

Now i need a page break for every 5 records and a header and footer in every page.
Can any one tell me how to achieve this using xslt please.

Be a part of the DaniWeb community

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