Hyperlink to report in Jasperserver - Problem before login

0

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!!

 

camilo.rodriguez17's picture
Joined: Jan 27 2014 - 10:36am
Last seen: 5 years 1 month ago

4 Answers:

0
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/hyperl...
sjoerd.jump's picture
Joined: Oct 29 2012 - 2:39pm
Last seen: 4 years 6 months ago

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!

camilo.rodriguez17 - 5 years 5 months ago

Thanks! I'd be happy to hear :)

sjoerd.jump - 5 years 5 months ago
1

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!

sjoerd.jump's picture
Joined: Oct 29 2012 - 2:39pm
Last seen: 4 years 6 months ago

Please, do you see my reply post, thanks!!

camilo.rodriguez17 - 5 years 5 months ago
0

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

camilo.rodriguez17's picture
Joined: Jan 27 2014 - 10:36am
Last seen: 5 years 1 month ago
0
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=');
$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";
sjoerd.jump's picture
Joined: Oct 29 2012 - 2:39pm
Last seen: 4 years 6 months ago

Thanks sjoerd! I also do this on my system implementation!! :D (sorry for my bad english)

camilo.rodriguez17 - 5 years 5 months ago
Feedback
randomness