Dynamic Formula in CR 8.5 1

[oguraja]

CR 8.5
Hi all,
i need a formula like the below one

if {SalesTable.sale} > 1000 then
Amount := SalesTable.sale;

"Sale" - should decide which field of the recordset has to be used. But i need this to be a variable so that i can change the field name at runtime and use the same formula with different fields.

How can i write a dynamic formula like that??

 

[lbass]

You could create a string parameter {?AmountField} and then change the formula to the following format:

if {?AmountField} = "Sales" then {SalesTable.Sale} else
if {?AmountField} = "Purchases" then {Purchases.Purchase} else
if {?AmountField} = "Discounts" then {Purchases.Discount}

-LB

 

[oguraja]

hey thanks...this works