hyperlinking prompt issue

building reports webintelligence
1

Hi,

I am facing a bit strange issue, i am using the opendoc code with a prompt to access other report, everything is working fine with my code except the issue is it is taking prompt value correctly if there is no space in the object eg: if i am cliking on telco it is working fine. if i click on other object where it says telco group it is not working.

basically when ever there is a space in word it is not accepting that and it is only reading the prompt upto the space in above example it is reading upto telco and not reading group.

this is the code i am using

="<a href= http://server/businessobjects/enterprise115/Infoview/Scripts/openDocument.aspx?&sType=wid&Swindow=Same&sDocName=kal+2&sRefresh=Y&lsSEnter:="+[object]+">"+[object]+""

Any help is much appreciated.

Thanks
Prashant

prashant79 (BOB member since 2006-12-07)

2

Try this:

="<a href= http://server/businessobjects/enterprise115/Infoview/Scripts/openDocument.aspx?&sType=wid&Swindow=Same&sDocName=kal+2&sRefresh=Y&lsSEnter:="+Replace([object];"";"%20")+">"+[object]+""

Hope it works for you

MBTDC :us: (BOB member since 2007-12-28)

3

Hi,

Thanks for your reply, it is working great, only thing is it is not working if there is a & sign, i think i can manage.

Thanks again for your help.

thanks
Prashant

prashant79 (BOB member since 2006-12-07)

4

%20 is the hex code for “space” ( ). %26 is the hex code for ampersand (&).

jsanzone :us: (BOB member since 2006-09-12)