使用水晶报表时,第一次可以打印没有问题,更改数据源后,第二次打印内容不更新,还是第一次的内容.
我的代码如下:
Dim oApp As New CRAXDRT.Application
Dim oRpt As CRAXDRT.Report
Dim reportName As String
'上面三行是新增加的
Screen.MousePointer = vbHourglass
'定义要引用的rpt文件
CryRpt1.Database.SetDataSource PubRs
CryRpt1.ReadRecords
CRViewer91.ReportSource = CryRpt1 '启用水晶报表的预览功能
'
CRViewer91.ViewReport
CRViewer91.Zoom (2)
Screen.MousePointer = vbDefault
Set PubRs = Nothing
我每次打印时,更改Pubrs
但是:CRViewer91.ViewReport 并没有刷新.
急用,谢谢
我的代码如下:
Dim oApp As New CRAXDRT.Application
Dim oRpt As CRAXDRT.Report
Dim reportName As String
'上面三行是新增加的
Screen.MousePointer = vbHourglass
'定义要引用的rpt文件
CryRpt1.Database.SetDataSource PubRs
CryRpt1.ReadRecords
CRViewer91.ReportSource = CryRpt1 '启用水晶报表的预览功能
'
CRViewer91.ViewReport
CRViewer91.Zoom (2)
Screen.MousePointer = vbDefault
Set PubRs = Nothing
我每次打印时,更改Pubrs
但是:CRViewer91.ViewReport 并没有刷新.
急用,谢谢
解决方案 »
- 请问一下,为什么我的checkbox控件的setfocus方法不行呢?
- vb6做的程序一运行,系统就提示“正在配置Microsoft office xp Professional”
- datareport
- 如何配置Dcom的client 和server程序
- 同一家公司,有多家子公司,要共用一个管理系统。不通过游览器进入系统,能做到吗? 顶者有分。
- 关于多线程的问题!好急阿!!!
- 谁会用realserver8.0?(waiting online)
- sql中时间字段的问题.
- 关于ADO中recordset对象的菜鸟问题,送高分。
- 请问要怎么样才能禁止键盘里的特殊功能键的使用?
- 关闭VB报错,是什么问题!
- 请问一下这个程序只能显示到文件夹,怎么可以显示全部的文件,特别是.exe的文件?
Dim m_Report As New CrystalReport1 ’你的设计器Dim m_Connection As ADODB.Connection
Dim adoRS As ADODB.Recordset
Option ExplicitPrivate Sub Form_Load()
On Error Resume Next
Dim sql As String
Dim strConnect As String
' Create and bind the ADO Recordset object
Set m_Connection = New ADODB.Connection
Set adoRS = New ADODB.Recordset ' Open the connection
strConnect = JetOLEDB ’你的连接串
m_Connection.Open strConnectsql = "select Instore.ProId as 产品编号,ProName as 产品名称,Quantity as 数量,Hand as 经手人,InstoreCode as 票号,Instore.Indate as 日期 From Instore Join Product on dbo.Instore.ProId=dbo.Product.ProId where Instore.Indate between '" + Str(FrmInstoreQuery.DTP1.Value) + "' and '" + Str(FrmInstoreQuery.DTP2.Value) + "' and " & b & " = '" + FrmInstoreQuery.Text1.Text + " '"
adoRS.Open sql, m_Connection, adOpenDynamic, adLockBatchOptimistic ‘这里是打印的记录源
m_Report.Database.SetDataSource adoRS
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = m_Report
CRViewer1.ViewReport
Screen.MousePointer = vbDefault
End SubPrivate Sub Form_Resize()
CRViewer1.Top = 0
CRViewer1.Left = 0
CRViewer1.Height = ScaleHeight
CRViewer1.Width = ScaleWidth
End Sub End If
Dim oRpt As CRAXDRT.Report
Dim reportName As String
'上面三行是新增加的
Screen.MousePointer = vbHourglass
'定义要引用的rpt文件
'清除报表中保持的数据
CryRpt1.DiscardSavedData '<-------------------加上这句后再试试
'赋给报表数据
CryRpt1.Database.SetDataSource PubRs
CryRpt1.ReadRecords
CRViewer91.ReportSource = CryRpt1 '启用水晶报表的预览功能
'
CRViewer91.ViewReport
CRViewer91.Zoom (2)
Screen.MousePointer = vbDefault
Set PubRs = Nothing