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.