View Mutliple company items in a single form

Can we view Item data in multiple companies using a single form or report in NAV 2009 ? …If anybody has already done this …Please let me know how to do that

I have actually done it using SQL views created by joining Item tables of mutiple companies . But i have to see item stock by location in multiple companies .

Hi DB, welcome to the Dynamics User Group ! You can use the CHANGECOMPANY command to do this. Have a look at the help on the function for usage