如果用水晶报表:Private Sub Command1_Click()
Dim Report As New CrystalReport1
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim Str As String
Dim Serch As String
Serch = Text1.Text
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
Str = "select * from output where 购买公司 = '" & Serch & " '"
cn.Open "Provider=Microsoft.Jet.OLEDB.3.51;" & "Persist Security Info=False;" & "Data Source=" & App.Path & "\Sql\database.mdb"
rs.Open Str, cn
Report.Database.SetDataSource rs
Form13.CRViewer1.ReportSource = Report
Form13.CRViewer1.ViewReport
Form13.CRViewer1.ShowFirstPage
Form13.Show
rs.Close
Unload Me
End Sub其实 不管怎样打印只要 把记录集 想办法搞出来就行了
Dim Report As New CrystalReport1
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim Str As String
Dim Serch As String
Serch = Text1.Text
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
Str = "select * from output where 购买公司 = '" & Serch & " '"
cn.Open "Provider=Microsoft.Jet.OLEDB.3.51;" & "Persist Security Info=False;" & "Data Source=" & App.Path & "\Sql\database.mdb"
rs.Open Str, cn
Report.Database.SetDataSource rs
Form13.CRViewer1.ReportSource = Report
Form13.CRViewer1.ViewReport
Form13.CRViewer1.ShowFirstPage
Form13.Show
rs.Close
Unload Me
End Sub其实 不管怎样打印只要 把记录集 想办法搞出来就行了
解决方案 »
- VB内录(录制电脑正在播放的声音)
- vb 如何读取java的properties配置文件?
- 请问:有没有类型为WH_CALLWNDPROC的hook的例子?
- vsprint8.ocx 如何用?
- 问题简单 关于一个图书管理系统的设计问题——进者有分哈·
- VB 中有Sizeof或类似的方法吗?
- VB写一个记事本,带有提醒功能
- 急需高手!vb中有没有API函数可以判断本地连接,和无线网卡连接 是连的还是断开的?
- 求教一读取注册表例子,谢谢!!!
- 有没有在局域网中从98系统机器发送消息给2000系统
- 以下数据检索如何表达(SQL语句)请看,急.........
- 怎样才能获得系统的CPU的ID号、网卡MAC之类的系统信息(要代码)(100分)
dataenvironment里面的recordsouce用cmdtext写得SQL语句中,条件部分用特殊字符代替(比如"?")
程序中用replace语句把"?"替换成你的条件语句即可