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 NAV
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 [...]
My List of Dynamics-NAV Blogs
List of Microsoft Dynamics-NAV blogs that I read. Always on the lookout for new and fresh. http://mibuso.com/blogs/ara3n http://blogs.msdn.com/clausl/default.aspx http://dynamicsuser.net/blogs/alexchow/default.aspx http://dynamicsuser.net/blogs/singleton/default.aspx http://dynamicsuser.net/blogs/stryk/default.aspx http://dynamicsuser.net/blogs/ http://blogs.msdn.com/freddyk/default.aspx http://gaspodethewonderdog.blogspot.com/ http://dynamicsuser.net/blogs/kine/default.aspx http://mibuso.com/blogs/kriki http://dynamicsuser.net/blogs/mark_brummel/default.aspx http://blogs.msdn.com/uknav/default.aspx http://msnavarena.blogspot.com/ http://blogs.msdn.com/nav_developer/default.aspx http://dynamicsblog.wordpress.com/ has become: http://navigateintosuccess.com/ http://www.navision-girl.com/ http://www.nextequalzero.com/ http://noisyvan.wordpress.com/ http://demiliani.com/blog/Default.aspx http://stca.kilu.de/ http://techblog.byllemos.com/ http://navisiongnome.wordpress.com/ http://blogs.msdn.com/nav-reporting/default.aspx http://dynamicsuser.net/blogs/waldo/default.aspx http://manticoreblog.wordpress.com/ http://blogs.msdn.com/microsoft_dynamics_nav_sustained_engineering/default.aspx http://navtechapac.spaces.live.com/ UPDATE 03-02-2009: http://blogs.msdn.com/nav/default.aspx
Make Code Coverage in Navision (NAV) a Little More Useful
Code Coverage in Navision (available off of the tools menu -> debugger -> Code Coverage) is useful if you want to run through a process and see exactly what code is being hit. Helpful from time to time in identifying spots where things are happening in code or where you can hook new functionality into. [...]
Import Objects from a Navision backup (.fbk)
Not sure where I originally saw this tip but it’s been so handy for me I think it needs to exist in more than one location. If you’ve done a NAV backup and need to grab a couple objects out of the backup, instead of doing a full restore and then exporting select objects, you [...]
