Forum Discussion

Alta88's avatar
Alta88
Icon for Helper IV rankHelper IV
4 years ago
Solved

Adding Hyperlinks to a Table

We send out daily reports to another team so the managers can relay any errors cited during our audits. The trouble is, the IDs to the accounts we review are dead - they can't take the user back to t...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    You can create a measure that builds the URL to use.  In my example I have one that builds a URL to the nih.gov site using a drug code.

    Drug Search NIH =
VAR _DrugCode = SELECTEDVALUE ( vDRUGCODE[Drug_Code] )
RETURN
IF ( NOT ISBLANK ( _DrugCode ),
"https://mor.nlm.nih.gov/RxNav/search?searchBy=NDC&searchTerm="& _DrugCode)

    Then you use conditional formatting on the field and set this as the Web URL.

    That will make it a clickable link in the report:

     

     

Alta88's avatar
Alta88
Icon for Helper IV rankHelper IV
4 years ago

Yeah, it's really weird. So I opened a new report and added data to a new table and the option finally showed up: 

 

 

Something must be wrong with that specific file then. How do I get bugs out of a file? I don't want to build that report from scratch since we send it out daily.