The latest weeks I have received a couple of questions from various Dynamics NAV consultants regarding strange SQL errors Dynamics NAV was throwing. A couple of examples: Table XXXXX coes not exist. Cannot find the user ‘$ndo$…….’, because it does not exist or you dont have permission. You do not have permission to execute table XXXXX. You … Read More →
What if a user asks: Could you create a report showing the inventory by Item, but in all of our companies? Sometimes I see the strangest and most exotic constructions or C/AL coding to answer these kinds of questions, when a more simple solution could do the same and better. 🙂 In the ‘old’ days … Read More →
I’m learning about #SQL2012 by watching video sessions at the #SQLServer 2012 Virtual Launch Event: http://www.sqlserverlaunch.com ! This whitepaper provides an overview of the new features, benefits, and functionality in Microsoft SQL Server 2012: SQL Server 2012 What’s New Whitepaper
Recently I had to change the list of available fields in a DropDown box on a page. As you might already know, a DropDown is a result of a field having a TableRelation. For example, on a Sales Order page there’s a field “Sell to Customer No.“. This field has a table-relation towards the Customer table and as a … Read More →
Recently I prepared a blog post about a property RepeatWith available in RDLC reports that has the potential to revolutionize the way that we create document reports in Dynamics NAV 2009. It went like this: When developing reports in Dynamics NAV you are sometimes required to show information, which is in the Dataset, on the … Read More →
Packt Publishing Celebrates its range of Microsoft Dynamics books/e-books all month! Packt Publishing is crowning February, Microsoft Dynamics Mayhem, and celebrating its range of Dynamics books/e-books with exciting discounts. As the leading publisher of Microsoft Dynamics books/e-books and a multitude of bestsellers on NAV, AX, GP and Sure Step, not only do these titles excel … Read More →
Did you ever had to outline information on a report? For example, the user asks you to move this field a little to the left or right, or can that textbox be a little bigger because sometimes it’s just not big enough? Or can you also add this information into that textbox, but don’t change … Read More →
Comments usually go into the Documentation() trigger in your report object, but sometimes you want to be able to also put comments in the RDLC layout. For example when you have put controls behind each other and depending on a certain expression you change the visibility. In that case, when a modification needs to be … Read More →
On december 7 I delivered a presentation, at Decisions Fall 2011. It is still available online here: http://decisions.msdynamicsworld.com In this session we will start with an introduction on Role Tailored report design for Microsoft Dynamics NAV 2009, how the dataset is generated and how to create a simple layout. Next we will discuss how to … Read More →
On 23 september I delivered a session for the Dutch Dynamics Community about report design in Dynamics NAV 2009. You can find more info here. The presentation is also available for download and can be found here.
Welcome to think about IT. I’ve been thinking a long time now to create a blog website, and finally it’s here. The idea is to provide information about Microsoft Dynamics NAV, SQL Server and surrounding technologies from personal experience and from a practical point of view. If you are looking for specific information or would like … Read More →