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.