以文本方式查看主题 - Foxtable(狐表) (http://foxtable.net/bbs/index.asp) -- 专家坐堂 (http://foxtable.net/bbs/list.asp?boardid=2) ---- 专业报表-表格与统计打印行号列问题 (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=47364) |
-- 作者:mamuaiqing -- 发布时间:2014/3/8 23:03:00 -- 专业报表-表格与统计打印行号列问题 表格于统计代码如下: Dim doc As New PrintDocDim rx As New prt.RenderText Dim rt As New prt.RenderTable Dim Agg1 As New prt.DataBinding.Aggregate("数量小计") Dim Agg2 As New prt.DataBinding.Aggregate("金额小计") rt.Style.GridLines.All = New prt.Linedef(Color.Gray) rt.CellStyle.Spacing.All = 1 rt.Cells(0,0).Text = "产品" rt.Cells(0,1).Text = "数量" rt.Cells(0,2).Text = "金额" rt.Cells(1,0).Text = "[Fields!产品.Value]" rt.Cells(1,1).Text = "[Aggregates!数量小计.Value]" rt.Cells(1,2).Text = "[Aggregates!金额小计.Value]" With rt.RowGroups(1,1) .DataBinding.DataSource = BindTables("订单") .DataBinding.Grouping.Expressions.Add("Fields!产品.Value") agg1.DataBinding = .DataBinding agg1.Running = 1 agg1.ExpressionText = "Fields!数量.Value" doc.DataSchema.Aggregates.Add(agg1) agg2.DataBinding = .DataBinding agg2.Running = 1 agg2.ExpressionText = "Fields!金额.Value" doc.DataSchema.Aggregates.Add(agg2) End With doc.body.Children.Add(rt) doc.Preview()
rt.Cols.Insert(0) \'在左边插入一列,用于打印行号 |
-- 作者:有点酸 -- 发布时间:2014/3/9 23:38:00 -- 建议不绑定,直接编码逐行添加,比较好控制 |