Hyperlink Issue

building reports webintelligence
1

Hello All,
I am experiencing an issue with Hyperlink.
Issue:
When trying to pass all the “Commodity Codes” (it is some id’s like ‘AKER’,’KLSW’ etc) or values using hyperlink from one report to other. It shows a grey window. In other words it doesn’t work. This issue is with two reports only.

The Environment:

  1. OS: Window2003
  2. Version: BOXIR3.1 SP5.
  3. Database: Oracle 10g.

Trouble Shooting Results:

  1. When select one or two comm. Code’s. The hyperlink works fine.
  2. So, issue is with the large number of codes that we are passing from one report to other.

Questions:

  1. Is there any limitation with passing values through Hyperlinks?
  2. Can you suggest for any other work around? if it is a limitation.

Thank You.

subratomall (BOB member since 2009-02-25)

2

You are probably running into an IE limitation in the length of URLs. See this thread for more info.

There are no easy options. However, you can use a POST call instead of the default GET. (I believe there was a discussion here on BOB about this, but I’m not able to find it.) What you need to do is embed some Javascript code in the calling report. The code will construct an HTML form, and make the call to openDocument using the POST method. Since POST parameters don’t have the same length limitation, they can be an indefinite length.

Joe

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

3

Hi Joe,
Thank you for your quick response.I have checked the link, you have mentioned.And I also checked the article mentioned in Microsoft support side(which is relevant to this post).
I think you are right, it is a browser limitation and we need to check with the POST call.
However, with my little research I am unable to find any link associated with the (Hyperlink+POST call).Can you please help me to get the sample code if possible, so, I can try at my end.Or from below code can you tell me where this POST call needs to update.I am mentioning the link I am using in the report:

="<a href="…/…/opendoc/openDocument.jsp?iDocID=AVC5aT.P.QxErm1TEK3Q9gc&sIDType=CUID&sType=wid&lsS1.Enter%20Current%20Period%3A="+URLEncode(""+[Current Period])+"&lsS2.Please%20Select%20Advance%20Report%3A="+URLEncode(""+[HardCoded_Value])+"&lsM5.Enter%20Commodity%20Code%3A="+URLEncode(""+[CommCode Report Filter])+"&lsM8.Enter%20Site%20Code%3A="+URLEncode(""+[Site Report Filter])+"&lsM11.Owner%3A="+URLEncode(""+[User Report Filter])+"&sWindow=Same" title="" target="_self" nav=“doc”>Click here"

Thank you.

subratomall (BOB member since 2009-02-25)

4

Unfortunately, it’s not a simple matter of a single hyperlink.

You need to create an empty cell in the report that will contain a Javascript function and the HTML form. The report cell (which currently has the openDocument call) will instead call the Javascript function, passing it the parameters that will be populated into the form, then passed to openDocument.

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

5

Thank you Joe.

I think I need to do some more R&D on this.

subratomall (BOB member since 2009-02-25)