Monday, February 13, 2012

& in report parameter

Hi,
Using URL parameters, I pass in the following department parameter "Sales & Marketing". The problem is the "&", this causing reporting services to display an error. I assume reporting services thinks it the parameter delimiter.
I have tried URL encloding the string before I pass it in but I still get an error.
Any ideas?
ThanksWhat is the error. Passing an & is fine, and yes it must be encoded on the
URL.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"MikeMcD" <MikeMcD@.discussions.microsoft.com> wrote in message
news:B84B6DAA-93FA-44CF-9CEC-C062E1DED325@.microsoft.com...
> Hi,
> Using URL parameters, I pass in the following department parameter "Sales
& Marketing". The problem is the "&", this causing reporting services to
display an error. I assume reporting services thinks it the parameter
delimiter.
> I have tried URL encloding the string before I pass it in but I still get
an error.
> Any ideas?
> Thanks|||Yes, we need to encode the & when we pass it in the URL.
just search ur string for an & and replace it with %26.
This should work fine.
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

No comments:

Post a Comment