Hi,

How do you send a variable from VB app. to crystal report so that it takes as criteria for filtering record for the report?

Do I have to use formula or parameter, or something else?

I created formula called @OrderID, which formula text is "{tblOrder.OrderID} = 50757", then on select tab on report Expert, I set @OrderID is true.

Private Sub cmdView_Click()
CrystalReport1.ReportFileName = App.Path & "\test.rpt"
CrystalReport1.Formulas(0) = "OrderID = {TBLORDER.ORDER_ID}= " & Text1

Form1.CrystalReport1.Destination = 0
Form1.CrystalReport1.Action = 1
End Sub

I do a lot of report /w access, but never have done /w CR. Please help me!

Thank you in advance
Joon