How To Remove Special Characters In rdlc report

Question

Hi All, Im building the rdlc report where i have special characters like ',`,®. how to allow these characters into a report or how to remove those characters and generate a report. Now when the special characters are in the data, when i am generating the report it shows a syntax error as "Missing operands 's " . Request you to help me out. Thank you in advance. Regards, Sai Shyam

Amit Gupta · Answer

If you are using single quote in code behind them use it two times ''(two single quotes)

sai shyam · Answer

In Sql im getting the data correctly but when i am running report it showing an error.

Amit Gupta · Answer

There might be any minor mistake in your expression. Can you recheck after removing the registered mark, the issue still persist? Kindly check your sql query.

Jignesh Kumar · Answer

Hi Sai, Do have any formula to calculation in report ? Please have a look at this link, https://stackoverflow.com/questions/41951974/crystal-reports-the-is-missing

sai shyam · Answer

Hi Amit, Please refer to the below screenshot where i am getting the data from SP as Sai's but when i open report it is showing the error as syntax error: missing operand after s operator.

Amit Gupta · Answer

Can you show screenshot or something to understand because I am already using the registered mark ® in rdlc just as usual without any issue

Jignesh Kumar · Answer

Hi shyam, Use this link, https://www.tek-tips.com/viewthread.cfm?qid=1651419 https://answers.sap.com/questions/9612367/limit-character-number-and-remove-special-characte.html