Forum Discussion
Alta88
Helper IV
Helper IVAdding 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...
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:
Alta88Helper IV
Helper IVSo I tried that too, but no luck. This is very bizarre.