Hyperlinks can be embedded in Blitz Report excel output files using the syntax:

HYPERLINK(“URL to the location”, “alternate text”)

Here is an example:

select 
hp.party_number,
'HYPERLINK("'||case when hp.url like 'http%' then null else 'https://' end||hp.url||'","'||replace(hp.party_name,'"','""')||'")' party_name,
hp.party_type
from 
hz_parties hp
where
hp.url is not null

This generates the following output:

Blitz Report hyperlink example

Here is another example fetching the location of FND Documents and the application of the document.

Report Text

The below image shows the output from the report:

Report output

Author: