Anybody knows how to use formulas?

[mn20]

I do my reports in a web browser so I use CrystalViewer. I'm wondering if you know how to filter the report using the SelectionFormula (whats the syntax?). Also, I'd like to know how to pass FormulaFields or Formulas (the syntax also).

thanks!

 

[vbboy]

Try This:

YourReport.SelectionFormula = "{YourTable.YourField}= " & YourVariable

YourReport.Formulas(0) = "YourReportFormulaName= " & YourVariable

Make sure you do not have space between YourReportFormulaName and = sign.

Try!!