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.
