Month: December 2014

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 to open HcmWorker form when user clicks on the Name of the worker in the SSRS report. Before adding the drill through URL our simple report looks like below showing list of workers:

To add the drill through URL to open HcmWorker form on clicking Name field on the report, please follow the development steps below:

1. Open the Visual Studio project of the report.
2. Go to Application Explorer > Visual Studio Projects > C Sharp Projects > SRSDrillThroughCommon.
3. Right click and Edit the project. A project node for SRSDrillThroughCommon will be added in the Solution Explorer.

4. Open DrillThroughCommonHelper.cs and search for the pre-built drill through method to open HcmWorker form.

5. Expand HRM Helpers region. You’ll find a method ToHcmWorker(). We’ll be referring to this method in a while.

6. Now add a data method to the report drillHcmWorker. This will add a BusinessLogic project to the Solution Explorer.

13. Change the font color to Blue.
14. Access properties of MAKHcmWorker.BusinessLogic project. Set Deploy to Client to Yes.
15. Access properties of SRSDrillThroughCommon project. Set Deploy to Client to Yes.
16. Build and Deploy the report.

We are good to run the report to see the drill through URL in action 🙂

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 can guess the complexity of this development task by looking at the AOT elements required for it:

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 Yes on the Fields node to add all the fields available in the table quickly.
4. Keep the following fields only and remove others. Then set Dynamic property to No.

5. Open Visual Studio to create a new Project of type Report Model using Microsoft Dynamics AX installed template.
6. Add report to the project MAKParametersReport.
7. Add Dataset to the report and choose the query MAKCustTable we have just created.

8. Drag the dataset MAKCustTable to the Designs node. This will create an AutoDesign layout and Table control with fields added.

9. Now Build and Deploy the report from Visual Studio.
10. After successful deployment, you should find MAKParametersReport in the AOT > SSRS Reports
11. Create an output menu item for the newly created SSRS report.
12. Open the report using menu item.

13. By default, Customer account is the only report parameter in the dialog.
14. Now to add more report parameters, update the AOT query MAKCustTable to have the following ranges added:

15. Back in Visual Studio, refresh the dataset.

16. Save, Build and Deploy the report again from Visual Studio.
17. To see the changes, open the report using the existing output menu item.

For your information, the MAKCustTable_DynamicParameter collectively holds all the ranges defined in the Dataset’s query. Make sure its properties are set as shown here: