Posts tagged SQL

SQL Reporting Services and Dynamics NAV Option Strings: Part 2

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 [...]

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 [...]