Hi there!
I include one report in Jasperserver, and I need access to that report from Excel (using an hyperlink). The URL is this:
"http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&_flo..."
Effectly the browser is launched when I click in the Hyperlink, but the problem occur because I make login in JasperServer and before the report doesn't appear!!! And the most strange in if I open a Browser and paste that URL, effectly I can make the login and before the report appear!! I don't understand that.
On the other hand if I include to the URL: &j_username=jasperadmin&j_password=jasperadmin it works! but I need that the users make the login.
UPDATE: When I export the file to PDF it works! but in Excel(xls) not working .. I don't understand this!!!
Thanks for advance!!
4 Answers:
Hi Camilio
I use the following link to my reports:
http://traject-pc:8080/jasperserver/flow.html?_flowId=viewReportFlow&standAlone=true&_flowId=viewReportFlow&ParentFolderUri=%2Freports&reportUnit=%2Freports%2Fmy_report
The bold text is different from your URL.
Hope this helps!
Sjoder.jump thanks for your answer, I make a basic test:
1. New file in Excel
2. Write a text in a cell and create an hyperlink for this cell. This is the URL (based on your answer):
3. I cliked in hyperlink and the browser was launched (Previously I have the browser closed):
4. I make the login but instead show me the report that I request, it show me the following window:
I don't understand why happens this!!! but if I close session and close browser and reopen and paste the URL directly that works! Why? :S
define('URL_BASE', 'http://traject-pc:8080/jasperserver/flow.html?_flowId=viewReportFlow&standAlone=true&_flowId=viewReportFlow&ParentFolderUri=%2Freports&reportUnit=');
$final_url = URL_BASE . $link;
$link = $line['link'];$name = $line['naam'];$click = LINK_ONCLICK;$final_url = URL_BASE . $link;{echo "\t\t<td>$name</td><td><a target=\"report\"href=\"$final_url\"$click\">$name</a></td>\n";
Thank you very much! The problem apparently is for Microsoft products(based on your answer link), I'm searching for solutions but the scene is not clear. If I found something useful I'll tell you. Thanks again!
Thanks! I'd be happy to hear :)