SSRS report through drill through action URL

Today I will be discussing about how to drill through action URL to a field in an SSRS report. Basically a drill through report is a report that a user opens by clicking a linked item in another report. It allows the users to drill through additional data.

Lets say we want to create a hyper link for invoice id field in Payment journal report in AX.

Step 1) Open visual studio and go to view menu and select application explorer.

Step 2) Expand AOT and navigate to Visual studio project -> C sharp projects -> SRSDrillThroughCommon project and edit it.

Step 3) Open DrillThroughCommonHelper class and search pre build method for vendor invoice journal form.

Step 4) Open your report from AOT. In my case its ledger journal and add data method into it. It will add business logic class to your project where you will write code for calling drill through method.

Step 5) Add a reference of SRSDrillThroughCommon project in business logic project.

Step 6) Open LedgerJournal.cs class and implement DrillInvoiceNumber method.

Step 7) Now open report in designer and right click on properties of invoice id text box. Go to action tab and select go to URL radio button and add expression in it.

Step 8) Change font color of text box to blue.
Step 9) Change access properties of SRSDrillThroughCommon and LedgerJournalReport.BusinessLogic where you need to set Deploy to client to yes.
Step 10) Build and deploy.
Step 11) Go to Account payable -> Journals -> Payment -> Payment Journals -> Select journal -> Lines -> Print -> Journals. Click on invoice id and it will navigate to invoice journal form and highlight the row of clicked invoice number.