AX 2012: SSRS Report Drill Through Action URL

In this post we'll learn how to add a drill through action URL to a field in an SSRS report. The focus will be more towards exploring drill through action URL rather than developing SSRS report. We'll be using an RDP report with precision design to demonstrate the development. Let's say we have a requirement … Continue reading AX 2012: SSRS Report Drill Through Action URL

AX 2012: Multi-Select Lookup for SSRS Report Dialog

Overview: In this post we'll learn how to build multi-select lookup for SSRS report dialog. We'll create an RDP report with an AutoDesign layout. Controller will be used to run the report. An output menu item will be created to point to the controller class. Each AOT element involved will be described in detail. You … Continue reading AX 2012: Multi-Select Lookup for SSRS Report Dialog

AX 2012: Add Report Parameter to SSRS Query Report

In this post we'll learn how to add report parameter and show it in the report dialog for a Query based SSRS report. Please follow the development steps below to achieve it: 1. Create an AOT Query MAKCustTable. 2. Drag CustTable table to the Data Sources node of the query. 3. Set Dynamic property to … Continue reading AX 2012: Add Report Parameter to SSRS Query Report