Skip to main content

Notifications

Announcements

No record found.

Generate Drill through link/Hyperlinks for SSRS report in D365

Sukrut Parab Profile Picture Sukrut Parab 71,671 Moderator

Here is new way to generate hyperlinks for SSRS reports in D365O

For the action on the textbox:
=Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GenerateDrillThroughLink(
Parameters!AX_ReportContext.Value, 
Parameters!AX_UserContext.Value, 
<drill target menu item>, 
<drill target menu item type>, 
<table name>, 
<field name>, 
<field value>
[, <field name>, <field value>])

<drill target menu item>
The name of the menu item target for the hyperlink

<drill target menu item type>
The type of the menu item target for the hyperlink (e.g. “Display”)

<table name>
The name of the table referenced by the target menu item

<field name>
The name of the field in the table to restrict

<field value>
The value of the field in the table to restrict

Optional
Additional <table name> and <field name> pairs as needed


Example:

=Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GenerateDrillThroughLink(
Parameters!AX_ReportContext.Value,
Parameters!AX_UserContext.Value,
"MenuItemname",
"Display",
"CustInvoiceJour",
"InvoiceId",
Fields!InvoiceId.Value)

Also, you must add this method to the form that the menu item opens (the error message doesn’t tell you this):

public boolean isRootNavigable()
{
boolean ret;

ret = true;

}

Comments

*This post is locked for comments