Column Graph

Many time it is desirable to display a simple column graph rather than utilizing a full blown graph package. In that case, just specify what type of column graph and the method to obtain the scale of the data, the numeric column will be replaced by a bar graph. Specify a 'rainbow' option will even make is more colorful.

Colgraph with Rainbow Bars

<!--T_ColGraph.aspx-->

<script language="vb" runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
Dim CGraph as New Tornado.Z()
   With CGraph
      .dbQP="U=13| M=g| S=Finance| PS=10| D=Nwind.Mdb| Gdf=0,1,2| Th=tit=Column Graph"
      .dbColGraph = "(#!)field=Freight| width=300| height=12| icon=rainbow| style=8| minmaxsql=SELECT min(Freight), Max(Freight) From Orders"
      .dbSQL = "Select Orderid, CustomerID, Freight From Orders WHERE Freight > 0 ORDER BY Freight DESC"
      .ASPdbNET()
   End With
End Sub
</script>

In this example, we specified The field to process, size of bar, color, style and the method we have chosen to provide the minimum and maximum is via an SQL. Not a whole lot of work for a very colorful presentation.