The grid output created by the export, copy and print functions can be customised by merging with an HTML template file specified using the PrintTemplatePath, CopyTemplatePath and ExportTemplatePath properties. In addition custom parameters can be supplied using the OutputTemplateParameters property. Output can also be split up into pages using the PrintPageSize, CopyPageSize and ExportPageSize properties. The example also demonstrates use of the filterText property which contains a text representation of current query selected in the search dialog and passed as a parameter to the custom output templates

Report Title

Export Template

Page Size

Print Template

Page Size

Register the component libraries

Server Control

<form id="Form1" name="Form1" method="post" runat="server">
	<table>
		<tr>
			<td>
				<fieldset>
					<legend>Report Title</legend>
					<table>
						<tr>
							<td>
								<input id="report_title" value="Customers Report"></input>
							</td>
						</tr>
					</table>
				</fieldset>
			</td>
			<td>
				<fieldset>
					<legend>Export Template</legend>
					<table>
						<tr>
							<td>
								<select id=export_template onchange=assignTemplateInfo()>
									<option value="">No Template
									<option value="output_template_example_1.htm">Portrait
									<option value="output_template_example_2.htm">Landscape
									<option value="output_template_example_3.htm">Custom Heading
								</select>
							</td>
							<td>Page Size</td>
							<td>
								<select id=export_page_size onchange=assignTemplateInfo()>
									<option value=0>No paging
									<option value=20>20
									<option value=40>40
									<option value=60>60
								</select>
							</td>
						</tr>
					</table>
				</fieldset>
			</td>
			<td>
				<fieldset>
					<legend>Print Template</legend>
					<table>
						<tr>
							<td>
								<select id=print_template onchange=assignTemplateInfo()>
									<option value="">No Template
									<option value="output_template_example_1.htm">Portrait
									<option value="output_template_example_2.htm">Landscape
									<option value="output_template_example_3.htm">Custom Heading
								</select>
							</td>
							<td>Page Size</td>
							<td>
								<select id=print_page_size onchange=assignTemplateInfo()>
									<option value=0>No paging
									<option value=20>20
									<option value=40>40
									<option value=60>60
								</select>
							</td>
						</tr>
					</table>
				</fieldset>
			</td>
			<td id=copyTemplateSettings style="display:none">
				<fieldset>
					<legend>Copy Template</legend>
					<table>
						<tr>
							<td>
								<select id=copy_template onchange=assignTemplateInfo()>
									<option value="">No Template
									<option value="output_template_example_1.htm">Portrait
									<option value="output_template_example_2.htm">Landscape
									<option value="output_template_example_3.htm">Custom Heading
								</select>
							</td>
							<td>Page Size</td>
							<td>
								<select id=copy_page_size onchange=assignTemplateInfo()>
									<option value=0>No paging
									<option value=20>20
									<option value=40>40
									<option value=60>60
								</select>
							</td>
						</tr>
					</table>
				</fieldset>
			</td>
		</tr>
		<tr>
			<td colspan=3>
				<DNL:DbNetGrid 
					id="customers" 
					runat="server" 
					ConnectionString = "samples"
					FromPart = "customers"
					Headings = "Customer ID, Customer Name, Address, City, Region, Phone, Fax"
					SelectPart = "customerid, companyname, address, city, region, phone, fax"
					PrimaryKeyColumn = "customerid"
					EditRow = "false"
					OnBeforeGridSave = "assignParameter"
					OnBeforeGridCopy = "assignParameter"
					OnBeforeGridPrint = "assignParameter"
				>
				</DNL:DbNetGrid>
			</td>
		</tr>
	</table>
</form>

Client-side script

window.onload = initGrid
//////////////////////////////////////////////////////////////////////////////////////////////
function initGrid()
//////////////////////////////////////////////////////////////////////////////////////////////
{
	if ( dbNetLink.isIE )
		document.getElementById("copyTemplateSettings").style.display = ""
}

//////////////////////////////////////////////////////////////////////////////////////////////
function assignTemplateInfo()
//////////////////////////////////////////////////////////////////////////////////////////////
{
	var templateDir = window.DbNetGridArray["customers"].virtualDir + "samples/templates/"
	
	with (window.DbNetGridArray["customers"])
	{
		if ( document.getElementById("print_template").value != "" )
			printTemplatePath = templateDir + document.getElementById("print_template").value
		else
			printTemplatePath = ""

if ( document.getElementById("export_template").value != "" )
			exportTemplatePath = templateDir + document.getElementById("export_template").value
		else
			exportTemplatePath = ""

if ( document.getElementById("copy_template").value != "" )
			copyTemplatePath = templateDir + document.getElementById("copy_template").value
		else
			copyTemplatePath = ""

printPageSize = document.getElementById("print_page_size").value
		exportPageSize = document.getElementById("export_page_size").value
		copyPageSize = document.getElementById("copy_page_size").value
	}
}

//////////////////////////////////////////////////////////////////////////////////////////////
function assignParameter(grid)
//////////////////////////////////////////////////////////////////////////////////////////////
{
	with (grid)
	{
		outputTemplateParameters["query_filter"] = grid.filterText
		outputTemplateParameters["report_title"] = document.getElementById("report_title").value
	}
}