Jump to content
Changes to the Jaspersoft community edition download ×

how to display distinct rows in subreport


Recommended Posts

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

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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