>I have a need to display a numeric field on the report with options to have no decimals, 2 decimals, 3 decimals or more.
>Currently I'm using the format mask in the field expression to do this but unable to put a iif() condition on the format mask to dynamically change the format mask based on a public variable to decide on how many decimal points the format mask should have.
>
>Is there a way to do this?
>
>Thanks in advance.
>Yau
Try to use transform function with iif, e.g. something like below. I haven't tried it, but hopefully it would work.
transform(myNumber,myFormatString)
If it's not broken, fix it until it is.
My Blog