This is actually a small post about the ProcessingOnly report property in Dynamics NAV. You probably already know that you can use it to create a report object that acts as a code unit, but with the advantages of using data items to create nested loops and a request page to allow for dynamics filtering … 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 →
Are you interested in Dynamics NAV 2013? Would you like to get the latest in depth information on what’s new functional and technical? Then this might be very interesting… MICROSOFT DYNAMICS NAV 2013 APPLICATION BOOTCAMP This NAV 2013 bootcamp enables you as an experienced NAVconsultant to learn everything and more there is to know about … 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 →
Birmingham-based IT publisher Packt Publishing is about to publish its 1000th title. Packt books are renowned among developers for being uniquely practical and focused, but you’d be forgiven for not yet being in the know – Packt books cover highly specific tools and technologies which you might not expect to see a high quality book … 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 →
I know, officially it’s Dynamics NAV, but honestly, is there anyone in the real world that doesn’t still call it Navision? Anyway, this post is not about naming, it’s about Power. Yes, these days the new buzzword seems to be power. PowerView, PowerShell and PowerPivot to be more precise. [Ah, and PowerPoint, but that’s not … 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 →