I did a quick search on BOB and didn’t find an answer to this so I’ll post my own findings here.
Only read on if you have had trouble displaying your html coded hyperlinks (using Read as HTML format) in PDF or Excel format where the hyperlink gets displayed as the raw html code when exported from WebI.
I’ll use the following as a basic example:
="<a href=\"http://www.forumtopics.com/busobj/index.php\">click here to go to BOB</a>"
With the cell property set to Read as HTML (which is what you’d expect to set it as) the hyperlink is displayed correctly in InfoView, however, the full raw code as shown above will be displayed in PDF or Excel format.
Instead, set the cell property to Read as HYPERLINK.
It appears that WebI is smart enough to correctly display the text click here to go to BOB as a hyperlink in InfoView, PDF and Excel format, instead of displaying the full code ="<a href=“http://www.forumtopics.com/busobj/index.php”>click here to go to BOB" as the text - notice that I said text , and not a hyperlink.
This feature was tested successfully in WebIntelligence 6.5 with more complex hyperlinks such as the following report to report (drill-across) link:
I know this may sound like commonsense and straight forward but i’m sure there are plenty of others out there that have ran into the same problem too and will make good use of this info…or maybe that’s just wishful thinking
Thats fine for hyperlinks but I have an oracle table containing complex html statements that are fine in the standard HTML view but do not display in PDF regardless of formatting.
I have had a case open with BO for this for several weeks. They sent us Hotfix 846 but this did not work!
Hi Fu Li
you cannot imagine how much your solution helped me.everything was fine in webi but the real problem started when they saved it as excel.no values but only crap code.I am sure you know the furious looks of 20 business users.
Thank you so much for saving me.
Glad my suggestion could help somebody out. I did my testing in WebI 6.5.1.
When you click on a table cell, go to the Cell Properties options (on the left side of the screen) and find a checkbox called Read contents as: (under the Display heading).
When you click on this checkbox, there should be three options available in the drop down list next to the checkbox:
Hi Fu Li,
For somereason I am not able to find the option.we are developing the report in full client & publishing as webi report.All that users will do is open & take a print of the report.The options you have mentioned are in fc or webi?Please help
Just fyi… I don’t know if this will help but I found it interesting that my Hyperlink will not work when my cell font was ‘wingdings’. I changed it to arial and it works fine… Note: It works fine when displayed in HTML, but I did not get the hyperlink when viewed as PDF.
I wanted wingdings so I could create a clickable ‘bullet’.
(BOB member since 2004-07-01)
(BOB member since 2002-10-04)