APEX

Hi,

I have a requirement to open some excel files that are stored in a shared network folder. The complete file path is stored in a table column. I need to display the column in an interactive report and have the column display as a hyperlink, the user will click on the hyperlink and the excel file should open up just like it would open up from windows file explorer. The user would then make changes and save the file (which would save the changes in the shared network folder).

I tried using some javascript to do this, but nothing happens when I click on the hyperlink.

Following is the javascript I have on the report (HTML Header)

<script type = "text/javascript">

function openfile(location){

var filename = '//'+location;

window.open(filename);

}

</script>

In the report attributes for the hyperlink column, I have this:

Display type: Standard report column

Link Text: #FILE_NAME#

Target : URL

URL: javascript:openfile('#FILE_NAME#');

Any help appreciated.

Thanks,

Ashok