Drill through to a form in SSRS Reports

Once you are with the field for which drill through needs to be activated in SSRS report. Below steps needs to be performed.

1. Edit Visual Studio\C sharp Projects \SRSDrillThroughCommon

2. Search for the required field in DrillThroughCommonHelper.CS file.

3. If you are able to find the required field proceed with step 6

4. If no, declare menu item, field and table name and create a method to render drill through URL by passing above declared values.

Ex:

 public static string ToSalesUnitId( string reportContext, string reportFieldValue)

{

Return GetDrillThroughUrl(reportContext, FormMenuItemName, webmenuitemname(You can use string.Empty if webmenuitem doesnot exist), TableName, FieldName, reportFieldValue  )

}

5. Build and Deploy SRSDrillThroughCommon CSharp Project

6. Add a datamethod to required report.

7. In C sharp project add SRSDrillThroughCommon as reference.

8. Edit Datamethod and call the method which you have created in SRSDrillthroughCommon helper.cs.

Add Microsoft.Dynamics.Ax.Application.Reports and Microsoft.Dynamics.Framework.Reports name spaces.

9. Build and deploy the whole solution Project.

10. Right Click the text box where you need Drill through and Select Textbox properties. Under Action Tab of the window select Go To URL and Click Expression button.

11. Enter the expression to call drill through data method which is created in step 6.

You can use ProjWIPProj standard report for simple reference.