Weird scenario - I have a drop that has Client Names. But the Client Name could include a comma for example ABC Company, Inc
When this name with a comma is selected I get an error message saying ‘No Data to Fetch’.
Anyone experience this?
raiderfan (BOB member since 2005-09-02)
I had the same problem. I contacted BO support and they gave me the solution. I do not remember it though as it was over 6 months ago at a client.
contact BO support. they will give you the solution
jbenzakin 
(BOB member since 2007-10-12)
Hello shjaffer,
I have the same problem. Did you received a response from BO ?
thanks.
Beschmiel 
(BOB member since 2008-07-25)
Hi All,
Does any one has solution for this? I meant how to pass value with comma (example: Company Name= ABC, London) to open another Webi or SWF report? Currently If I clicked value ABC, London from graph, detail webi report is opening without any data. The reason is, it is passing only ABC value not whole value ABC, London. I am using Qaaws and OPENDOC to open the detail report.
Thanks in advance.
Philip (BOB member since 2006-03-02)
Would the URLEncode function be of any help, maybe?
Andreas 
(BOB member since 2002-06-20)
how can i use the URL Encode?
My problem is that my input for the prompt itself can have all kind of strange characters.
This is the code which is used when drilling down to webi report:
But now my report is using as Prompt “URLEncode(Wien OÖ)” instead of only “Wien OÖ”.
It looks like URLEncode is still not used?
The prompt value is depending on a selector outcome.
Here how i have built in in Xcelsius:
In cell A1 if have
“http://SERVER/OpenDocument/opendoc/openDocument.jsp?sType=wid&sRefresh=Y&iDocID=XXXXXXXXXXXXX&sIDType=CUID&A2”
in cell A2 if have formula: ="&lsS 4.Region=URLEncode("&A3&")"
in cell A3, this will be the destination cell for my selector.
In my example above this is Wien OÖ.
What am I doing wrong with the URLEncode??
Swimmer 
(BOB member since 2006-08-23)