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

Adding parameters to control the data displayed in the report

Tom, the Sales manager, also wants an "Order lines not posted" report available under Accounts Receivable | Reports | Transactions | Sales Orders to have a parameter to perform a filter on the Sales category.

To add a new parameter to an existing report, perform the following steps:

  1. Open Microsoft Visual Studio 2010 from the Start menu.

  2. Click on View | Application Explorer.

  3. Browse for the SalesNotInvoiced report under AOT | SSRS reports | Reports.

  4. Right-click on the report and click on Edit.

  5. Browse to the report parameters.

  6. Right-click on parameters and navigate to Add | Parameter.

  7. Rename the parameter to SalesNotInvoicedDP_SalesCategory.

  8. Change the Prompt string property to Sales category.

  9. Right-click on the report design named Report and navigate to Edit using Designer.

  10. Right-click on Tablix and select Propert ies.

  11. Switch to the Filters tab and click on the Add button

  12. Provide the below values in the filter:

    1. Expression as [SalesCategory_Name...

Previous Section
End of Section 4
Next Section