 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / March 2006iReport 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 > When I retrieve data which is '100001' from database ,but I hope it display > as 'Finance Department' which is department name. When I used iReport and similar tools I remember that one should refine his SQL statements in the case of similar problems. Maybe you can use something like select orderid,firsttable.depno,depname,date,price from firsttable, secondtable where firsttable.depno=secondtable.depno order by price; > It is easy in PB language,but I have no way in iReport. > [quoted text clipped - 13 lines] > 80001 Finance Department 2006.2.28 100.0 > 80002 Sales Department 2006.2.27 80.0  SignatureMladen Adamovic http://home.blic.net/adamm http://www.shortopedia.com http://www.froola.com yes ,this is good idea. but I want know whether iReport can use drop down list data .If you used powerbuilder ,maybe you know that function is very convenience. >> When I retrieve data which is '100001' from database ,but I hope it display >> as 'Finance Department' which is department name. [quoted text clipped - 11 lines] >> 80001 Finance Department 2006.2.28 100.0 >> 80002 Sales Department 2006.2.27 80.0 > yes ,this is good idea. but I want know whether iReport can use drop down > list data .If you used powerbuilder ,maybe you know that function is very > convenience. I've never used powerbuilder and I wonder what is that drop down list data? In web development drop down list data is choice group for user with the predefined entries. If you cannot explain what it is perhaps you could send an image of it to my email. I'm curious. SignatureMladen Adamovic http://home.blic.net/adamm http://www.shortopedia.com http://www.froola.com I have a report that was designer by iReport and sql define was select sex, order_date,cost from tableA . It will have three field .departmentId, order_date,cost .It may show follwing . 01 2006.02.03 $1000.0 02 2006.02.03 $3000.0 01 2006.02.04 $1400.0 if sex field is no store in the database ,but it have two properties 'M' / 'W' . I hope repost get following result. M 2006.02.03 $1000.0 W 2006.02.03 $3000.0 M 2006.02.04 $1400.0 I have not coding in the project so no image . thanks! >> yes ,this is good idea. but I want know whether iReport can use drop down >> list data .If you used powerbuilder ,maybe you know that function is very [quoted text clipped - 4 lines] >with the predefined entries. If you cannot explain what it is perhaps >you could send an image of it to my email. I'm curious. You have basically iReport question so the best place for it is iReport and JasperReports mailing list and forums. Anyway, as long as I remember there is a way to assign column of the report output as a result of Java method but I cannot remember how because I worked with those tools very long ago. > I have a report that was designer by iReport and sql define was select sex, > order_date,cost from tableA . It will have three field .departmentId, [quoted text clipped - 25 lines] >> with the predefined entries. If you cannot explain what it is perhaps >> you could send an image of it to my email. I'm curious. SignatureMladen Adamovic http://home.blic.net/adamm http://www.shortopedia.com http://www.froola.com Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.