Thanks Kevin for your patience, but where is the lv_ changed to v_. I can manage it in the report but where is the alias specified :-) is it automatically done for me or have I to do the coding / setting of properties manually.

>>Sorry to sound dumb but I am using the view designer (not much of a coder) where can I specify the alias, or is it specified for me?
>
>You don't specify it in the view designer, in the Report desinger, set the report controls' Expression to something like "v_viewname.fieldname".
>
>Regards,