Some charts in the Role Center show a wrong axis scale 0-0-0-1-1-1

We recently came across an issue, that if you are using Microsoft SQL Server 2008 Reporting Services some charts in the Microsoft Dynamics AX 2009 Role Center have incorrect axis scale values on the Y-Axis. Instead of values from e. g. 0 to 1000 you only see 0-0-0-1-1-1.

For example the following chart reports are showing an incorrect Y-Axis scale:

Report Library Report
Cust                CashIflowvsCashOutflow
Ledger ActualvsBudget
Vend PurchasesPastXPeriods

This issue does not exist if you are using Microsoft SQL Server 2005 Reporting Services.

The problem is caused by the report design of the affected chart reports. More concrete the Max Value property of the Y-Axis is having the value 1E-06 set which is wrong. Changing the property to 0 (which means Auto) and re-deploying the Report Libraries resolves the issue.

In order to change the Max Value property please follow these steps:

  1. Log on to a PC having Microsoft Visual Studio 2008, the Microsoft Dynamics AX 2009 Client and the Microsoft Dynamics AX 2009 Reporting Tools installed
  2. In the Dynamics AX 2009 Client open the AOT window and navigate to AOT\Report Libraries
  3. Select the Report Library containing the chart report you want to update, click with the right mouse button at it and chose Edit in Visual Studio from the context menu 
  4. Wait until the Report Library was opened in Microsoft Visual Studio 2008 
  5. Open chart report you want to modify by double clicking at it in the Solution Explorer pane
  6. In the tree navigate to Designs\Full\Page
  7. Select the XYChart design you want to modify, click with the right mouse button at it an select Properties from the context menu
  8. In the Properties pane change the property Data Scale Max Value from the value 1E-06 to the value 0 (which means Auto)
  9. Save your changes back to the Dynamics AX 2009 AOT by clicking at the Report Library in the Solution Explorer pane with the right mouse button and selecting Save to AOD from the context menu
  10. Re-Deploy the updated Report Library using the Microsoft Dynamics AX 2009 Report Deployment tool
--author: Czeslawa Langowska
--editor: Alexander Lachner
--date: 27/05/2010
Comments (5)

  1. Helmut Wimmer says:

    Please bear in mind that you not only have to change the design "Full Page", but also the design "RoleCenter" that is available for most reports.

  2. KareemSal says:

    I have been seeking for a solution for this issue but with no luck until I read your post.

    Thanks it resolved the issue.

  3. Horatio Allen says:

    I am having the same issue, but the suggested solution did not work for me…

    Any other suggestion?

  4. Hi Horatio, are you sure that the reports were deployed successfully after you made the change? In our experience the desciption of the change above is all you need to do to resolve the 0-0-0-1-1-1 issue.


  5. Wahaj Rashid says:

    Hi  Horatio,

    Please make sure your deploying reports to right or all culture (languages).

    In my case it was only beung deployed to En-US only. So i was not able to see the change un Ar (arabic) culture.

Skip to main content