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 C/FRONT 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 [...]
