Developing SSRS Reports for Dynamics AX

by Mukesh Hirwani

In Detail

SQL Server Reporting Services is the primary reporting platform for Microsoft Dynamics AX. Nowadays every business demands reports ranging from showing an aggregate view of their business performance to the transactional data formatted in a way that can be easily filtered, printed, and emailed. SQL Server Reporting Services allows you to do all this and more, quickly and easily.

Developing SSRS Reports for Dynamics AX 2012 covers all the technical aspects of AX 2012 reporting, taking you through various step-by-step guides to quickly develop reports. It encapsulates various real-time scenarios and walkthroughs which will guide you step-by-step to develop reports. You will then go on to learn about various performance-related measures to help you develop or customize reports for Dynamics AX 2012 more efficiently.

Developing SSRS Reports for Dynamics AX 2012 is completely based on Microsoft Dynamics AX 2012 report development. Developing SSRS Reports for Dynamics AX has been written in a way to make reporting complex components quicker and easier. You will come across day-to-day scenarios to perform report development.

Learn various mechanisms of developing reports in Visual Studio for Dynamics AX 2012. Develop reports using various types of data sources like AOT Query, external data source, and Report Data Provider class. You will also learn various performance enhancement techniques that will help you to manage complex reporting requirements.

Approach

Written as a step-by-step tutorial, covering all technical aspects of AX 2012 reporting to enable you to quickly learn to and develop reports.

Who this book is for

This book is ideal for developers and administrators, who deal with Microsoft Dynamics AX 2012 reporting in day-to-day scenarios. No prior exposure to Dynamics AX 2012 reporting is assumed. Readers must know about AX architecture, about the AOT, basic X++ skills, and the basics of SSRS.

132 pages, Paperback

First published August 24, 2013

Reviews

[Palle Agermark]

This short book is a great book if you don't have much experience with SSRS report development for Dynamics AX and just need to get started.

The book explains how to develop reports with auto design and precision design. On a little more advanced level it also explains how to create drill through reports, matrix and chart reports. All of these areas are explained through straightforward steps to follow.

Report deployment and maintenance is also covered.

A particular nice chapter covers the UI for reports and the related data contacts. If you have trouble understanding the Model-view-controller (MVC) pattern used in AX 2012, I can really recommend this chapter.

For reference the book has a good appendix with list of common functions, and do's and don't lists for AX report development.