Nav report to pull data from 'other' SQL database

TrippyZ

Could someone walk me through the steps to get data from an external SQLServer database into a Navision report? Both the Nav db and the external db are running under the same SQLServer instance.

kine

You can add view into the NAV DB which select the data from another database and add new table into NAV and use LinkedObject = yes to connect it to the view. Just search for the LinkedObject in the forum for more info.

Another way is to use ADO (search for ADO).