In Dynamics NAV 2013 R2 it is now possible, again, to implement Page X of Y for document reports. In previous versions of RDLC the problem was that in a typical document report the content of the body was put in a List container to implement the Number Of Copies option. Via the List we … Read More →
Plataan: Course 80433 Reporting in Microsoft Dynamics NAV 2013 (Date: 08 – 09 Apr, Location: Hasselt) Reporting in NAV 2013 is perceived as one of the biggest opportunities while being a competence challenge at the same time. If you want to learn how to make state of the art RoleTailored client reports in NAV 2013, … Read More →
Microsoft has released new videos in the How do I video series on Microsoft MSDN, which you can find here. The project is a joint effort by Plataan and Microsoft, and I participated as a technical expert in charge of seven videos. The idea is to showcase a Dynamics NAV 2013 topic in 5-15 minutes. … Read More →
Imagine you have to create a report, for example a Document, and there’s certain information, like for example Sales Conditions, that only need to be printed on the footer of the last page. How do you do that in RDLC? A good thing is always to investigate if there’s a property that you can use. … Read More →
A couple of days ago when I was delivering a Report Design in Dynamics NAV 2009 training one of the students had a very strange problem. Being an experienced trainer I thought I had seen all possible bugs and ‘undocumented features’ of the Report Designer, but this one I had never seen before. What happened? … Read More →
It’s been a couple of weeks now since Decisions Spring 2012 and unfortunately I was unable to attend the Q&A after my presentation and also had to miss the Expert Panel. As an alternative I will provide answers to some of the most interesting questions here: The Pace of Innovation: Does Microsoft Dynamics NAV 2013 … Read More →
A very strange message appeared when a user tried to connect to the test environment with the RoleTailored Client: (the server name is grayed-out for privacy reasons) What happened? Well, before ‘the change’ all users had the SUPER role. What we did was add a Company filter, because one of the Companies had to be restricted to certain … Read More →
This is a quick post about a problem I encountered a couple of times and the solution I found. When you run the RoleTailored Client (RTC) and in the Role Center page you try to “Customize this page“: then the RoleTailored Client crashes (dissapears) and when you open your Event Log there’s a big fat, … Read More →
Dynamics NAV Day at Decisions Spring 2012 is June 20, 2012. You can register here for the event. Have a look at the sessions & agenda: here And did I mention it’s a virtual conference (free of charge). Like last time, there’s also a session about Tips & tricks in NAV 2009 Reporting: http://decisions.msdynamicsworld.com/session/tips-tricks-report-design-msdymanics-nav-2009 In this … Read More →
Recently I was contacted by a fellow blogger, who had been scratching his head because of disappearing labels. The report in question was, for some unknown reason, not displaying all captions. It was a report with multiple data indented items. The strange thing was that when one of the data items was removed, the labels would show … Read More →
Something new I learned this week is that appareantly there’s a function GetUidOffset in CodeUnit1 (and it has been there for a couple of versions). GetUidOffset EXIT(0); // =0 –> control- and variable ids are assigned // based on license. // >0 –> control- and variable ids are using numbering //starting from that number The … Read More →
A question I receive a lot from customers and partners is if there’s a way to implement the PlaceInBottom effect on a report in RDLC. As you might already know, in the Classic Client, which I should now call the Development Environment, in the report object, there’s a property called PlaceInBottom. It determines whether a footer … Read More →
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