>>Hi,
>>
>>I am trying to create a cursor filled with the values in the detail band of an FRX file. The values may come form one or more tables or be calculated values. Since this will be done at runtime the environment is exactly the one the report finds and those values will be found with EVAL(Frx.Expr) without regard to where they come from.
>>
>>When preparing the CREATE CURSOR command I don't know how to determine the precision of numeric values if the Picture field is empty. I'd like the precision to be identical to what shows in the report. I tried using TRANSFORM() and then measuring the length after the decimal point but TRANSFORM(1.50) results in "1.5", not "1.50"
>>
>>Any suggestions?
>>
>>TIA,
>>
>>Alex
>
>
>n=1.5000000
>? MAX(LEN(CAST(n % 1 AS M))-2,0)
>
Thank you, Fabio.
Alex