Hyperlink in Excel Report
Hi,
I have an Insight report which contains a link into RQM to display an attachment. URL is in the following format:
https://<hostname>:<port>/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<Project>/attachment/urn:com.ibm.rqm:attachment:43798
I have implemented this link as a hyperlink and when I display the report in HTML or PDF format, it works perfectly. However, when I display the report in Excel (2002) format and click on the link, it forces me to log in again. I do so and get an "Invalid path to authentication servlet.: /" error - presumably because I am already logged in?
I can't understand why the same hyperlink object would behave differently when executed from a browser / PDF and from Excel. If I cut and paste the URL directly into the browser that also works - it's just when Excel tries to launch it.
Any ideas gratefully received,
Jill
I have an Insight report which contains a link into RQM to display an attachment. URL is in the following format:
https://<hostname>:<port>/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<Project>/attachment/urn:com.ibm.rqm:attachment:43798
I have implemented this link as a hyperlink and when I display the report in HTML or PDF format, it works perfectly. However, when I display the report in Excel (2002) format and click on the link, it forces me to log in again. I do so and get an "Invalid path to authentication servlet.: /" error - presumably because I am already logged in?
I can't understand why the same hyperlink object would behave differently when executed from a browser / PDF and from Excel. If I cut and paste the URL directly into the browser that also works - it's just when Excel tries to launch it.
Any ideas gratefully received,
Jill
4 answers
It sounds like Excel is tacking something on to the end of the URL (perhaps another /). You may want to use FireBug to capture the request that is made to the server versus the request made when you enter the URL manually, or maybe just looking at the URL that appears in the address bar after clicking the link from Excel will reveal the problem?
Hi, Thanks for the quick response!
The only URL that I get to see is https://<hostname>:<port>/jazz/auth/authrequired This seems to be the case whether I click the link in the PDF report or in the Excel report - i.e. both seem to be doing the same thing
I'm not an expert in Firebug though
The only URL that I get to see is https://<hostname>:<port>/jazz/auth/authrequired This seems to be the case whether I click the link in the PDF report or in the Excel report - i.e. both seem to be doing the same thing
I'm not an expert in Firebug though
Yes, the JTS server catches the request first and presents an authentication dialog before re-directing you to the requested page. If you want to email me a sample html and Excel file I can have a look.
