camilo.rodriguez17 Posted January 29, 2014 Posted January 29, 2014 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&_flowId=viewReportFlow&ParentFolderUri=%2Freports%2FMyReports&reportUnit=%2Freports%2FMyReports%2FReportOne"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!!
sjoerd.jump Posted January 30, 2014 Posted January 30, 2014 Hi CamilioI 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_reportThe bold text is different from your URL.Hope this helps!
camilo.rodriguez17 Posted January 30, 2014 Author Posted January 30, 2014 Sjoder.jump thanks for your answer, I make a basic test:1. New file in Excel2. 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
camilo.rodriguez17 Posted January 30, 2014 Author Posted January 30, 2014 Please, do you see my reply post, thanks!!
Solution sjoerd.jump Posted January 30, 2014 Solution Posted January 30, 2014 It seems that Excel is destroying your link, according to a Windows forumpost. I would try to backtrack the error using jasperserver debug, although i'm not sure if the log shows what URL is being send to the server. http://answers.microsoft.com/en-us/office/forum/office_2003-excel/hyperlink-does-not-resolve-correctly/188c9cb0-bf88-4495-ae27-6d18b3df11e8
camilo.rodriguez17 Posted January 30, 2014 Author Posted January 30, 2014 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!
sjoerd.jump Posted January 30, 2014 Posted January 30, 2014 BTW, i use PHP to generate my report-links. I store the last bit in a database and generate them using the following code: define('URL_BASE', 'http://traject-pc:8080/jasperserver/flow.html?_flowId=viewReportFlow&standAlone=true&_flowId=viewReportFlow&ParentFolderUri=%2Freports&reportUnit=');[/code] $final_url = URL_BASE . $link;[/code] $link = $line['link'];$name = $line['naam'];$click = LINK_ONCLICK;$final_url = URL_BASE . $link;{echo "tt<td>$name</td><td><a target="report"href="$final_url"$click">$name</a></td>n";[/code]
camilo.rodriguez17 Posted January 30, 2014 Author Posted January 30, 2014 Thanks sjoerd! I also do this on my system implementation!! :D (sorry for my bad english)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now