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

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?

September 6th, 2015 12:19pm

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.

Free Windows Admin Tool Kit Click here and download it now
September 6th, 2015 1:12pm

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

September 7th, 2015 3:16am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics