Thursday, April 12, 2018

Hyperlinks for SSRS report in D365

Navigate report design->text box  properties-> Action

Example:1  - Single parameter filter
=Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GenerateDrillThroughLink(
Parameters!AX_ReportContext.Value, 
Parameters!AX_UserContext.Value, 
"MenuItemName", 
"Display",  //Menu item type
"Table Name", 
"Field Name", "Field Value")

Example:2 - Multi-parameter Filter
=Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GenerateDrillThroughLink(
Parameters!AX_ReportContext.Value, 
Parameters!AX_UserContext.Value, 
"MenuItemName", 
"Display", //Menu item type
"Table Name", 
"Field Name", "Field Value"
"Field Name", "Field Value")

Add this Method in your FORM. (where Menutiem denotes)

public boolean isRootNavigable()
{
return true;
}

No comments:

Post a Comment

Disabling the flight in D365FO (CHD - Tier 1)

 INSERT INTO dbo.SYSFLIGHTING(FLIGHTNAME, ENABLED)  VALUES ('<FlightObjectName>_KillSwitch', 1)  or  INSERT INTO dbo.SYSFLIGHT...