Skip to Content
0
Dec 10, 2011 at 05:58 AM

problem with opendoc url.

46 Views

hi experts,

i am having a problem with opendoc url in my dashboard.my url is to open a webi report depends on two prompts given by the user.

i am using the following url and it is working fine.

http://sysname:port/OpenDocument/opendoc/openDocument.jsp?sType=wid&sRefresh=Y&iDocID=123456&mode=full&nbPrompts=2&lsSEnter Year=Prompt1&lsSEnter Dealer=prompt2.

when i am entering a value for prompt2 like "krishna distributors" its working fine.but the problem here is whenever i am entering a value for the second prompt with a value like (ex:) "ravi & ravi distributors" its giving an message "NO DATA TO RETRIEVE" because it is considering the & symbol in my prompt2 as another parameter as shown below.

http://sysname:port/OpenDocument/opendoc/openDocument.jsp?sType=wid&sRefresh=Y&iDocID=123456&mode=full&nbPrompts=2&lsSEnter Year=Prompt1&lsSEnter Dealer=ravi & ravi distributor

can anyone help me on this.

thanks in advance,

ravi kishore yarramsetti.