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 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:

Untitled

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.

Untitled

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

Untitled

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

Untitled

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

Untitled

Untitled

7. Add reference of SRSDrillThroughCommon project to MAKHcmWorker.BusinessLogic project.

Untitled

8. Open MAKHcmWorker.cs and add namespace using Microsoft.Dynamics.AX.Application.Reports.
9. Rewrite the drillHcmWorker() method to have the following definition:

using System;
using System.Collections.Generic;
using System.Security.Permissions;
using System.Data;
using Microsoft.Dynamics.Framework.Reports;
using Microsoft.Dynamics.AX.Application.Reports;

public partial class MAKHcmWorker
{
    [DataMethod(), PermissionSet(SecurityAction.Assert, Name = "FullTrust")]
    public static string drillHcmWorker(string reportContext, string personnelNumber)
    {
        return DrillThroughCommonHelper.ToHcmWorker(reportContext, personnelNumber);
    }
}

10. Now edit the precision design using Designer. Select Name field to access its Action property.

Untitled

11. Click on the ellipsis icon. In the hyperlink options, choose Go to URL.

Untitled

12. Give the following expression:

=drillHcmWorker(Parameters!AX_ReportContext.Value, Fields!PersonnelNumber.Value)

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 🙂

Untitled

Advertisements

One thought on “AX 2012: SSRS Report Drill Through Action URL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s