Jump to content
Changes to the Jaspersoft community edition download ×

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


nolita

Recommended Posts

hi,

 

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

where

a.id=b.id

 

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

 

Bye

dpinfo

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...