can "CrystalReport1.SelectionFormula = ..." be used with formulas

[chrisp909]

I am trying to use the CrystalReports1.SelectionFormula property of the CR object.

I can use it to filter unneeded records using an attribute of the table I am using.

i.e. {AdmittedStudent.AdmittedStudent_Country} like "Russia"

However:
Some of the columns in the report are derived and I would like to be able to filter them as well. I can do it in the CR IDE but using the exact same code in the SelectionFormula property within VB yeilds no changes in the report.

i.e.{@SelectionFormula} like "Whiskey"

 

[Ngolem]

yes...it can be done but the evaluation is done clientside in a second pass through the records once the sql has been executed....can be slow depending on the formula but sometimes unavoidable

 

[chrisp909]

Could you be a little more specific on the execution of your solution.

Are you saying "yes" I can do it from the SelecionFormula property. If so How?

Or are you saying "yes" it can be done but I have to rewrite the formula on the client side and pass the data to the report.

 

[kenhamady]

What is the formula for @selectionformula in the report?

Also, make sure that you are using CR syntax.
"Like" allows wild cards, and if you don't use any wildcards it is the same as "equal". 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