Blog

Name is Anant Dubey and the intent to create this blog is to discuss the problems and issues that developer face in the dynamics AX development and to share the new things that come up with the new version of AX.

Monday, November 14, 2016

How to create SSRS report using Report data provider (RDP Report) in AX 2012

2 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. This is an excellent and highly detailed guide on developing a Business Logic-based (RDP) SSRS Report in Microsoft Dynamics AX 2012 R3! Thanks for providing such a clear, step-by-step walkthrough, especially focusing on the foundational steps of creating a temporary table and project.

    You've done a great job of explaining the overall RDP report development process (temporary table, parameters, business logic, reporting project, data provider class) and then diving straight into the practical implementation within the AX 2012 AOT.

    The specific instructions are precise and incredibly helpful for Dynamics AX developers:

    Opening the AOT and creating an AX project: A good practice for organizing report artifacts.

    Creating and configuring the temporary table (CustomerSalesTemp): This is a critical first step in RDP reports, and your detail on setting TableType to TempDB and dragging fields from SalesLine is spot-on.

    Renaming fields and adding new ones: Essential for a well-structured and readable report.

    Compiling and synchronizing the table: A crucial step to ensure the table is properly recognized by the system.

    Your chosen scenario (listing item, quantity, price, and total amount sold to customers) is simple enough to illustrate the RDP framework effectively without getting bogged down in complex business logic at this initial stage.

    This post provides a fantastic foundation for anyone looking to develop custom SSRS reports in Dynamics AX 2012 R3 using the RDP framework.

    For more discussions on Dynamics AX development, SSRS reporting best practices, or advanced data modeling for business intelligence, a hacking forum (or perhaps a more specialized developer/ERP forum for AX specific issues) would be an excellent place to share knowledge and solutions.

    ReplyDelete