Now I would try some other tool, like Miscrosoft Query, to see if it works. If it does, than problem is in Report Manager.

>The view seems to be working using SPT. This view in question has a known divide by zero for which I have put in a IIF() condition as below:
>

SELECT ROUND(IIF(LV_LKCALCBP.BCALCBP = 0, LV_LKCALCBP.BCALCBP - 1, LV_LKSFC1.BSFC1 / LV_LKCALCBP.BCALCBP), 2) AS BSFC, ;
>		LV_LKSRATINGTEST.IID ;
>	FROM VSO3VIEWS!LV_LKTRATINGTEST ;
>		JOIN VSO3VIEWS!LV_LKSRATINGTEST ;
>				ON LV_LKTRATINGTEST.IID = LV_LKSRATINGTEST.IPID ;
>		JOIN VSO3VIEWS!LV_LKSFC1 ;
>				ON LV_LKSRATINGTEST.IID = LV_LKSFC1.IID ;
>		JOIN VSO3VIEWS!LV_LKCALCBP ;
>				ON LV_LKSRATINGTEST.IID = LV_LKCALCBP.IID

>
>Any suggesstions.
>
>Thanks for all your help.
>