selectionformula_retireve_or_set_the_crystal_formula_.htm
| Navigation: Templates > Guide to all Templates > Additional Libraries and Templates > Crystal8 Class >====== SelectionFormula (retrieve or set the Crystal formula ) ====== |    |
SelectionFormula(| formulastring |)
SelectionFormula Set or retrieve the Crystal formula.
Formulastring A string constant, variable, EQUATE, or expression containing the Crystal formula. This parameter is optional.
The SelectionFormula method is used to either get or set the report's formula used to limit retrieved records. If the formulastring is omitted from the method call, the current formula is retrieved.
Return Data Type: STRING
Example:
formula = oCrystal8.SelectionFormula()!retrieve selection formula into formula variable
formula = '{{Customer.Country} in [“Australia”]' ! SQL query
oCrystal8.SelectionFormula( formula ) ! Set the query
selectionformula_retireve_or_set_the_crystal_formula_.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1