Dim tb As Table = Tables("业务管理_客户明细表")
Dim prs As Integer = 20 '每页20行
For p As Integer = 0 To math.Ceiling(tb.Rows.Count / prs) - 1
Dim rt As New prt.RenderTable
rt.Style.Gridlines.All = New prt.Linedef(Color.Gray)
rt.CellStyle.Spacing.All = 0.5
rt.Width = "Auto" '表格宽度为自动,也就是等于各列设置宽度之和
tb.CreateReportHeader(rt,False) '生成多层表头
For c As Integer = 0 To tb.Cols.Count - 1
For r As Integer = p * prs To math.min(tb.Rows.Count - 1 ,( p + 1) * prs - 1)
rt.Cells(r - p * prs + tb.HeaderRows, c).Text = tb.rows(r)(c)
If tb.rows(r)(c) <> 0
rt.Cells(r - p * prs + 1, c).Text = tb.rows(r)(c) '我把代码加入这里,提示错误,错误在代码下面
End If
If tb.Cols(c).IsNumeric
rt.Cells(r - p * prs + 2, c).Text = format(tb.rows(r)(c),"#,###.00")
rt.Cells(r - p * prs + 2, c).Style.TextAlignHorz = prt.AlignHorzEnum.Right
Else
rt.Cells(r - p * prs + 2, c).Text = tb.rows(r)(c)
End If
Next
Next
If p < math.Ceiling(tb.Rows.Count / prs) - 1
rt.BreakAfter = prt.BreakEnum.Page
End If
doc.Body.Children.Add(rt)
Next
doc.Preview()
.NET Framework 版本：4.0.30319.42000
Foxtable 版本：2020.5.29.8
错误所在事件：窗口,业务管理,Button7,Click
详细错误信息：
从字符串“”到类型“Double”的转换无效。
输入字符串的格式不正确。
蓝版,这个怎么修改
加好友 
发短信
Post By：2021/3/2 17:30:00 [只看该作者]
此主题相关图片如下：零值取消.png