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>

Related Content you might be interested in

Current Title:

Small book image
Developing SSRS Reports for Dynamics AX
Mukesh Hirwani
Sep, 2013 | 132 pages
No titles found
Table of Contents (17 chapters)
Developing SSRS Reports for Dynamics AX
Developing SSRS Reports for Dynamics AX
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Developing a Simple SSRS Report in Visual Studio
Developing a Simple SSRS Report in Visual Studio
Reporting services modes
Walkthrough – Create an Auto Design report with AX Query
Walkthrough – Creating a drill-through report
Summary
2
Developing Advanced Reports in Visual Studio
Developing Advanced Reports in Visual Studio
Common controls
Walkthrough – Creating a Matrix report
Walkthrough – Creating a Chart report
Summary
3
Developing a Report from an External Data Source
Developing a Report from an External Data Source
Walkthrough – Creating a report using an external data source
Summary
4
Importing Reports from Visual Studio to AX and Report Deployment
Importing Reports from Visual Studio to AX and Report Deployment
Adding a report to Visual Studio Project
Adding a report project to the AOT
Report deployment
Summary
5
Using Controller and User Interface Builder Classes
Using Controller and User Interface Builder Classes
The Model-View-Controller
The Controller class
The UI Builder class
Summary
6
Developing Reports Using RDP and Report Contracts
Developing Reports Using RDP and Report Contracts
The Report data provider class
The Report contract class
Walkthrough – Creating an Auto Design report using the RDP class
Walkthrough – Creating a Precision Design report
Walkthrough: Creating a report with parameters
Summary
7
Customizing Existing Microsoft Dynamics AX Reports Using Visual Studio
Customizing Existing Microsoft Dynamics AX Reports Using Visual Studio
Editing existing reports in Visual Studio
Enabling a sort order for Sales order ID
Adding parameters to control the data displayed in the report
Summary
Common SSRS Expressions
Common SSRS Expressions
String functions
Common Standard AX Classes and Methods
Common Standard AX Classes and Methods
Common classes and their purpose
Common methods and their purposes
Reporting Best Practices
Reporting Best Practices
Best practices for AX 2012 report development
Index
Index

The Controller class

The Controller class acts as the controller of the Model-View-Controller design pattern. In AX, the controller role is played by the SrsReportRunController class. The Controller class performs the following activities:

  • Calls SrsReportRunInterface to parse RDL

  • Gets report contracts

  • Creates necessary UI Builders and invokes them

  • Call to validate on contracts

  • Saves to the SysLastValue table

The Controller class must be overridden in the following mentioned scenarios:

  • Change contracts before running a report. For example, to change the query based on the parameters in the form. For this, the modifyReportContract method is used.

  • React to form controls events. For this, override methods/events are used.

  • Add validations which are not part of the contract class or report data tables. For this, override the validate method and call the super method.

  • Change the report name or design based on parameters to add capabilities of rendering multiple reports or multiple report designs using the...

Previous Section
End of Section 3
Next Section