Designing a map sub-report with SQL Report Builder
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.
Getting Ready
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.
How to do it
Continue with your last report by stretching the borders of the report to make some space to insert a new control. On the Insert ribbon bar, select Map | Map Wizard.
In the wizard, choose USA by State Exploded and click on Next.
Let's use the same dataset that was added, so set the option to choose the...
