130
I have created a bunch of reports in SRS that utilize SQL views. I would like to integrate these into NAV using the object designer. Is there anyway to hook into SQL views as the dataset?
*This post is locked for comments
Hello,
You can use SQL Views as a table in NAV. There are some blogs on this, one which is very good is Waldo's blog, so credit to him for publishing this on the Dynamics User blog. It is very specfic to how it needs to be set up, so follow the information carefully.
dynamicsuser.net/.../how-to-display-an-sql-server-view-in-microsoft-dynamics-nav.aspx
Nick
Microsoft Dynamics NAV
Senior Escalation Engineer
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (