how to display distinct rows in subreport

[2002 JI Open Discussion]

By: Abdul Rasheed - abdulrasheed

how to display distinct rows in subreport

2003-06-16 03:01

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