In Part 1 we created a table and a processing report in Dynamics NAV that would enable us to later access every Dynamics NAV option string value in a SQL Reporting Services report. Now, I will show how I handled the query to get option string values into an SSRS report. This is a little [...]
Posts tagged SQL
NAV Default Database File Locations
I’m frequently creating new databases in NAV. One annoyance was NAV’s insistence on the default file location. In my dev environment this was always where I had installed SQL. Not where I want my databases. I spent some time investigating and after watching file system and registry access on both server and client I wasn’t [...]
New Job!
I have a new job! Over the last few years the things that I’ve enjoyed working on/with the most have been my SQL Server projects and an implementation of Navision. I’ve always loved creating and putting things together and being creative in how I do it. But with everything that goes into being an systems [...]