Include Special Characters in a passing parameters in javascript in drill through report

Question

Hi,

I am passing a field value from main report to a parameter in a drill through sub report. But some field values contain 'special characters'. 

Those field values that contain special characters are not working for drill through. 

can you suggest javascript code to include special characters to pass to sub report parameter?

Answer 1

Hi Jd26,

Try the url encoding.Refer below links

http://www.javascripter.net/faq/escape.htm

http://www.permadi.com/tutorial/urlEncoding/

and check this too  please refer to the simlar thread, and then check if it works for you.

Is there an escape character in SSRS scripting: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/28a78133-fe70-4e7a-8a6c-c51f4112b42b/

If you have any question, please feel free to ask.

---

Please Dont forget to mark as answer and Helpful Post. It helps others to find relevant posts to the same question. Milan Das

Answer 2

Hi j.d.26,

In your scenario, you can also use the HttpUtility.URLEncode() function to handle the special characters. To use this function, we must add a reference to System.Web assembly, then call the function in the expression. For more information, please refer to this article: URL Encoding in Reporting Services.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

---

Qiuyun Yu
TechNet Community Support