How to access SQL object From Dynamics NAV 2009

Hi
Following example will show how to access a sql view from Dynamics NAV 2009

• Create a SQL view
• Create a Table in NAV field names as same as field names in sql view
• go to the report properties and change "LinkedObject" to yes
• save the Table . Table name should be as same as view name
• run Table

Create View in sql

CREATE VIEW [CRONUS International Ltd_$SamView] AS
SELECT [No_],[Name]
FROM [Demo Database NAV (6-0)].[dbo].[CRONUS International Ltd_$Customer]

Create Table in NAV

save table and run it :)

Thanks
Marshal. J