Hyperlink to Data Source

Robert Mason shared this question 8 months ago
Answered

How can I create a hyperlink in the BI Report that will take the user to the actual data source

Example. If creating a report on Claims, I want the user to be able to click on the visit ID to be taken to the actual visit in our EMR.

Comments (3)

photo
1

Hi Robert,


Thank you for your question. I am going to make the assumption that your EMR site allows a visit to be accessed via a URL link just the ID appended (eg. https://myemrdb.com/visitID=12345), if this is incorrect, please let me know more specifics and I will correct my answer.


In the above instance, if you edit the Format of the VisitID field and change the format to Link To URL you will be able to specify the external URL for your EMR and append the ID from that field by using ##. Please see the demo below to run you through the process. If anything is unclear, please let me know.


e5cced1c811e1d0fd7b8114d82e6bddb

Cheers,

Neal

photo
1

With some tweaking this did work. Thanks

photo
1

Hi Robert,


Glad you were able to get this running. I'll mark this as complete, but let me know if you need any more assistance with this.


Cheers,

Neal