Jump to content
Changes to the Jaspersoft community edition download ×

Need help-6 Tables in one report!!! URGENT


Recommended Posts



I have a problem and no idea how to solve this problem:


I have a table A, in this table there is for example a field ID in it, which refers on a field ID_firma in table B. Now I don't want to give back the ID in the field, but the name of the firma from this ID.. any ideas how to manage this?


Table A

ID: 1


Table B

ID: 1

Firma: Oleg AG


Result should be:

in table: A Oleg AG ...


Please help me!

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

I think that a query might be the solution of your problem.

The query might be like this:


select a.field, b.firma AS FIRMA from a,b




In IReport you could show only $F{FIRMA} and not the key (a.id).


If you prefer you could create a view that shows all the field you need of table a and b.

The sintax is


create or replace view xxx as(

select a.field1 field1,a.field2, a.field3,b.firma

from a, b

where a.id=b.id)

and then you make all the queries on this view.


I hope that this help




Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...