Hi,
I use stored procedures and sql queries to get data for my report parameters and the report data. The idea is to let user select from dropdown values and filter the required data. In one of the html styled text box, I need to present the user selected multi-values of a dropdown...
I used this..
Schools: {Join('; ', Parameters.SchoolNames.Value)}
that just works fine....
But the problem is the parameter values some times may contain '&'.. Thats throwing me an error.. Then I realised that I have to escape it for HTML Text box....
How can I do this in my scenario.. I have tried, the following with no luck..
Schools: {Join('; ',Replace(Parameters.SchoolNames.Value,'&','&'))}
I use stored procedures and sql queries to get data for my report parameters and the report data. The idea is to let user select from dropdown values and filter the required data. In one of the html styled text box, I need to present the user selected multi-values of a dropdown...
I used this..
Schools: {Join('; ', Parameters.SchoolNames.Value)}
that just works fine....
But the problem is the parameter values some times may contain '&'.. Thats throwing me an error.. Then I realised that I have to escape it for HTML Text box....
How can I do this in my scenario.. I have tried, the following with no luck..
Schools: {Join('; ',Replace(Parameters.SchoolNames.Value,'&','&'))}