Skip to Content
avatar image
Former Member

Design Studio passing prompts with # value and special character to Child WebI report

Hello Design Studio Gurus ,

We have 3 mandatory prompts that need to be passed to child reports to make them run .

Prompt 1 - everything fine

Prompt 2 - # value included

Prompt 3 - # value and special character .

While Prompt 1 & 2 are working fine , Prompt 3 is giving us nightmares . If # is selected then it's unable pass any value to the child report for that prompt

[screenshot of child report . child report fails to execute and gets stopped here ]

If We deselect # value and select rest of the values manually it stops the moment it encounters special character

Can this be handled using OpenDocument syntax where the LOV has special characters ?

I can see if the report name have a special character you can specifically mention how to interprete it . We can also handle leading and trailing spaces .

But dont think we can handle special characters in LOV in between .

Please help me out what should be the best approach here .

This is how we have defined the Open Document behaviour in the text fields OnClick behaviour -

var Sales_Org = TREND_ANALYSIS.getVariableValueExt("CICFCCSOAUTH");
var Div = TREND_ANALYSIS.getVariableValueExt("OCSDCMDIVI");
var Distr_channel=TREND_ANALYSIS.getVariableValueExt("OCSDCMDISCHA");


APPLICATION.openNewWindow("http://<BOSERVER>:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AWspn6A1SjtNnY5WseCAzK8&sType=wid&sRefresh=N"+"&lsMOCCFCMSOORG=" + Sales_Org +"&lsMOCSDCMDISCHA=" +Distr_channel +"&lsMOCSDCMDIVI=" +Div);

5opy0.png (69.6 kB)
ugf6g.png (107.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 23, 2016 at 04:54 AM

    # is a special character in URL syntax so you have to convert it to %23 using Convert.urlEncode method

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 22, 2016 at 05:28 PM

    Hi - your screen shots do not look like Design Studio; they look like Web Intelligence. Did you select the right tag?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 22, 2016 at 07:21 PM

    Yes Tammy . The tag is correct . I have shown here how the prompts are eventually passing down to WebIntelligence from Design Studio . If you notice I have mentioned the prompt formula I have used in Design Studio as well .

    Add comment
    10|10000 characters needed characters exceeded