Monthly Archives: March 2015

Tip #45 | NAV2015 | Report Temporary Property

With Microsoft Dynamics NAV 2015 Microsoft introduced a great new property on the Report object: Temporary.

This behaves the same as the SoureTableTemporary property on a page and basically eliminates the need of using integer dataitems and loops on reports.

It also makes it easier to use Query as a datasource for a report like I did for a page in this post:

https://markbrummel.wordpress.com/2013/09/10/tip-35-using-queries-in-pages-reports/

Lets repeat this exercise. We will use the same Query and Temporary Table and use in on a report instead.

The query combines sales information from the Value entries per customer.

And we create a class for the query as a table.

We need to define the table on a report and activate the new property

QueryOnReport

And since the table is now empty we need to populate it like the table on the page like this:

QueryOnReport2

Then after we created a Layout for the report:

QueryOnReport3

Voila, enjoy

Advertisements

Convergence 2015 US | Recap

It’s only wednesday afternoon, the event goes on for another day but it’s my last day at the event so time to wrap up and recap.

Honestly I had forgotten how big this event was. Last Convergence I attended was in 2008 I think. 12.000 people is huge and makes Directions EMEA look like a gathering of friends (which it is).

So it’s an experience being here even though I skipped monday because of my oldest daughters birthday.

I’ve done two presentations for NAVUG. One about upgrades and one about word reporting. Both sessions will be repeated as a NAVUG webinar so if you missed it you should register.

Upgrades

Goal was to squeeze almost two decades of real life upgrade experience into an hour session. I had 46 slides. I managed to do it in exactly 60 minutes with only skipping one slide.

The session was devided into a part about getting from Classic to RTC and a part about upgrades after finishing this journey. The majority of the audience was still on classic.

I hope I inspired people to get the upgrade going and enjoy the better upgrade experience after that.

You can find the slides here.

https://onedrive.live.com/?cid=6CE75573B9DF3521&id=6CE75573B9DF3521%21167849

Word Reporting

I was honestly tempted to ask the audence to leave the presentation if they had ever done  a mailmerge in word, but I did not. I actually managed to spend 45 minutes on the topic with Claus Lundstrom in the audience.

Mark Word reporting

I spent most time of the presentation explaining different datasetconsiderations comparing different versions of the Sales Invoice Report. Once the dataset is easy to understand the word reporting gets easier too.

Nested Iterations

During convergence I also learned that NAV 2015 CU4 fixed the problem of having nested iterations in your word report. That is excelent news.

Glossy Mark

Couple of weeks ago I was asked some interview questions that would be published in the NAVUG magazine. Well that happened and I was quite surprised how cool the result looks in a glossy magazine.

WP_20150318_001

Vintage Dynamics NAV #1 | Functions

One of my key values is loyalty. I am very loyal to my customers and my customers are loyal to me.

This means with a history of two decades in the product you run into your own old code every now and then. This happened today as you can see in this screenshot:

VintageNAV2

Some objects have not changed since 2003 and when I opened I noticed this:

VintageNAV1

Now to all of you who are relatively new to the product, you might think that the C/AL editor can be improved by implementing Notepad instead.

However, there used to be a time not so long ago that NAV did not have GoToDefinition. One of these treats you get used to very quickly.

Even longer ago it was not even possible to use Search on Function names in objects.

To work around this issue I always put the function name as a comment in the function first.

This looks very awkward now, but it was very useful back in those days.

Compared to that, Notepad would have been an improvement to the C/AL Editor.