我现在用ActiveReport来做打印报表,我要打印出来的报表是这样的:有个表头,下面是细表.
细表就是一张表格.
我操作访问数据库都通过代码形式的,用得是VB6,数据库是sqlserver2000.
做过这方面的给我点建议.
细表就是一张表格.
我操作访问数据库都通过代码形式的,用得是VB6,数据库是sqlserver2000.
做过这方面的给我点建议.
解决方案 »
- 求助一个关于用WORD打印的问题
- 用windows服务启动vb程序,出错,没启动起!求救~~(100分感谢)
- 怎样建立文本框数组?
- 如何(1)将一个图片以二进制保存到SQL数据库(2)再读取到一个Pic控件中,在线等...
- 急急……用ASP如何做两个选项的组合
- 一个菜鸟苦恼的问题,什么是数据控件,如何找到它?噢!在线等!虽说分数少,立即结贴!
- 大家好!我是新手!帮帮我一些函数上的问题!
- 一个用Textout()在picturebox上输出文字的问题
- 请问VB6.0在哪里下阿???还有什么地方有关于VB的电子书籍???谢谢
- 从对方的IP判断对方的地理位置
- 一个提高技能的算法
- 如何提取出qq聊天框中编辑框和显示框的文字!!!!!!! 找不到句柄!!!! 请大侠赐教 现在是qq2009!!!!!!
intLeft(0) = 0: For i = 1 To 7: intLeft(i) = intLeft(i - 1) + intWidth(i - 1): Next
With ar
.DataControl1.ConnectionString = curConnection
.DataControl1.Source = strSQL
'添加表头
Set ctl = .ReportHeader.Controls.Add("DDActiveReports2.Label")
ctl.Left = 1000
ctl.Width = 7000
ctl.Caption = strTitle
ctl.Font.Name = "仿宋_GB2312"
ctl.Font.Size = 20
Set ctl = .ReportHeader.Controls.Add("DDActiveReports2.Label")
ctl.Left = 10
ctl.Width = 3100
ctl.Caption = strField(0) & ":" & cur_xn
ctl.Font.Name = "宋体"
ctl.Font.Size = 12
ctl.Top = 700
Set ctl = .ReportHeader.Controls.Add("DDActiveReports2.Label")
ctl.Left = 3110
ctl.Width = 3000
ctl.Caption = strField(1) & ":" & cur_xy
ctl.Font.Name = "宋体"
ctl.Font.Size = 12
ctl.Top = 700
Set ctl = .ReportHeader.Controls.Add("DDActiveReports2.Label")
ctl.Left = 6110
ctl.Width = 3000
ctl.Caption = strField(2) & ":" & cur_nj
ctl.Font.Name = "宋体"
ctl.Font.Size = 12
ctl.Top = 700
' Set ctl = .ReportHeader.Controls.Add("DDActiveReports2.Label")
' ctl.Left = 9100
' ctl.Width = 1400
' ctl.Caption = "统计字段:" & CStr(.GroupHeader1.DataField)
' ctl.Font.Name = "宋体"
' ctl.Font.Size = 8
' ctl.Top = 700
.ReportHeader.Height = 800
'添加组头
If strSum <> "" Then
.GroupHeader1.Visible = True
.GroupFooter1.Visible = True
.GroupHeader1.DataField = strSum
.GroupFooter1.Height = 300
Set ctl = .GroupFooter1.Controls.Add("DDActiveReports2.Label")
ctl.Left = 0
ctl.Width = intLeft(3)
ctl.Height = 300
ctl.Caption = "小计"
ctl.Font.Name = "宋体"
ctl.Font.Size = 12
ctl.Alignment = ddTXCenter
Set ctl = .GroupFooter1.Controls.Add("DDActiveReports2.Shape")
ctl.Left = 0
ctl.Width = intLeft(3)
ctl.Height = 300
For i = 3 To 7
Set ctl = .GroupFooter1.Controls.Add("DDActiveReports2.Shape")
ctl.Left = intLeft(i)
ctl.Width = intWidth(i)
ctl.Height = 300
Next
.Field1.DataField = strField(3)
.Field1.SummaryDistinctField = strField(3)
.Field1.Left = intLeft(3)
.Field1.Width = intWidth(3)
.Field2.DataField = strField(4)
.Field2.SummaryDistinctField = strField(4)
.Field2.Left = intLeft(4)
.Field2.Width = intWidth(4)
.Field3.DataField = strField(5)
.Field3.SummaryDistinctField = strField(5)
.Field3.Left = intLeft(5)
.Field3.Width = intWidth(5)
.Field4.DataField = strField(6)
.Field4.SummaryDistinctField = strField(6)
.Field4.Left = intLeft(6)
.Field4.Width = intWidth(6)
.Field5.DataField = strField(7)
.Field5.SummaryDistinctField = strField(7)
.Field5.Left = intLeft(7)
.Field5.Width = intWidth(7)
Else
.GroupHeader1.Visible = False
.GroupFooter1.Visible = False
End If
.Detail.Height = 320
For i = 0 To 7
'添加表头
Set ctl = .PageHeader.Controls.Add("DDActiveReports2.Label")
ctl.Caption = strField(i)
ctl.Left = intLeft(i) + 10
ctl.Width = intWidth(i)
ctl.Font.Name = "宋体"
ctl.Font.Size = 12
ctl.Height = 300
ctl.Top = 120
Set ctl = .PageHeader.Controls.Add("DDActiveReports2.Shape")
ctl.Left = intLeft(i)
ctl.Width = intWidth(i)
ctl.Height = 320
ctl.Top = 100
'添加字段
Set ctl = .Detail.Controls.Add("DDActiveReports2.Field")
ctl.DataField = strField(i)
ctl.Left = intLeft(i) + 10
ctl.Width = intWidth(i)
ctl.Font.Name = "宋体"
ctl.Font.Size = 10
ctl.Height = 280
ctl.Top = 30
ctl.WordWrap = False
ctl.Visible = bVis(i)
'添加边框
Set ctl = .Detail.Controls.Add("DDActiveReports2.Shape")
ctl.Left = intLeft(i)
ctl.Width = intWidth(i)
ctl.Height = 320
ctl.Top = 0
Next
'添加总计
.ReportFooter.Height = 300
Set ctl = .ReportFooter.Controls.Add("DDActiveReports2.Label")
ctl.Left = 0
ctl.Width = intLeft(3)
ctl.Height = 320
ctl.Caption = "总计"
ctl.Font.Name = "宋体"
ctl.Font.Size = 12
ctl.Alignment = ddTXCenter
Set ctl = .ReportFooter.Controls.Add("DDActiveReports2.Shape")
ctl.Left = 0
ctl.Width = intLeft(3)
ctl.Height = 320
For i = 3 To 7
Set ctl = .ReportFooter.Controls.Add("DDActiveReports2.Shape")
ctl.Left = intLeft(i)
ctl.Width = intWidth(i)
ctl.Height = 320
Next
.Field6.DataField = strField(3)
.Field6.SummaryFunc = ddSFSum
.Field6.SummaryDistinctField = strField(3)
.Field6.SummaryRunning = ddSRGroup
.Field6.Left = intLeft(3)
.Field6.Width = intWidth(3)
.Field7.DataField = strField(4)
.Field7.SummaryFunc = ddSFSum
.Field7.SummaryDistinctField = strField(4)
.Field7.SummaryRunning = ddSRGroup
.Field7.Left = intLeft(4)
.Field7.Width = intWidth(4)
.Field8.DataField = strField(5)
.Field8.SummaryFunc = ddSFSum
.Field8.SummaryDistinctField = strField(5)
.Field8.SummaryRunning = ddSRGroup
.Field8.Left = intLeft(5)
.Field8.Width = intWidth(5)
.Field9.DataField = strField(6)
.Field9.SummaryFunc = ddSFSum
.Field9.SummaryDistinctField = strField(6)
.Field9.SummaryRunning = ddSRGroup
.Field9.Left = intLeft(6)
.Field9.Width = intWidth(6)
.Field10.DataField = strField(7)
.Field10.SummaryFunc = ddSFSum
.Field10.SummaryDistinctField = strField(7)
.Field10.SummaryRunning = ddSRGroup
.Field10.Left = intLeft(7)
.Field10.Width = intWidth(7)
End With