[RESOLVED]Selection formula of VB6.0 for crystal report 10

How to use selection formula in VB6.0 for the crystal report 10.
I was using cystal report 6 and used the selection formula as
.SelectionFormula = "trim({Table1.Branch})='" & cmbBR.Text & "'"
But for crystal report it is not accepting. Can any guide me how to pass the selection formula(Parameters)

Selvakumar

What does "not accepting" mean? Are you getting an error?

Try with :

Code:

---

  YourCRObject.RecordSelectionFormula = "Trim({Table1.Branch}) = '" & cmbBR.Text & "'"

---

Thanks for your update on that. can you please clarify the following?

invalid or unqualified reference is the error im getting when i use .selection formula.

when i use
Crviewer1.RecordSelectionFormula = "Trim({Table1.Branch}) = '" & cmbBR.Text & "'"
im gettting the error as object doesnt suppport this property or method

You have to set the .RecordSelectionFormula property to the CRAXDRT object that is part of a reference that you have to set in your project :

Crystal Report ActiveX Designer Runtime Library 10

Visit the next link :
http://www.mahipalreddy.com/cr/crcodes1.htm