I know I can place a Single link on a section of a report.
However, for a generated report that goes out to users (like an html page or a pdf or excel file), can I code the data results to DISPLAY one text (like a Short account number, 12345), but then have it be a lengthy hyperlink that can be clicked to go the URL?
Perhaps a Calculated Field that is AccountURL that is calculated as "www.myurl.blah?Account=
" || AccountNo , or something similar? I have done it as such a field, but that DISPLAYS the entire lengthy URL, but I would like to have it be more of an intelligent Hyperlink that JUST SHOWS the Short Account Number.
----- Report1 ------
Account Name Total
12345 Smith $500
45222 Jones $300
34428 Taylor $200
------ Generated by EM -----