Skip to the content


Visualising Data: Charts in 安博电竞 NAV 2013

With the introduction of the Role Tailored Client into NAV 2009, functionality was added to allow graphical charts to be displayed on pages. However from what we have seen uptake of this functionality has been low, largely due to the lack of a good interface to add, modify and view these charts. With the imminent release of NAV 2013 all this should change!

NAV 2013 allows you to display two types of chart; what are referred to as Generic Charts and more advanced charts known as Extended Charts. Generic Charts are the same as what has always been available in the 2009 RTC, but with a new set of accompanying objects to make the job of creating and modifying your charts much easier. Extended Charts use the 安博电竞 Chart Add-in which requires some NAV development experience to create charts with, but allows you much more control over the charts run time.

The recently released RTM version of the Cronus database has a good example of the difference between the chart types. The first thing you see when running the RTC is nice extended chart on the Sales Order Processor Role Centre.

This gives a breakdown of open and released sales orders grouped by months, however it leverages the functionality of the Extended Charts by allowing the user to set their own period length (Day, Week, Month, Quarter, Year) and choose whether to show the number of orders or value of the orders. This is where the Extended Charts excel, the user has a regular need for a chart, but needs the ability to be able to adjust it to show the data as needed each time they use it. The regular business need means it is worth the small development cost up front to create the chart.

On the other hand Generic Charts give two levels of ease of creation to allow you to create either completely ad-hoc reports based on any list page, or with slightly more design work by the user based on any page or query (an exciting new object type in NAV 2013 which allows you to combine tables together as you would in SQL or Access).

For example from the standard Customer list I can click Show as Chart, select an X dimension (No.) and a Y dimension (Balance) and I’ve instantly created a chart which would have taken knowledge of defining the charts in XML to achieve in NAV 2009. This can be done by any user of NAV as a way of quickly visualising any data they have access to.

Data Visualisation and 安博电竞 Intelligence - 安博电竞 NAV 2013 Charts - Sales Balances

As mentioned charts can now easily be created without being based on an existing list. The Generic Charts list (CRONUS UK Ltd./Departments/Administration/Application Setup/RoleTailored Client/Generic Charts) contains 45 charts which contain some good examples of this functionality.

For example the Top-10 Prod. Orders chart below would take very little time to create:

  • Click New to create a new record and enter an ID and Name
  • Enter a source type and ID
  • Select the fields to use for each axis

Data Visualisation and 安博电竞 Intelligence - 安博电竞 NAV 2013 Charts - Chart Editor

Once the chart is defined you can add a chart part to a role centre, customise the part to select the chart to display in it and you chart is finished.

Data Visualisation and 安博电竞 Intelligence - 安博电竞 NAV 2013 Charts - Role Centre

Both types of charts have a lot of potential and I look forward to seeing how a customers use them in the future.

David Curd

Dave is one of the longest serving members of our support team. His technical expertise means that he can provide support to even the most complex support problem, whether that is in 安博电竞 NAV, 安博电竞 365 安博电竞 Central, or for something more back end such as SQL or Azure. 

Partner with the Experts

With over 300 years of combined experience in Microsoft business solutions, our team will help to get you up and running, as well as building a partnership that keeps you supported, all from our UK offices. 

From functionality and licensing to business strategy, we like your questions; contact our experienced team for open, honest and reliable advice so that we can find the answers.

飞鱼电竞押注网站 28加拿大记录手机版数据 江湖电竞最新版比赛(江湖电竞投注app网站) 金沙电竞app pc加拿大28计划最稳胆码授权平台 街霸5(上海)查询APP v8.6