Hi guys, I created a report based on my database. Becuase the data in the database has some strange characters, such as "&", I wonder if there a way or expression to transform it when previewing the report. Like to add something on Fields expression, so once my report takes the data, the data could be encoded?
Thanks for the help!
OK, I found the answer.
The question is transform the escape characters suck as "&" to "&". So the actual question should be how to decode the URL escape characters.
The solution is to add a markup element on textField.
The detailed info could be found in there: http://jasperreports.sourceforge.net/sample.reference/markup/
JasperReports will just output what it's given. Do you want to unescape the text? Have you tried using "replace()" method available in the expression editor?
Thank you hozawa,
yes I want to unescape the text, I will try to use replace(), thanks