BusinessObjects Board

OpenDocument multiple reports opened

sdk development
#1

Is it possible to open multiple reports using a single open document statement?

For example, we have a requirement to launch about 15 reports with a single parameter. As it turns out, due to some limitations in Webi, some will need to be Webi and the rest Crystal.

Pseudo Code:

="<a href=\"../../opendoc/openDocument.jsp?sDocName=Report1&amp;sType=wid&amp;lsSParam1+[Param1]&amp;sDocName=Report2&amp;sType=wid&amp;lsSParam1+[Param1]&amp;sDocName=Report3&amp;sType=rpt&amp;lsSParam1+[Param1], etc

tkdrocks :us: (BOB member since 2003-06-10)

opening multiple documents
Open documet for two detail report at the same time
Hyperlink to 2 or more documents?
Hyperlink to external documents from a singe webi document.
#2

Do you mean you want all reports to launch with a single click, or you’ll have a bunch of different links in the parent report that each call a different child?

joepeters :us: (BOB member since 2002-08-29)

#3

The need is for a single link (click) to pass the parameter to multiple reports.

tkdrocks :us: (BOB member since 2003-06-10)

#4

Only way I could of doing that would be with an embedded Javascript script that launches each report in succession, each in its own window.

<a href='#' onclick="javascript:window.open('http:/<opendoc1>');window.open('http:/<opendoc2>')">Click here</a>

Joe

joepeters :us: (BOB member since 2002-08-29)

#5

Thanks Joe,

I will talk to one of our Java developers and see if it is feasible. I am surprised that this has not been brought up before.

tkdrocks :us: (BOB member since 2003-06-10)

#6

Each report is going to use server resources, you realize this, yes? We experimented with having OpenDocument open new windows and discovered that our Webi server resources were being consumed at a dramatic rate. Not good. :slight_smile: As a result we standardized on opening a new document using the existing window.

In that scenario you would not be able to open multiple reports at once since there is only one target window.

Dave Rathbun :us: (BOB member since 2002-06-06)

#7

Great feedback as usual Dave. We have been asked to replace the functionality of, what was formerly, a client application that programatically batched reports and printed them in specific orders. The deeper I get into this, the more I am realizing that this functionality can only be performed by a client type application rather than server based.

However, I do want to provide the customer the reasons for my suggestions to justify the added development costs.

tkdrocks :us: (BOB member since 2003-06-10)

#8

I have a requirement for variation of this. We need an open doc wrapper that allows allows a dropdown/tooltip/control to let the user SELECT which report (of several pre-defined) to send the selected parameter to. I’ve played around with the overlib.js but not getting anywhere. Any help would be appreciated.

angelsd1 :us: (BOB member since 2005-10-21)

#9

Hi Angel,

This isn’t a complete solution, but it should be enough to get you started.

In an otherwise empty cell in your report, add the following code. I’d make it white-on-white to be invisible to viewers:

<script>
	function goGetEm(inParams)
	{
		var repname=document.getElementById("reportselect").value
		window.location="../../opendoc/openDocument.jsp?sDocName=" + repname + "?" + inParams;
	}
</script>

Then, in another cell to contain the drop-down box:


<select id=reportselect>
  <option value="rep1">Report 1</option>
  <option value="rep2">Report 2</option>
  <option value="rep3">Report 3</option>
  <option value="rep4">Report 4</option>
</select>

Then in the report body:

<a href="javascript:goGetEm('lsSparam=value&amp;lsSparam2=value2');">Click here!<a>

You’d replace the “lsSparam=…” with the openDocument parameters appropriate to the values you want to pass.

I just mocked this up, so I can’t guarantee that it’ll work as you intend. I have used the “white-on-white” Javascript hack successfully, however.

Joe

joepeters :us: (BOB member since 2002-08-29)

Webi 4.2 - Controlling Elements With Drop Down
One hyperlink, but with multiple entries / multiple targets
#10

Well; I’ll be darn. It worked. Now; this is the reason I used to beat up on geeks! (Just kidding). Thanks friend!

Ang. :lol:

angelsd1 :us: (BOB member since 2005-10-21)

#11

Oh, so that was you!!!

:stuck_out_tongue: Glad it worked…

Joe

joepeters :us: (BOB member since 2002-08-29)

#12

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]
we.JPG

akshara20 (BOB member since 2010-12-03)