生成的图表怎么将实际人数和人天统计隐藏呢?
Dim nd As WinForm.RadioButton = e.Form.Controls("按年度统计") '如果是按年
If nd.Checked = True Then
'---------------------------------生成统计表------------------
Dim g As New CrossTableBuilder("统计表1", DataTables("课程信息"))
g.HGroups.AddDef("培训时间", DateGroupEnum.Year, "年")
g.VGroups.AddDef("课程")
g.Totals.AddDef("实际人数", "实际人数")
g.Totals.AddDef("人天统计", "人天统计")
g.VerticalProportion = True
g.VerticalProporti '论坛有Bug ,请将[g.VerticalProportion Caption]间的空格去掉
g.Build()
'-----------------------------------生成图表----------------------
Dim Chart As WinForm.Chart '定义一个图表变量
Dim Series As WinForm.ChartSeries '定义一个图系变量
Dim t As Table = Tables("统计表1") '定义一个变量t引用数据表
Chart = e.Form.Controls("Chart1") ' 引用窗口中的图表
Chart.SeriesList.Clear()
Chart.ChartType = ChartTypeEnum.Bar '图表类型改为Bar(条形)
Chart.DataSource = "统计表1" '设置绑定表
chart.AxisX.Major = 1
Chart.AxisY.Major = 100
Chart.AxisY.Min = 0 '指定Y轴的最小值
For Each c As Col In t.Cols
If c.Caption.Contains("实际人数/") Then
c.Visible = False
End If
c.DataCol.SetFormat("#,###")
Next
For Each r As Row In t.Rows
For Each c As Col In t.Cols
If c.Caption.Contains("人天统计/") Then
r(c.name) =t(r.Index,c.Index-1)/t(r.Index,c.Index-3)
End If
Next
Next
'Tables("统计表1").Cols("实际人数").Visible = False
' Tables("统计表1").Cols("人天统计").Visible = False
For Each c As Col In t.Cols
If c.Name <> "年" Then
If c.Visible = True Then
Series = Chart.SeriesList.Add() '增加一个图系
Series.Text = c.Caption 'Name '设置图系的标题
Series.X.DataField = "年" 'X轴绑定到产品列
Series.Y.DataField = c.Name '设置Y轴的绑定列
Series.DataLabelText = "{#YVAL}"
End If
End If
Next
Chart.LegendVisible = True '显示图列
Chart.LegendCompass= CompassEnum.South '图列显示在南方(底端)
ChaRT.HeaderText = "课程分析-人天统计"
Chart.AxisX.Text = "年份"
Else
Dim nf As WinForm.ComboBox = e.Form.Controls("选择年份")
nf.Enabled = True
nf.Value = "选择年份"
End If
加好友 
发短信
Post By：2013/4/2 11:20:00 [显示全部帖子]
