iReport technique

Hello:

I have study iReport some days,but no use it in project.Now I find a problem .


When I retrieve data which is '100001' from database ,but I hope it display
as 'Finance Department' which is department name.

It is easy in PB language,but I have no way in iReport.


DepNo DepName
------------------------------
100001 Finance Department
100002 Sales Department


orderid DepNo date price
-------------------------------------------------
80001 100001 2006.2.28 100.0
80002 100002 2006.2.27 80.0


I hope report like following :

-----------------------------------------------------
80001 Finance Department 2006.2.28 100.0
80002 Sales Department 2006.2.27 80.0

--
Message posted via JavaKB.com
http://www.javakb.com/Uwe/Forums.aspx/java-databases/200602/1
.