Charts

The Windows client can display a set of predefined charts that use Dynamics NAV data. With Microsoft Dynamics NAV, queries can be used as data sources for those charts.

We will use the query defined earlier on in this chapter as the data source of a chart and we will display it on the home page of the Dynamics NAV Windows client.

To define a query as the data source of a chart, perform the following steps:

1. Open the Windows client for Microsoft Dynamics NAV.
2. Navigate to Departments | Administration | Application Setup | RoleTailored Client.
3. Select Generic Charts.
4. Click on New on the ribbon bar to add a new chart.
5. The New-Generic Chart setup page will open as shown in the following screenshot:
   
6. Give the new chart an ID value and a Name value. For example, set ID to 50000 and Name to My Query Chart.
7. On the Data Source tab, select Query as Source Type and 50000 as Source ID.
8. On the Measures (Y-Axis) tab, select Sum_Quantity as Data Column on the Required Measure row.
9. On the Dimensions (X- and Z...