I have found a number of discussions on opening Business Ojects Documents using hyperlinks (ahref html tags/javascript) but none have been helpful so far- It’s probably my understanding !
Here’s what I wish to do :
I’m building my report on BO 6.5.1 , I have a universe field ‘fieldname’ which contains the complete path to pdf files stored on the server
example value : Filename = \\lvl_x_doc\stl\out\STL27052009154810JOHNSOND.pdf
When I add the field to the report it displays the correct path on the report - Now I want this to be hyperlinked to the same location so when the user clicks on the report field it opens the file in the given location.
(I have tried using ahref tags , but the entire tag appears on the report and no link is added - i’m problable doing something wrong?
this is what i do using freehand sql:
select
'<a href=file:"'|| filename|| '">clickme</a>' filename
from ids_icr_mart.find_documents where filename is not null and rownum < 100
)
Can this be done in BO 6.5? Would appericiate a simple explanation as there isnt any already on the forum.
Thanks for your help in Advance.
Solved now :- I created a new variable with formula
=Hyperlink( <FILENAME> ,"View" )
which did the trick.
niteshsabharwal (BOB member since 2009-07-02)