Include the Javascript library file

Client-side script

window.onload = initGrid
var dbnetgrid1
//////////////////////////////////////////////////////////////////////////////////////////////
function initGrid()
//////////////////////////////////////////////////////////////////////////////////////////////
{
	dbnetgrid1 = new DbNetGrid("dbnetgrid1")

with (dbnetgrid1)
	{
		fromPart = "[order details] left outer join products on products.productid = [order details].productid"
		connectionString = "samples"
		selectPart = ['products.productid','count(*) as mycount']
		headings = ['Product','Items']

searchColumns = ['products.productid', 'categoryid']
		searchLabels = ['Product', 'Category']

setSearchColumnProperty("products.productid","searchLookup:select productid, productname from products")

orderColumn = '2'

setColumnLookup('productid','productid','productname','products')

filterPart = "categoryid = 1"
		chart = true
		groupBy = "products.productid"
		having = "count(*) > 5"

setChartDocumentMode()

loadData()
	}
}

//////////////////////////////////////////////////////////////////////////////////////////////
function setChartDocumentMode()
//////////////////////////////////////////////////////////////////////////////////////////////
{
	with (dbnetgrid1)
	{
		chartDocument = document.getElementById("chartMode").value

switch (chartDocument)
		{
			case "bar_chart.xls":
			case "pie_chart.xls":
				chartDocument = virtualDir + "office/samples/" + chartDocument
		}

}
}

Include the Javascript library file

Client-side script

HTML