There may be certain scenarios where you will be using dynamic
filters / drill down reports where the filter value has to be passed
via url. Now if the data contains special character, it might create
some problems. (especially the character "&"). To solve this problem,
we will have to encode the special character in the data, before
passing them via url.
This problem can be easily solved using javascript support in reports.
For example, if you have value in column a as 'sample & value' then in
another data column write a expression like
a.replace('&','%26') which will replace & with encoded value %26.
likewise you can write more expression to replace all the special
characters with encoded values. After encoding the values send the
encoded value in the URL and it should work.
If using model fields as passing parameters, you can use the
substitute function to achieve the same result.
For a list of encoded values please refer to
http://www.w3schools.com/TAGS/ref_urlencode.asp.
I have uploaded a sample report (urlencode.rptdesign) for reference.
Thanks to Dinesh for the info