ColumnFooter.SetAggregationType 无法显示聚合列(Expression) SUM 数据

收藏

dim T as New DataTable
T.Columns.Add("定员", GetType(Double))
T.Columns.Add("岗位津贴", GetType(Double))
T.Columns.Add("岗位津贴小计", GetType(Double), "ISNULL(岗位定员,0) * ISNULL(岗位津贴,0)")
FpSpread1_Sheet1 .DataSource=T
ColumnFooter.SetAggregationType(0,0,AggregationType.Sum)
ColumnFooter.SetAggregationType(0,1,AggregationType.Sum)
ColumnFooter.SetAggregationType(0,2,AggregationType.Sum)
ColumnFooter无法显示聚合列(Expression) 岗位津贴小计 SUM 数据 , 定员,岗位津贴正常显示

qinbinghao · qinbinghao

dim T as New DataTable
T.Columns.Add("定员", GetType(Double))
T.Columns.Add("岗位津贴", GetType(Double))
T.Columns.Add("岗位津贴小计", GetType(Double), "ISNULL(定员,0) * ISNULL(岗位津贴,0)")
FpSpread1_Sheet1 .DataSource=T
With FpSpread1_Sheet1
   .ColumnFooter.SetAggregationType(0,0,AggregationType.Sum)
   .ColumnFooter.SetAggregationType(0,1,AggregationType.Sum)
   .ColumnFooter.SetAggregationType(0,2,AggregationType.Sum)
End With
ColumnFooter无法显示聚合列(Expression) 岗位津贴小计 SUM 数据 , 定员,岗位津贴正常显示