用crystal Report If Me.GridM.ApproxCount = 0 Then Exit Sub
With Me.CryReport
.WindowState = crptMaximized
.WindowShowPrintSetupBtn = True
.Connect = "连接字串"
.ReportFileName = App.path & "\Report\rpt1.rpt"
.SQLQuery = "select ..."
.PrintReport
End With
With Me.CryReport
.WindowState = crptMaximized
.WindowShowPrintSetupBtn = True
.Connect = "连接字串"
.ReportFileName = App.path & "\Report\rpt1.rpt"
.SQLQuery = "select ..."
.PrintReport
End With
我不知道,帮你顶顶,
1。现在我需要统计数据表中的各项数据,例如:要把select sum(avg) from emp 语句得出的数据放到一个窗口的text中,这要怎么样实现呢?我想不通的地方就是这条语句似乎只有操作数据库的功能,而不会像函数一样有返回值
2。一个界面问题。我用DataGrid 制作出的数据表,如果列的数目较多时,这个表格的下面就会出现一个滚动条,当我把这个滚动条拉到最右边的时候,会出现一大块的空白处,这很影响程序的美观。可不可以把滚动条拉到最右边的时候刚好可以到数据表的最后一列?
UP
dim rs as adodb.recordset
dim conn as new adodb.connection
conn.connectionstring=""
conn.open
set rs=conn.execute"select sum(avg) from emp"
text1.text1=rs(0)
vsflexgrid+vsprint
http://expert.csdn.net/Expert/topic/1819/1819831.xml?temp=.707638
\Program Files\Microsoft Visual Studio\MSDN98\98VS\1033\samples\VB98\DataRept
....
Dim intI As Integer
If mRst.State = adStateOpen Then
With rptOp_orderPlan
Set .DataSource = mRst
.DataMember = ""
.Orientation = rptOrientLandscape
.LeftMargin = 10 '左边距
.RightMargin = 10 '右边距
.Sections("section4").Controls("labbegin").Caption = txtBegin
.Sections("section4").Controls("labend").Caption = txtEnd
'设置标签和文本框
For intI = 0 To mRst.Fields.Count - 1 '
.Sections("section1").KeepTogether = True '防止一条记录被分开打印
.Sections("section1").Controls("text" & Trim(str(intI + 1))).DataField = mRst.Fields(intI).Name
.Sections("section1").Controls("text" & Trim(str(intI + 1))).Alignment = 2
.Sections("section1").Controls("text" & Trim(str(intI + 1))).CanGrow = True
.Sections("section1").Controls("text" & Trim(str(intI + 1))).Top = 100
Next
.Sections("section5").Controls("funCount").DataField = mRst.Fields(0).Name
.Show
End With
End If