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 [...]
Archives for SQL
SQL Reporting Services and Dynamics NAV Option Strings: Part 1
One downside to using SQL reporting services with Dynamics NAV versus a NAV report or another 3rd party solution such as Jet Reports (jet uses NODBC to access option values, flowfields, etc. which gets these values directly from NAV) is that you lose the access to the Option String values and instead are forced to [...]
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 [...]
