Though the AX SSRS extension has improved the capability of AX reports, it is still to catch up with the actual SSRS. Features such as map and a few other graphical additions to reports are yet to make way into it. However, there is a way to bring nice map reports to AX through SQL Report Builder. This recipe will extend our previous recipe to add a map data, which will then be added as a sub-report.
This recipe requires that you have installed and have access the Report Server Manager and Report Builder. This recipe is a continuation of the recipe, Designing an OLAP table report with SQL Report Builder, in this chapter.