Friday, 18 September 2020

 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")