RecordSelectionFormula doesn't return correct records. every time
Hi!
I am working in VB6-CR8.5
Either I use RecordSelectionFormula or SqlQueryString, getting the
same problem:
My RecSeleStr is this
STR2 = " {vexp_veh.veh_no} = ' " & mVeh & " ' "
When prog. runs:
If first time val. is given as "XXX" then it shows corr. report, all
recs. of vehicle no "XXX" only.
But next time onwards, in the case of other values it behaves in
funny way, either shows all the recs. or no recs.
Again, if I enter, "XXX" then it gives prop. result.
In the case of DATES, still more funny thing happens.
It seems, it doesn't get refreshed.
and uses very first selected data for all the next selections.
How to overcome?
Rest code:
Public Report1 As New CrystalReport1
Form1.Report1.RecordSelectionFormula = Form1.STR2
CRViewer1.ReportSource = Form1.Report1
CRViewer1.ViewReport
Thanks.
Regards,
Rachana