Rss & SiteMap

Foxtable(狐表) http://www.foxtable.com

新一代数据库软件,完美融合Access、Foxpro、Excel、vb.net之优势,人人都能掌握的快速软件开发工具!
共6 条记录, 每页显示 10 条, 页签: [1]
[浏览完整版]

标题:专业报表填入数据

1楼
huangjingyu 发表于:2024/10/14 8:38:00
老师您好,专业报表中只填入选中的数据,代码该怎么修改呀,麻烦老师帮忙看一看
Dim doc As New PrintDoc '定义一个新报表
Dim rt As New prt.RenderTable '定义一个新表格
Dim rs As New prt.RenderText() '定义一个文本对象
Dim rss As New prt.RenderText()
Dim rs2 As New prt.RenderText()
Dim rs3 As New prt.RenderText()
Dim rs4 As New prt.RenderText()

Dim rt1 As New prt.RenderTable() '定义一个表格对象
doc.PageSetting.PaperKind = 9 '纸张A4
Doc.PageSetting.LeftMargin = 20 '设置左边距
Doc.PageSetting.RightMargin = 20 '设置右边距
Doc.PageSetting.TopMargin = 20 '设置上边距
Doc.PageSetting.BottomMargin = 20 '设置下边距

rt.Style.Spacing.Top = 3 '表格和前面对象的垂直间隔为1毫米
rt.Style.Spacing.Bottom = 1 '表和和后续对象的垂直间隔为1毫米
rs.Text = "维修单(存根)" '设置文本对象的内容
rs.y = 21
rs.Style.Font = New Font("黑体", 18) '设置文本对象的字体
rs.Style.TextAlignHorz = prt.AlignHorzEnum.Center '文本内容水平居中
doc.Body.Children.Add(rs) '将文本对象加入到表格中
doc.Body.Children.Add(rt1) '将表格对象加入到报表中


Dim sum As Double = 0
Dim tb As Table = Tables("维修结账") 
Dim Colnames As String() = {"编号", "维修地点", "维修时间", "维修项目", "维修费用"}
rt.Style.Font = tb.Font
rt.y = 28
rt.Style.Font = New Font("黑体", 11)
rt.Height = 80
rt.Cols(0).Width = 20 '设置列宽
rt.Cols(1).Width = 35
rt.Cols(2).Width = 20
rt.Cols(3).Width = 55
rt.Cols(4).Width = 20
rt.Cells(6, 1).SpanCols = 2 '第7行第1个单元格向右合并5列
rt.Cells(7, 1).SpanCols = 2 '第7行第1个单元格向右合并5列
rt.Style.TextAlignHorz = prt.AlignHorzEnum.Center '水平居中
rt.Style.TextAlignVert = prt.AlignVertEnum.Center '垂直居中


For c As Integer = 0 To Colnames.length - 1 '逐列设置和填入内容
    rt.Cells(0, c).Text = colnames(c) '列名作为标题
    rt.Cells(0, c).Style.TextAlignHorz = prt.AlignHorzEnum.Center '标题内容水平居中
    rt.Cols(c).Style.TextAlignHorz = prt.AlignHorzEnum.Center '数据水平靠右
    Dim i As Integer = 1

??????


    
    Next
Next

rt.Cells(6, 0).Text = "主任"
rt.Cells(6, 1).Text = "                 "
rt.Cells(6, 3).Text = "签字"
rt.Cells(6, 4).Text = "                 "
rt.Cells(7, 0).Text = "维修人"
rt.Cells(7, 1).Text = "                 "
rt.Cells(7, 3).Text = "报销时间"
rt.Cells(7, 4).Text = "                 "
rt.Style.Gridlines.All = New prt.Linedef '灰色网格线
rt.CellStyle.Spacing.All = 0.5 '单元格内距设为0.5毫米
rt.Rows(0).Style.TextAlignHorz = prt.AlignHorzEnum.Center '第一行内容水平居中
rt.RowGroups(0, 1).Header = prt.TableHeaderEnum.All '利用行组,将第一行设为表头
doc.Body.Children.Add(rt) '将表格加入到报表

2楼
有点蓝 发表于:2024/10/14 9:03:00
http://www.foxtable.com/webhelp/topics/1597.htm
3楼
有点蓝 发表于:2024/10/14 9:05:00
……
Dim i As Integer = 1
    For k as Integer = tb.TopPosition To tb.BottomPosition
        .Rows(i).Locked = 
True
rt.Cells(i, c).Text = tb.Rows(k)(colnames(c))
    Next
……
4楼
huangjingyu 发表于:2024/10/14 9:40:00
谢谢
[此贴子已经被作者于2024/10/14 9:41:23编辑过]
5楼
huangjingyu 发表于:2024/10/14 9:43:00
For c As Integer = 0 To Colnames.length - 1 '逐列设置和填入内容
    rt.Cells(0, c).Text = colnames(c) '列名作为标题
    rt.Cells(0, c).Style.TextAlignHorz = prt.AlignHorzEnum.Center '标题内容水平居中
    rt.Cols(c).Style.TextAlignHorz = prt.AlignHorzEnum.Center '数据水平靠右
    Dim i As Integer = 1
   With Tables("维修结账")

    For k As Integer = tb.TopPosition To tb.BottomPosition
       .Rows(k).Locked = True
        rt.Cells(i, c).Text = tb.Rows(k)(colnames(c))
    Next
 
   End With 
Next
老师,我选中了多个数据,怎么只填入一个,是我这个哪里不对吗?
6楼
有点蓝 发表于:2024/10/14 9:51:00
For c As Integer = 0 To Colnames.length - 1 '逐列设置和填入内容
    rt.Cells(0, c).Text = colnames(c) '列名作为标题
    rt.Cells(0, c).Style.TextAlignHorz = prt.AlignHorzEnum.Center '标题内容水平居中
    rt.Cols(c).Style.TextAlignHorz = prt.AlignHorzEnum.Center '数据水平靠右
    Dim i As Integer = 1
    For k As Integer = tb.TopPosition To tb.BottomPosition
        rt.Cells(i, c).Text = tb.Rows(k)(colnames(c))
i=i+1
    Next
Next
共6 条记录, 每页显示 10 条, 页签: [1]

Copyright © 2000 - 2018 foxtable.com Tel: 4000-810-820 粤ICP备11091905号

Powered By Dvbbs Version 8.3.0
Processed in .03125 s, 2 queries.