I am trying to embed a hyperlink in my report that would enable users to navigate to another report if there is user detail available for that particular Application (See attached screenshot).  I'm having trouble determining which hyperlink to use for the target report.  It looks like when I simply got the the report an copy the URL, it has my name embedded.  Also, it looks like the links are different between DEV/STG/PROD.  Which link do I use fro this functionality to work.  There must be a way because it somehow know the link if I were to create a Drill-To.@Chris Davidson

You could use the wiki style syntax and the EvalWiki formula to encode your hyperlinks (See HERE and HERE for details, and HERE for help with the encoding instead of the dated link in that first article).

The simplified explanation is to determine the wiki style link to the other report (that would typically only be used in an HTML or Button object) using the documentation in that first link.  You can add that to a calculated column in your report table by using the Advanced format in the Edit Column dialog, and use =EvalWiki("<your wiki link>") as the 'User defined formula' section to the right of Format.

The end result is a dynamically determined hyperlink based on the currently logged in user and situation.