Book Image

Developing SSRS Reports for Dynamics AX

By : Mukesh Hirwani
Book Image

Developing SSRS Reports for Dynamics AX

By: Mukesh Hirwani

Overview of this book

<p>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.</p> <p>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.</p> <p>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.</p> <p>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.</p>
Table of Contents (17 chapters)
Developing SSRS Reports for Dynamics AX
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Common SSRS Expressions
Index

Walkthrough – Creating a Matrix report


Scenario

John, a Sales manager, needs a report in which he could easily understand which customers have given top sales to the business year wise.

This walkthrough illustrates the following tasks:

  • Creating a Report Model project

  • Creating a Matrix report using Auto Design

  • Saving the report to AOT and deploying it to the Report Server

  • Running the report

Prerequisites

To learn and implement the following walkthrough, you must have:

  • Microsoft Dynamics AX 2012 with sample data

  • Microsoft Visual Studio 2010 with Microsoft Dynamics AX reporting extension

  • Microsoft Dynamics SQL Server Reporting Services

Creating a Report Model project

To create a Report Model project, we consider the following steps:

  1. Start Visual Studio and press Ctrl + N to create a new project.

  2. Select Microsoft Dynamics AX under Installed Templates in the left pane, and select Report Model.

  3. Provide a name for the project as SalesAnalysis.

    Screenshot 2: New project

Creating a Matrix report using Auto Design...