Creating hyperlink on a field, it is possible to jump to another report using openDocument function.
I created a hyperlink on an object and when the object is clicked, another reports opens in new window.
Is it possible to jump to more than one report using hyperlink.
By clicking the object i want to open 2 reports in 2 new windows.
How can this functionality be achieved?
akshara20 (BOB member since 2010-12-03)
Ex;
MWR is main report and contains summary level data of sales document.
WR1 and WR2 are two detailed level reports.
WR1 contains details of sales documents and sales orders.
WR2 contains details of sales documents and sales revenue.
I have to create a hyperlink so that when i click Sales document number in both windows with WR1 and WR2 reports should open.
By using hyperlink i am able to jump to only report.
I want to jump 2 reports on a single click.
How can this be achieved?
akshara20 (BOB member since 2010-12-03)
I am using BOXI 3.0 version.
for jumping to one link, this one is working
="<a href=\"http://google.com\" title=\"\" target=\"_blank\" nav=\"web\">"+[L01 Business Area]+"</a>"for testing the hypelink to jump to two windows, I used the following code in hyperlink ( and as well as tried out in formula toolbar).
=<a href='#' onclick="javascript:window.open('http://google.com');window.open('http://yahoo.com')">[L01 Business Area]</a>when i try to parse, i get an error like invalid identifier.
what is correct format of the code, which i can use as a hyperlink?[/code]
akshara20 (BOB member since 2010-12-03)
You need to put the formula expression within double quotes.
joepeters 
(BOB member since 2002-08-29)
="<a href='#' onclick=\"javascript:window.open('http://google.com');window.open('http://yahoo.com')\">"+"Your Object or text here"+"</a>"Shobhit_Acharya (BOB member since 2005-08-11)
="<a href='#' onclick=\"javascript:window.open('http://bodev:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=ABddrzLNqVZGgFkyM_XjqiQ&sIDType=CUID&sType=wid&sRefresh=Y&lsMEnter%20value(s)%20for%20L01%20Business%20Area%3A=');window.open('http://bodev:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=AORIJf_oltBDi5LCbV41zSA&sIDType=CUID&sType=wid&sRefresh=Y&lsMEnter%20value(s)%20for%20L01%20Business%20Area%3A=')\">"+[L01 Business Area]+"</a>" how far is this code right with OpenDocument?
when I click the hyperlink, I am getting error - Cannot open hyperlink (WIO 00002)
These are the codes to which can be executed individually using hyperlink
"<a href=\"http://bodev:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=ABddrzLNqVZGgFkyM_XjqiQ&sIDType=CUID&sType=wid&sRefresh=Y&lsMEnter%20value(s)%20for%20L01%20Business%20Area%3A="+URLEncode(""+[L01 Business Area])+"&sWindow=New\" title=\"\" target=\"_self\" nav=\"doc\">"+"Bookings"+"</a>"and
="<a href=\"http://chiller:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=AORIJf_oltBDi5LCbV41zSA&sIDType=CUID&sType=wid&sRefresh=Y&lsMEnter%20value(s)%20for%20L01%20Business%20Area%3A="+URLEncode(""+[L01 Business Area])+"&sWindow=New\" title=\"\" target=\"_self\" nav=\"doc\">"+"Revenue"+"</a>"The hyperlinked reports have prompts defined. so when i click the link object in main report, the concerned object is filled automatically into prompt of relevant report and automatically executed.
these are working fine individually , but how do i combine them into single link.
akshara20 (BOB member since 2010-12-03)
The first link in your window.open call doesn’t have the prompt value, but I don’t think that’s causing your error (it would just prompt you for the value).
Is the formatted as “HTML”? If it’s “Hyperlink”, it probably won’t work with the javascript code.
Joe
joepeters (BOB member since 2002-08-29)
I am using the javascript in hyperlink to open 2 windows.
I tried it within formula also.
Doesn’t hyperlink support javascript.
How would i open 2 links at a time using hyperlink method?
akshara20 (BOB member since 2010-12-03)
Try it as HTML.
joepeters (BOB member since 2002-08-29)
Can HTML be used to jump to 2 queries at a time?
If yes? how?
I need to execute code with the given reports addresses.
The individual hyperlinks are
="<a href=\"http://bodev:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=AEddrzRNqVZGgFkyM_XjqiQ&sIDType=CUID&sType=wid&sRefresh=Y&lsMEnter%20value(s)%20for%20L01%20Business%20Area%3A="+URLEncode(""+[L01 Business Area])+"&sWindow=New\">"+[L01 Business Area]+"</a>"and
="<a href=\"http://bodev:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=ALPIJf_oltBDi5LCbV51zSA&sIDType=CUID&sType=wid&sRefresh=Y&lsMEnter%20value(s)%20for%20L01%20Business%20Area%3A="+URLEncode(""+[L01 Business Area])+"&sWindow=New\">"+[L01 Business Area]+"</a>"I need to combine these both into single hyperlink, which on clicking opens 2 windows
akshara20 (BOB member since 2010-12-03)
Yes, that’s how I did it in the post I linked to above.
Joe
joepeters (BOB member since 2002-08-29)
I tried it, but links are not opening
akshara20 (BOB member since 2010-12-03)
Does anything happen? Does it appear as a valid link in the report?
joepeters (BOB member since 2002-08-29)