[RESOLVED] recordselecttion formula in CR8.5
i have prob in following... i am using VB6/CR8.5/Access Database.
Dim CrAppl As New CRAXDRT.Application
Dim CrRep As New CRAXDRT.Report
Set CrRep = CrAppl.OpenReport("D:\Visual Basic Proj/VatSoft\Wlist2.rpt")
With CrRep
'Selection
.RecordSelectionFormula = "{Wlist2.wlistno} = 2 "
End With
wlistno is integer field.
how do i pass this no using a integer variable??
Q.2 how can i refresh this report if data does not comeup on report??? at runtime using codes)
Re: recordselecttion formula in CR8.5
VB Code:
Dim CrAppl As New CRAXDRT.Application
Dim CrRep As New CRAXDRT.Report
Dim x as Integer
Set CrRep = CrAppl.OpenReport("D:\Visual Basic Proj/VatSoft\Wlist2.rpt")
With CrRep
'Selection
X = 2
.RecordSelectionFormula = "{Wlist2.wlistno} = " & X
Re: recordselecttion formula in CR8.5
Yes That syntex is correct but still i have to press refresh button when i change Wlistno value, I dont understand why?? how can I give refresh command to CR before desplaying it?