User Tools

Site Tools


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 ) ====== Previous pageReturn to chapter overviewNext page

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 (external edit)