有一段程序不知对你有用不,可以参考
sSql = ""
For i = 0 To MSFlexGrid1.Rows - 1
If sSql <> "" Then
sSql = sSql & "Or" & "{krid}=" & MSFlexGrid1.TextMatrix(i, 0)
Else
sSql = "{krid}=" & MSFlexGrid1.TextMatrix(1, 0)
End If
Next
If ssq = "" Then
Exit Sub
End If
With CrystalReport1
.Connect = sDNS
.WindowState = crptMaximized
.DiscardSavedData = True
.SelectionFormula = sSql
.ReportFileName = App.Path & "\tdryxx.rpt"
.Action = 1
End With
sSql = ""
For i = 0 To MSFlexGrid1.Rows - 1
If sSql <> "" Then
sSql = sSql & "Or" & "{krid}=" & MSFlexGrid1.TextMatrix(i, 0)
Else
sSql = "{krid}=" & MSFlexGrid1.TextMatrix(1, 0)
End If
Next
If ssq = "" Then
Exit Sub
End If
With CrystalReport1
.Connect = sDNS
.WindowState = crptMaximized
.DiscardSavedData = True
.SelectionFormula = sSql
.ReportFileName = App.Path & "\tdryxx.rpt"
.Action = 1
End With
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货