Column Chart

OrderIDUnitPriceQty
10277 75.8 32
10329 269.2 50
10337 95.9 137
10338 51.9 35
10348 21.6 40
10349 5.9 24
10353 227.6 62
10356 58 62
10357 76.9 54
10358 30 40

bottom next goreload

[1 - 10 : 1804]

Column Chart
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
  Dim Col As New Tornado.z
  With Col
    .dbQP = "U=25| D=nwind| S=18| PS=10| M=Gc"
    .dbSQL = "SELECT OrderID, sum(UnitPrice) as UnitPrice, sum(Quantity) as Qty from [Order details] Group by OrderId"
    .dbChartParams = "xAxisLabelAngle=45|yAxisTitle=My Y-Axis Title| xAxisTitle=My X-Axis Title| yAxisOptions=rotateTitle=true"
    .dbColumnChart = "Legend=t| Label=#0#| DataSet0=#1#| DataSet1=#2#| DataSet2=27,59,51,95,92,67,100,37,56,111"
    .dbTextHolder = "Title=Column Chart"
    .ASPdbNET()
  End With
End Sub
</script>
Simplified ColumnChart - Just specify the dbColumnChart and override default parameters with dbChartParams. This example has 2 DB and 1 user column.

Send comments on this topic.
Copyright (c) 1998-2006 ASP-db