Hyperlink on Field for SSRS report in D365FO
My requirement is to open a report on sales order or a transfer order depends on the caller.
After running the report it should open the sales order based on SalesId
Change the below properties
1. Color
2. Textbox properties > Action >Go to URl > select URL
Write the below code in expression
=Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GenerateDrillThroughLink(Parameters!AX_ReportContext.Value, Parameters!AX_UserContext.Value, "SalesTable", "Display", "SalesTable", "SalesId", First(Fields!AGCReference.Value, "PalletLabelsPrintTmp"))
Format:
3 | =Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GenerateDrillThroughLink( Parameters!AX_ReportContext.Value, Parameters!AX_UserContext.Value, "[MenuItemName]", "[MenuItemType]", "[TableName]", "[FieldName"], "Field value") |