Thursday, 10 March 2016

DrillThrough Report in SSRS

1.  Open the report for which DrillThrough functionality needs to be applied.
2.  Create a new datamethod as shown below
















3. Rename the newly added dataMethod to VoucherDrillThrough
4. open the dataMethod VoucherDrillThrough and we will find the newly added Business logic project added to the same solution as shown below.


5.  Navigate to View > Application Explorer > Visual Studio Projects > C# Projects > SRSDrillThroughCommon as shown below
6.  Double click SRSDrillThroughCommon C# project, it will be added to our solution as shown below. Then, right click Reference > Add Reference > in the Businesslogic (VendorInvoiceSpendReport.BL) as shown below



7. Double click on data method and add the namespace
using.Microsoft.Dynamics.AX.Application.Reports; and add the following method as shown in the screen shot below.


8. Now the Datamethod is ready, Select the field for which drillThrough is required as shown below and select textbox properties.


9. Write the expression by passing the required parameters using the datamethod name


10.Save and deploy.
11. Follow the below link to resolve the errors after deploying

https://community.dynamics.com/ax/b/ax2012r3technicalconsultantblog/archive/2015/05/12/dynamics-ax-2012-r3-report-deployment-error-with-visual-studio-2013-loading-this-assembly-would-produce-a-different-grant-set-from-other-instances

12. Redeploy it again and deploy.





No comments:

Post a Comment