We can't click or right click the link on the WebI report that usually downloads an Excel sheet, However we can click it when we export the report to PDF format or opening through an Internet Explorer, however Chrome and Edge is not recognizing the link.
Below are the script used for the link
=If([Condition_A]="(Unknown)") Then "<a href='"+[File_Location]+"' target=_blank>LINK</a>" Else "<a href='"+[File Location_2]+"' target=_blank>LINK</a>"
Please do provide an Solution