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 →

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 →

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 →