Using Memo BLOB to Enable Huge Text

AUTHOR NOTE: 2021-02-10 – There is a Dynamics 365 Business Central Repo showing how to handle this in Business Central. I’ll try to update the blog with a new post walking through it, but it’s very functionally the same as below: Generally speaking, enabling huge text fields in NAV is bad design because it … Read more

NAV Tip: Access Domain NAV from Non-Domain Computer

It’s pretty easy to run Microsoft Dynamics NAV (RTC or otherwise) as another user while you’re inside the domain (shift right click on most Windows machines to find a “Run as another user” option, if you did not know). We had a situation come up where, for training purposes, it was necessary to use a … Read more

Dynamics NAV – Credential Type NavUserPassword Gotcha

This is not so much a training document as outlining how I had to troubleshoot a weird error. I think the process taught me a variety of things, so I wanted to share the process of finding the answer. I was trying to setup a new Dynamics NAV 2016 service tier in a test environment … Read more

Cultured Differences

Last week we discussed how to apply standard formatting codes for currencies and dates to Microsoft Dynamics NAV 2009 RTC reports. As I mentioned in that blog post, there are some hoops we have to jump through in order to show more than one culture’s formats on the same report. In the typical report the … Read more

The (Formatted) Numbers Game

Microsoft Dynamics NAV 2009 RTC report design using RDLC has a lot of flexibility when formatting dates, times, and numbers. While you can create custom number formatting (which we will cover in a future blog post) many of the standard formatting options will often do the trick far more easily and without requiring the developer … Read more

Can You Be Shown What The Matrix Is?

Take the right color pill with this post about the Matrix control in the RTC Report and how it can help you. But, this topic is not for the novice, so make sure you buckle up. In this post, we’ll talk about how to bring together diverse data into a dynamic table – we’ll use … Read more

Understanding Classic vs RTC Report Data

The Classic reporting engine and the RTC reporting engine are two very different animals. Hopefully, we can highlight the differences today for some of the deeper topics we’ll cover this week. Microsoft Dynamics NAV classic reports are highly iterative. For example, this Customer/Item Statistics report is a great example: The engine will loop through the … Read more

Mystery White Space: Issue #1

We ran into a peculiar issue today – a report that kept adding extra pages for no discernible reason.  A quick check of the usual community sites didn’t yield a solution, so I thought it was blog-worthy as a topic. In our case, we have a report that is printing a 2nd page with nothing on it … Read more