Hyperlink not working in Excel

[visopenlive]

Hai all,

I developed a live report and displaying the output using webreport. One field (location) is hyperlink so that, when it is clicked it opens the document. This works when output is html. But user wants excel file to be downloaded to desktop. If I put that setting in destination of webreport, excel file is getting downloaded and it shows the field is hyperlinked. But when I click it, it says "Cannont ope file"..?!! but the same works in html. this is the line I use in web report body to make it hyperlink.

<TD><A HREF="[LL_REPTAG=DATAID LLURLEFAULTLINK /]">[LL_REPTAG=DATAID NODEINFOATH /]</A></TD>

Please let me know if any change is needed.

Thanks a lot..

 

[visopenlive]

When I search on the forums,I see there is a limit on length of URL when passes from wen report into Excel..?!! not sure if this is true..

 

[visopenlive]

Can someone please reply for this?

 

[ggriffit]

what is the hyperlink that appears in the Excel ? is it a relative or an absolute one ?

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[visopenlive]

Hai

I just found the problem. The link that appears in excel is absolute one and that is causing the problem. Because when the file is downloaded to our desktop path changes and its linking desktop path to document's path on server and says file not found. How to overcome this issue?

thanks a lot for your reply

 

[visopenlive]

Hai Griffiths or any one,

Can you help me on this please?

Thanks

 

[ggriffit]

can you provide an example of the changes and what you are expecting ?

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[visopenlive]

Working link example:

opentxt.com/examples/reports/.........

Basically this is formed by using LL_PATH and this line of code in web report.

<A HREF="[LL_REPTAG=DATAID LLURLEFAULTLINK /]">[LL_REPTAG=DATAID NODEINFO:NAME /]</A>

When the web report having this line is ran, hyperlink shows up and document open when clicked. But when destination is changed to desktop or email, file comes up and saves on desktop or comes as attachment to e-mail with hyperlink in it.
But hyperlink refers to local user PC like

Cocuments and Settings/Desktop/Temporary/....

Hope this helps..thanks a lot..

 

[visopenlive]

Hai Grifftihs

Hyperlink works now. but on clicking the hyperlink it asks for login and then after login it displays the document that is hyperlinked. Even though user is login in one tab of the browser it still asks for login.. Is this any cookie issue?
Please help on this.

Thanks

 

[ggriffit]

depends on how you have authentication set up, I assume from your description that you are using Livelink rather than NTLM authentication, can you post the two URLs, one from the system and one from the Excel file, as some browsers/servers can be case sensitive.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[visopenlive]

Yes, we use Livelink but not NTLM authentication..

 

[ggriffit]

can you compare the two URLs and see if there are any differences e.g. case issues ?

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[visopenlive]

Sure..I will compare and will let you know..or I will psot two URLs here..thanks a lot for your help..