merge master and child table in report

[2002 JI Open Discussion]

By: Abdul Rasheed - abdulrasheed

merge master and child table in report

2003-06-14 09:02

Scenario:

 

We need to generate a report like the following template..

 

Two Tables.

Department Info

Employee list

 

Header:

Department Name XYZ

Department Desc: Maintenance Department

 

Detail:

Emp ID Emp_Name Emp Sal

1 aaa 1000

2 bbb 2000

 

Footer:

Page No : 1

 

How can we achieve this??

 

 

Thanks

 

 

 

 

 

By: Teodor Danciu - teodord

RE: merge master and child table in report

2003-06-14 13:48

 

Hi,

 

I think you should check the subreports

functionality of the JasperReports engine.

It perfectly suits your scenario.

 

Thank you,

Teodor

 

 

 

 

 

By: Abdul Rasheed - abdulrasheed

How to display multiple rows in child table

2003-06-16 02:57

Scenario:

 

Master Table: Employee

ID

firstname

lastname

 

Child Table : Address

ID

street

city

postalcode

 

i have used subreport functionality in jasperreports through iReport Tool.

 

I having 2 records for the ID in the child table

i.e two address for a employee

 

The subreport is displaying like

 

ID 200

firstname xyz

lastname xyz

 

street 11,st1

city Delhi

postalcode 7897

 

street 11,st1

city Delhi

postalcode 7897

 

The child report is displaying two rows of same value. But i have different values in the Database.

 

eg:

 

street 11,st1

city Delhi

postalcode 7897

 

street 12,st2

city Bombay

postalcode 999

 

So how to see the distinct values for my child report.

 

Need suggestion..