Skip to Content
0

How to hyperlink files present in a server to BO report

Apr 04 at 11:33 AM

41

avatar image

Hi experts,

I am trying to hyperlink files which are not uploaded in BI launch pad(present in separate server) to BO reports.

Scenario:

For serveral WO's we have some attachments. Like say 12345 is a WO no.For that I have 3 files in the D drive of the server named
012345_01_Details_of_the_WO.doc

012345_02_WO_screenprint.pdf

012345_03_WO_extra_info.xls

Similarly for other WO, there can be no, one, ten i.e any number of files with different names and extension present in the location.

Requirement:

For all WO's in the Report we have to add a column named attachments, where a hyperlink will be created. On click all files for that particluar WO will get downloaded.

Result:

For now , we have added a hyperlink as:

= "<a href =\"file:\\\\servername\\Archive\\New\\012345_01_Details_of_the_WO.doc\" title=\"\" target=\"_blank\" nav=\"web\">Attachments</a>"

Here, since we have mentioned specifically the file location it is opening that file only.

But the requiremnet is to dynamically pass the WO number, so that it fetches all the files that start with the WO number irrespective of the extension.

How can we change the code to do this??

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Bharath B N Apr 04 at 05:45 PM
3

You can't change code in BI Launchpad Hyperlink creation workflow.

Create .html file with one text box and button, Add .html link to Hyperlink.

Once User clicks on hyperlink , it opens html page there you can ask user to enter some data and based on that you can perform any actions.

-

Bharath

Share
10 |10000 characters needed characters left characters exceeded