Reporting overview

Dynamics AX 2012 has extensive reporting capabilities like Excel, Word, PowerPivot, Management Reporter, and most importantly the SSRS reports. While there are many methodologies to generate reports, SSRS remains the prominent way to generate analytical and transactional reports. SSRS reports were initially integrated in AX 2009 and today it has replaced the legacy reporting system with AX 2012.

Through the recipes in this chapter, we will build the released products report. The released products report will list all the released products under each item group. This report will use the query datasource to fetch data from Dynamics AX and subsequently create an auto design based report. This report will then be deployed to the reporting services and will be attached to a menu item in AX so that it can be displayed inside the rich client.