Rico LiveGrid-Example 6

<%@ LANGUAGE="VBSCRIPT" %> Rico LiveGrid-Example 6 <% CreateDbClass sqltext="select CustomerID,ShipName," & oDB.SqlYear("ShippedDate") & " as yr,count(*) as cnt from orders group by CustomerID,ShipName," & oDB.SqlYear("ShippedDate") & " order by CustomerID" session.contents("ex6")=sqltext CloseApp %>

<% GridSettingsForm %>

This example shows how to apply a filter to the initial data set - even though that filter may change later. It also demonstrates an alternative way of formatting the headings and handling click events on them.

Count orders for: 1996 1997

Cust#	Ship Name	Year	Orders