>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,