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 report using an external data source


Scenario

This walkthrough illustrates the following tasks:

  • Preparing report data

  • Creating a report project

  • Creating an external report data source

  • Creating a report

  • Modifying report appearances

Prerequisites

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

  • Adventure Works database for SQL 2008 R2

  • Microsoft Dynamics AX 2012 with sample data

  • Microsoft Visual Studio 2010 with Microsoft Dynamics AX reporting extensions

  • Microsoft Dynamics SQL Server Reporting Services

Preparing report data

In order to execute this report, you must download and install the Adventure Works database for SQL 2008 R2.

The Adventure Works database can be downloaded from the following URL:

http://msftdbprodsamples.codeplex.com/releases/view/93587

After downloading, perform the following steps to attach .mdf and .ldf files to theSQL Server database:

  1. Click on Start | All Programs | SQL Server Management Studio 2008 R2 | SQL Server Management Studio.

  2. Connect to...