Jasperreports+ireport doesn’t support display value, how do I?
In database construction, code table (or called dictionary table) is very common. For example, in a Employee Information report, degree field is saved as codes “1, 2, 3…” in employee table, while corresponding titles “Junior College, College, Master…”are saved in degree code table. Then it’s required that reporting tool should have a conversion mechanism from “code” to “title”: truth value is “code” while display value is “title”.
But Jasperreports+ireport doesn’t support this mode. It can achieve this function only by writing complex statements in SQL.
Is there any other free reporting tool that can achieve this function easily?
Related Blogs
- Related Blogs on Construction Code
- Code Council Launches Green Construction Code Initiative « EMGS …
- GREEN CONSTRUCTION: International Green Construction Code to …
- Links for July 26th through July 27th
- code, circuits, & construction :: Physical x Wonderfl
- Energy Code Works » Blog Archive » Resources Help Builders Start …
- Related Blogs on Ireport
- CNN iReport at Seattle Hempfest | NORML Daily Audio Stash
- CNN iReport: Hunger Strike Goes On
- President Barack Obama iReport Card « Middle East Phoenix's Blog
- Graphical Report Design with iReport: Part 2
- Graphical Report Design with iReport: Part 1
- Dallas Restaurants
- Related Blogs on Jasperreports
- Jasper Reports « Thoughts Decoded
- CHARTING WITH JASPER REPORTS
- Java Programming - Call jasper report from java
Related Blogs
- Related Blogs on Construction Code
- Code Council Launches Green Construction Code Initiative « EMGS …
- GREEN CONSTRUCTION: International Green Construction Code to …
- Links for July 26th through July 27th
- code, circuits, & construction :: Physical x Wonderfl
- Energy Code Works » Blog Archive » Resources Help Builders Start …
- Health Blog
- Related Blogs on Ireport
- CNN iReport at Seattle Hempfest | NORML Daily Audio Stash
- CNN iReport: Hunger Strike Goes On
- President Barack Obama iReport Card « Middle East Phoenix's Blog
- Graphical Report Design with iReport: Part 2
- Graphical Report Design with iReport: Part 1
- Related Blogs on Jasperreports
- Jasper Reports « Thoughts Decoded
- CHARTING WITH JASPER REPORTS
- Java Programming - Call jasper report from java
Related Blogs
- Related Blogs on Construction Code
- Code Council Launches Green Construction Code Initiative « EMGS …
- GREEN CONSTRUCTION: International Green Construction Code to …
- Links for July 26th through July 27th
- code, circuits, & construction :: Physical x Wonderfl
- Energy Code Works » Blog Archive » Resources Help Builders Start …
- Related Blogs on Ireport
- CNN iReport at Seattle Hempfest | NORML Daily Audio Stash
- CNN iReport: Hunger Strike Goes On
- President Barack Obama iReport Card « Middle East Phoenix's Blog
- Graphical Report Design with iReport: Part 1
- CNN's iReport attracts nearly 4000 submissions on Iranian …
- Guitar Tabs
- Related Blogs on Jasperreports
- Jasper Reports « Thoughts Decoded
- CHARTING WITH JASPER REPORTS
- Java Programming - Call jasper report from java


There is a free reporting tool — RAQ Report, a real Excel-like Web-based Java reporting tool.
With RAQ Report, you can define the expression of display value as required. “Display value” is only used to display the value. When cells cite each other, they can refer to either of display value and truth value.
For more For more details and graphic illustration, you can refer to.
Good luck.