Skip to Content

problem with opendoc url.

hi experts,

i am having a problem with opendoc url in 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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2011 at 05:36 AM

    Hi Ravi,

    In Excel , & considers as "Concatenation. So it will not work properly. To make this work, use Dealer Number instead of Dealer name in ur example.


    Dealer Name Dealer Number

    ravi & ravi distributors D10001

    krishna distributors D10002

    If you use Dealer Number "D10001" you can get "ravi & ravi distributors " Information. In ur Dashboard Design, if the user clicks "ravi & ravi distributors" then pass "D10001" to the Opendoc and generate the report.

    Try to not use which has special characters as the prompt in Xcelsius.


    Muthukumar A.S.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 12, 2011 at 06:32 AM

    did you try using "ravi%26ravi+distributor" instead of "ravi & ravi distributors" ?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.