807
社区成员
发帖
与我相关
我的任务
分享水晶报表在连接mdb（表为：T1）文件时能否有选择条件？例如：只连接t1.code=’1’的内容.
水晶报表在连接mdb（表为：T1）文件时能否有选择条件？例如：只连接t1.code=’1’的内容.
...全文
请发表友善的回复…
发表回复
Cocoky 2003-08-09
- 打赏
- 举报
你可以这样做:
m_Report.RecordSelectionFormula = "{t1.code} = '1'"
CRViewer1.Refresh
当不需要时改为:
m_Report.RecordSelectionFormula = ""
m_Report.RecordSelectionFormula = "{t1.code} = '1'"
CRViewer1.Refresh
当不需要时改为:
m_Report.RecordSelectionFormula = ""
skyyiyang 2003-08-09
- 打赏
- 举报
水晶报表.datasour=rs
rs 是一個有有條件的SQL語句
如
AdoRs.Open SqlStr, Cn1, adOpenKeyset, adLockReadOnly ', adLockBatchOptimistic
Dim m_Report As CrysRNewJob
Set m_Report = New CrysRNewJob
Me.MousePointer = vbHourglass
m_Report.Database.SetDataSource AdoRs
m_Report.Database.Verify
CRViewer1.ReportSource = m_Report
CRViewer1.ViewReport
rs 是一個有有條件的SQL語句
如
AdoRs.Open SqlStr, Cn1, adOpenKeyset, adLockReadOnly ', adLockBatchOptimistic
Dim m_Report As CrysRNewJob
Set m_Report = New CrysRNewJob
Me.MousePointer = vbHourglass
m_Report.Database.SetDataSource AdoRs
m_Report.Database.Verify
CRViewer1.ReportSource = m_Report
CRViewer1.ViewReport
no_com 2003-08-08
- 打赏
- 举报
up
