>i have cvl as variable in my report,
>
>[pre] IIF(dtrupcode="VL",1,0) [/pre]
>
>it works fine if i put a text box and write in expression "cvl".
>
>if i want to only print the cvl when cvl>0 i do,
>
>[pre]
>
>IIF(cvl>0,cvl,0)
>
>[/pre]
>
>but say cvl=4, i want it to display "VL: 4" so i do it like this,
>
>[code]
>
>IIF(cvl>0,"VL: "+trim(str(cvl)),0)
>
>[/code]
>
>it only prints "4".
>
>what's wrong, any help pls?
Try making the space for the field wider on the report.