cancel
Showing results for 
Search instead for 
Did you mean: 

In Open Document URL, parameters containing “&” is not getting passed.

Former Member
0 Kudos
87

Hi,

In a Web I report, BO 4.1 SP3, we have a Dimension which has values containing
“&”. For E.g. “A & T”. On this dimension we have a Hyperlink and is configured to open in Current Window. The parameter passed is URL Encoded.

On clicking on “A & T”, parameter getting passed in “A” resulting in no data.

When Hyperlink is configured to open in New Window, there is no issue. “A & T” gets passed giving correct data.

Please let me know if you have faced similar issue and what is the resolution to open the report in Current Window.

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

saurabh_sonawane
Active Contributor
0 Kudos

Hi

& is used as  a syntax in url

to pass in as a output we have to change the & to %26

for eg

A%26T

saurabh_sonawane
Active Contributor
0 Kudos

instead of passing the dimension text pass the

dimension-key which will not contain any "&"

Former Member
0 Kudos

Thanks Saurabh,

The function URLEncode() will convert & to %26. It is working fine when I open in New Window but not in Current Window.

As for passing Dimension Key, in the report, Prompt should be created on Key. Currently the dimension does not Key and Value pair.


saurabh_sonawane
Active Contributor
0 Kudos

As for passing Dimension Key, in the report, Prompt should be created on Key.

No

we dont have to create a prompt with key

we can pass the key to the dimension-text it takes it and give the output

can you past the hyperlink

Former Member
0 Kudos


Hyperlink:

="<a href=\"../../opendoc/openDocument.jsp?iDocID=Ab0TXUFlmNtDqBgGia8zFR0&sIDType=CUID&sType=wid&sReportName=REFERRAL USER - DETAIL&sRefresh=N&lsSEnter%20Start%20Date%3A="+URLEncode(UserResponse("Enter Start Date:"))+"&lsSEnter%20End%20Date%3A="+URLEncode(UserResponse("Enter End Date:"))+"&lsMEnter%20value(s)%20for%20Type="+URLEncode(""+Upper([Type]))+"&sWindow=Same\" title=\"\" target=\"_self\" nav=\"doc\">"+Upper([Type])+"</a>"

saurabh_sonawane
Active Contributor
0 Kudos

"<a href=\"../../opendoc/openDocument.jsp?iDocID=Ab0TXUFlmNtDqBgGia8zFR0&sIDType=CUID&sType=wid&sReportName=REFERRAL USER - DETAIL&sRefresh=N&lsSEnter%20Start%20Date%3A="+URLEncode(UserResponse("Enter Start Date:"))+"&lsSEnter%20End%20Date%3A="+URLEncode(UserResponse("Enter End Date:"))+"&lsMEnter%20value(s)%20for%20Type="+URLEncode(""+Upper([Type]))+ title=\"\" target=\"_parent\" nav=\"doc\">"+Upper([Type])+"</a>"

Former Member
0 Kudos


Target = _parent will open in same tab

saurabh_sonawane
Active Contributor
0 Kudos

ya

saurabh_sonawane
Active Contributor
0 Kudos

had u solve your problem

Former Member
0 Kudos

No. Unable to open in Current Tab.

With Target as _parent/_blank it works fine but not with _self.

saurabh_sonawane
Active Contributor
0 Kudos

OK great

then Please close this thread

Thanks and Regards

saurabh