cancel
Showing results for 
Search instead for 
Did you mean: 

BEx report field as hyperlink

StevenvV
Explorer
0 Kudos

Hi,

In a BEx report there will be a field populated with a hyperlink address. When running this report in BEx, will the content be activated automatically as hyperlink. Meaning that the content just needs a click to go to the corresponding website of the cell content?

This is the requirement of the client and as their is no web portal, we can not implement web reports (limited budget).

How to enable such a thing? Any ideas?

Thanks

View Entire Topic
StevenvV
Explorer
0 Kudos

Well, a field populated with e.g. http://www.google.com will be availble in BEx reporting. And in the analyzer i want this field to be active, meaning that clicking on the 'http://...' in the excell sheet will lead to the site.

Is there a way to install this? standard a hyperlink is not active as BEx puts a ' infront of every value in a BEx Analyzer sheet.

Regards,

Steven

christopherdcosta
Participant
0 Kudos

The simple answer is no you can't do this in your query design.

However, you might be able to abuse the report results, from Bex if you execute the report into Excel workbook, because MS excel has a standard functionality that looks for text that "looks like" either an email address or a hyperlink.

I haven't tried this though and you'd probably have to disable the data refresh - which ends up being pointless.