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

Common classes and their purpose


The following table lists common classes and their purpose:

No

Class name

Description

Used ideally

1

Report data provider class (RDP) extends to SRSReportDataProviderBase

Report data provider class is used to build up datasets and populates values in them using a complex set of business logic.

When data is to be fetched from multiple queries and also includes complex calculations.

2

Report data provider (RDP) contract

Use attribute: [DataContractAttribute]

RDP contracts are used to provide parameters to the report. On the basis of which, queries get executed during report processing, and fetch data from the database.

When specific parameters are required to filter data in the report.

3

Print contract extends to

SrsPrintDestinationSettings

Contract which contains all contracts like query contract, print contract, RDP contract, RDL contract once report RDL is parsed.

Not to be overridden.

4

Query contract. No class, instead a map object which contains parameters and a query object.

Contract which provides a query contract to the report.

Not to be overridden.

5

Controller extends to SrsReportRunController

The controller for a set of reports having the same functionality. This class controls the behavior of the reports, like on the basis of a caller, which reports to render.

When multiple designs are available for a report or multiple reports are rendered using the same controller.

6

UI Builders extends to SrsReportDataContractUIBuilder and SysOperationAutomaticUIBuilder

UI Builders are used to provide a layout to various parameters we add using contracts. Also, we can control the behavior of contracts using the UI Builder class.

Proper UI has to be built up or the parameter behavior has to be modified.

7

Preprocess: SrsReportDataProviderPreProcess

The Preprocess class prepares the data, before the report is rendered to the user in report viewer control.

When dealing with huge data and reports take a long time to run which may lead to time-out issues.