Generate Drill through link/Hyperlinks for SSRS report in D365
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 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;
}
For the action on the textbox:
=Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GenerateDrillThroughLink(
Parameters!AX_ReportContext.Value,
Parameters!AX_UserContext.Value,
table name,
[field name, field value])
The name of the menu item target for the hyperlink
The type of the menu item target for the hyperlink (e.g. “Display”)
The name of the table referenced by the target menu item
The name of the field in the table to restrict
The value of the field in the table to restrict
Optional
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
Post a Comment