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

[kselvakumar_82]

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

[Hack]

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

[jggtz]

Try with :

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

[kselvakumar_82]

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

[jggtz]

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