Does anyone know how to override special characters such as “&” and “/” in an OpenDoc statement? My report names and prompted values sometimes contain these characters (eg, “Mom & Pop’s Financial Report”, “New/Used Vehicles”).
Any help is greatly appreciated!
bhorizon (BOB member since 2007-05-15)
There is no way to do it automatically other than using a replace formula for your characters. I use this table for the HTML conversions.
rgoodman 
(BOB member since 2007-02-06)
Use the below formula to override the special char before generate the URL
IF(ISERROR(FIND("&",$C$1,1))=TRUE,$C$1,REPLACE($C$1,FIND("&",$C$1,1),1,"%26"))
It works for me. Hope this is helpful.
asokkm (BOB member since 2005-07-26)