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

mohmd

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.
 

Kishorm

Have a look at report 1004 "Close Inventory Period - Test" - this does a similar thing for the Item card. Basically you...

1) Include a field in the dataset for the hyperlink

2) On the field on the report select "Text Box Properties" --> Action, then click the "Go to URL" option and select the Hyperlink field in the "Select URL" field

Kishorm

Have a look at report 1004 "Close Inventory Period - Test" - this does a similar thing for the Item card. Basically you...

1) Include a field in the dataset for the hyperlink

2) On the field on the report select "Text Box Properties" --> Action, then click the "Go to URL" option and select the Hyperlink field in the "Select URL" field

mohmd

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

what lin should i choose

mohmd

what link should i choose

Kishorm

You need to include the hyperlink field in the dataset. Have a look at "ItemHyperlink" in report 1004.

Kishorm

mohmd

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

report 1004 dont found in my nav
i install nav 2017

Kishorm

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