victorlizonglin Posted June 7, 2018 Share Posted June 7, 2018 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! Link to comment Share on other sites More sharing options...
hozawa Posted June 8, 2018 Share Posted June 8, 2018 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? Link to comment Share on other sites More sharing options...
victorlizonglin Posted June 8, 2018 Author Share Posted June 8, 2018 Thank you hozawa, yes I want to unescape the text, I will try to use replace(), thanks Link to comment Share on other sites More sharing options...
Solution victorlizonglin Posted June 8, 2018 Author Solution Share Posted June 8, 2018 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.<textElement markup="html">The detailed info could be found in there: http://jasperreports.sourceforge.net/sample.reference/markup/ Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now