asked on

I tried with URLEncode and URLPathEncode but not working for "Åland Islands"

I have SSRS report and calling child report using URL option. I tried with URLEncode and URLPathEncode but not working for country name = "Åland Islands" in Internet Explorer browser.
even after using the script as you mentioned URL converts that Country name to "%u00c3%u0083%u00c2%u0085land+Islands" .

below is the link i am passing to call report :

="javascript:void(window.open('http://azwindsqd02/ReportServer/Pages/ReportViewer.aspx?%2fDEMO%2fOEM+Models_V2&rs:Command=Render&Area="& Parameters!Area.Value&
"&Country="&Code.URLEncode(JOIN(Parameters!Country.Value,"&Country="))&
"&FormFactor="&JOIN(Parameters!FormFactor.Value,"&FormFactor=")&
"&PremiumFlag="&JOIN(Parameters!PremiumFlag.Value,"&PremiumFlag=")&"&SKUGroup="&JOIN(Parameters!SKUGroup.Value,"&SKUGroup=")&"&FiscalYearMonth="&JOIN(Parameters!FiscalYearMonth.Value,"&FiscalYearMonth=")&"&OEMType="&JOIN(Parameters!OEMType.Value,"&OEMType=")&"&TileFlag="& Fields!TileFlag.Value &"','_blank','directories=0,titlebar=0,toolbar=0,location=0,status=0,menubar=0,scrollbars=no,resizable=no,width=850,height=520'))"

can you please provide solution to me how to handle this kind of random special characters in country names like Curaçao, Saint Barthélemy etc.

ASKER CERTIFIED SOLUTION

Jim Horn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Shital

ASKER

Thank you for the reply Jim.

Yes..Those are the Latin language characters and I believe IE browser is converting those UTF -8 characters into the some code. seems its browser issue.

I will try with the approach you have suggested to look up country using key column instead of search.

Jim Horn

Absent any further comments...

I tried with URLEncode and URLPathEncode but not working for &quot;Åland Islands&quot;

I tried with URLEncode and URLPathEncode but not working for "Åland Islands"