Home > Business objects Web Intelligence > Hyperlink to open mulitple Web Intelligence documents by Open document functionality

Hyperlink to open mulitple Web Intelligence documents by Open document functionality


Open document syntax to open multiple reports in single hyperlink

we can link two or more reports in a single hyperlink, this can be achieved by injecting an javascript inside the open document URL.

let me first tell some basics of Open document functionality which is as follows,

The syntax for an OpenDocument URL is as follows:

http://<servername&gt;:<port>/OpenDocument/opendoc/<platform
Specific>?<parameter1>&<parameter2>&…&<parameterN>

The exact syntax of the <platformSpecific> parameter depends on your
SAP BusinessObjects Enterprise deployment:

• For Java deployments, use openDocument.jsp in place of the <platformSpecific> parameter.
• For .NET deployments , use opendocument.aspx in place of the <platformSpecific> parameter.

<parameter1><parameter2> can be the values that you are going to pass the next report.

we can briefly get a  knowledge on open document from the following link.

http://help.sap.com/businessobject/product_guides/boexir31SP3/en/xi31_sp3_opendocument_en.pdf

When we create an hyperlink from infoview by options, we will get a  “<a href >/…/…/ </a>” link , and its slightly different from this procedure of creating a hyperlink. Here we replace the auto generated link script by the open document syntax with the javascript.

Normal link to open a SINGLE document:

=<a href=’http://<servername&gt;:<port>/OpenDocument/opendoc/<platform
Specific>?<parameter1>&<parameter2>&…&<parameterN’>“+”Your Object or text here”+”</a>”

The javascript to open two documents,

=”<a href=’#’ onclick=\”javascript:window.open(‘Open document for Report 1’);window.open(‘Open document for Report 2’)\”>”+”Your Object or text here”+”</a>”

For example, i have implemented this using sample universe called Efashion, where i created three report, the first one is the main Report in which hyperlink is created and second, third reports are the connected reports,

the opendocument syntax for connecting two reports is shown below, we can also pass different set of parameters to different reports using this link.

=”<a href=’#’ onclick=\”javascript:window.open(‘http://<server name>:<port>/OpenDocument/opendoc/openDocument.jsp?iDocID=Afkjn4VJ.fqpsHqcigddiP5iOlwE&sIDType=CUID&sType=wid&sRefresh=N&lsSEnterYear%3A=”+[Year]+”‘);window.open(‘http://<server name>:<port>/OpenDocument/opendoc/openDocument.jsp?iDocID=AsdLLgIffJn7fXJCv85q2wssVZlOo&sIDType=CUID&lsSEnterYear%3A=”+[Year]+”&lsSEnterQuarter%3A=”+[Quarter]+”‘)\”>”+[Year]+”</a>”

Another Best Practice about creating prompts, especially while creating hyperlinks is,

when we create hyperlink sometimes there will be a need to pass parameters as a prompt to the next report, its better to create the prompt name without any spaces as like in above link (EnterYear and EnterQuarter)

you can see there are no spaces between ‘Enter’ and ‘Year’, this will reduce the risk on %20 and some notations for spaces on link because we are manually writing the open document syntax, so it will become more tedious when we try to add %3A’s and %20’s for spaces. so its better to avoid spaces in prompt names.

Now if we click on the object, it will open two Reports at a time with different or same parameters passed.

we can directly enter the open document syntax in the formula bar as shown in above screen shot.

Using this javascript, we can also add other mouse events like onclick(),ondblclick(),onmouseover() and functions like prompt(),alert() etc

 

Regards

Dineshkumar

Advertisements
  1. Ashish
    December 8, 2011 at 5:17 pm

    Hi can we have an option to choose which one to open depending on what parameters we pass?

    Like

    • December 21, 2011 at 11:35 pm

      I am very sure, it may be possible with suitable java scripts. So you check with the script and try to pass it in the Open document syntax

      Like

  2. renuka
    August 23, 2012 at 9:51 am

    Hi,
    I am searching for how to use the Hyperlinks in the Crystal Reports using java web Application.could anyone help for it.

    Thank you,

    Like

  3. Alfonzo
    May 11, 2014 at 7:47 am

    In fact no matter if someone doesn’t understand after that its up to other viewers that they will help, so
    here it occurs.

    Like

  4. mahendra
    June 4, 2014 at 6:30 pm

    Hello Dinesh,

    Thanks for the wonderful documentation..

    In my requirement I would like to navigate from 1 crosstab report to 8 detailed reports . My crosstab rep is having 8 records and if i click on 1st record/row it should navigate to 1st detailed rep and if i click on 2nd record/row it should navigate to 2nd detailed rep ………. same thing should happen for remaining reports also….

    Please let me know whether this is possible or not , and please provide me your suggestions.

    thanks
    mahi

    Like

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: