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

Common methods and their purposes

The following table lists the common classes and their purposes:

No

Method name

Description

1

Process report: SrsReportDataProviderBase .ProcessReport()

This method is called by SSRS at runtime which is used to execute the business logic and prepare datasets with appropriate values.

2

Parm data contract: SrsReportDataProviderBase .parmDataContract()

This method is used to get or set the data contract for the RDP.

3

E-mail attachment format: SRSPrintDestinationSettings.emailAttachmentFileFormat()

This method is used to provide the file format for an email attachment. Use enumeration: SrsReportFileFormat

4

E-mail to: SRSPrintDestinationSettings.emailTo()

This method is used to provide the ID of the recipient of the mail.

5

Parm report contract: SrsReportRunController.parmReportContract()

This method is used to get or set report contracts.

6

Parm report name: SrsReportRunController.parmReportName()

This method is used to provide a report name which has to be rendered in report viewer.

7

Parm show dialog: SrsReportRunController.parmShowDialog()

This method is used to control the visibility of the report dialog.

8

Pre-prompt modify contract: SrsReportRunController.prePromptModifyContract()

This method is used to modify report contract values on the basis of the caller, before the report dialog is prompted.

9

Pre-run modify contract: SrsReportRunController.preRunModifyContract()

This method is used to modify report contract values before running the report.

10

Add dialog field: SrsReportDataContractUIBuilder.addDialogField()

This method is used to add dialog fields to the report dialog box.

11

Post run: SrsReportDataContractUIBuilder.postRun()

This method is used to execute post run actions.

12

Parm user connection: SrsReportDataProviderPreProcess.parmUserConnection()

This method is used to get or set a user connection for the report in execution.

Previous Section
End of Chapter
Next Chapter