How to add a hyper-link for treport that’s when the user press on the vendor n

mohmd
mohmd Member Posts: 51
How to add a hyper-link for the above report that’s when the user press on the vendor name it will open
Vendor Card.
 

Best Answer

Answers

  • mohmd
    mohmd Member Posts: 51
    what field i select in URL
    concern on what
    my aim is when the user press on the vendor name it will open
    Vendor Card.
  • mohmd
    mohmd Member Posts: 51
    what lin should i choose
  • mohmd
    mohmd Member Posts: 51
    what link should i choose
  • Kishorm
    Kishorm Member Posts: 921
    You need to include the hyperlink field in the dataset. Have a look at "ItemHyperlink" in report 1004.
  • Kishorm
    Kishorm Member Posts: 921
    u86tr7xcwpfd.png
  • mohmd
    mohmd Member Posts: 51
    i do a field hyperlink and i rght this link but it doesnt work
    DynamicsNAV:////runpage?page=30&mode=edit&bookmark="+FORMAT(Fields!venodorname.Value)
    {DynamicsNAV:////runpage?page=30&mode=edit&bookmark="} this link i copied from a report
    how i correct the link
    whats the correct link
  • mohmd
    mohmd Member Posts: 51
    report 1004 dont found in my nav
    i install nav 2017
  • Kishorm
    Kishorm Member Posts: 921
    See the above screenshot for what code to put in the DataItem and the OnAfterGetRecord (just tweak it to use the Vendor table and "vendor card"). In addition, below is the code for the GenerateHyperlink function...
    LOCAL GenerateHyperlink(Bookmark : Text[250];PageID : Integer) : Text
    IF Bookmark = '' THEN
      EXIT('');
    
    // Generates a URL such as dynamicsnav://hostname:port/instance/company/runpage?page=pageId&bookmark=recordId&mode=View.
    EXIT(GETURL(CURRENTCLIENTTYPE,COMPANYNAME,OBJECTTYPE::Page,PageID) +
      STRSUBSTNO('&bookmark=%1&mode=View',Bookmark));