>I am generating a report by using a cursor and one of the fields is an expression field called sugamt. When I print the report, I am getting "***" instead of the calculated value. Here is the query that calculates the field called sugamt by using the IIF() command:
>
>

>			SELECT Products.p_productname, Products.p_itemcode,;
>				  Products.p_unitsinstock, Products.p_unitsonorder,;
>				  Products.p_totqtyperunit, Products.p_qtyperunit, Products.p_max,;
>				  Products.p_min,;
>			      IIF(Products.p_unitsinstock<=Products.p_min AND Products.p_unitsinstock > 0,Products.p_max-Products.p_min,0) as sugamt;
>				 FROM ;
>				     warehouse!products;
>				 WHERE  Products.p_itemcode BETWEEN ?lc_bitem AND ?lc_eitem;
>				 ORDER BY Products.p_productname INTO CURSOR prodrep
>

>
>it seem like the "Products.p_max-Products.p_min" is generating "***" on the report and not showing the calcluation. Anyone knows what is going here? Thanks
>
>Nick

1. In VFP9 use CAST function to create a variable with the desired type, e.g.

cast(iif(...) as Integer).

In VFP8 and less use

IIF(..., 0000000000) as myNewField

2. In the report itself check the format property and make the field wide enough.