Passing Ampersand as one of the parameters through the url

building reports crystal reports
1

Hi,

I’m trying to pass ampersand(&) as one of the parameter through URL to Crystal.

For example - AT&T. When it sends the url to crystal to get the report the ‘&’ is considered the end of the parameter and returns results only for ‘AT’ and not ‘AT&T’.

I tried escaping the ‘&’ with ‘&’ but it gives an error saying Incorrect syntax near the parameter. Also tried replacing ‘&’ with ‘%26’ the encoded value but this errors out too.

Since this is a special character can I pass search strings with ‘&’ as a parameter?

If so could somebody please help me with this?

Thank you[/url]

madhura (BOB member since 2009-05-12)

2

I found this article via google as we have the same problem, but for us “%26” did work(BOE XI R2, opendocument.aspx). Thanks!

sbroam (BOB member since 2006-08-24)