RecordSelectionFormula doesn't work

[adigrescenko]

In my VB application, using CrystalReports, I want to select the records that are displayed on report.
I used this:
Report.RecordSelectionFormula = "{MyTable.Age}=24"
but I have this error: "This field name is not known", but I am sure that the table and field names are correct.
I tryed to use SQLSelectionFormula , but it doesn't work too.
Please help me!

 

[chelseatech]

Is your Age field a number or a string? Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[kenhamady]

To rule out a spelling problem or field name problem, cut this formula and paste it directly into the report's record selection formula (in the report design environment). See if it is accepted. I would be surprised if a data-type error would give that error. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com