Jump to content
Changes to the Jaspersoft community edition download ×

List Priting Same Values in Different Rows?


henriquep.freitas

Recommended Posts

Hello! 

I have a query of two record, each with a different quantity, and I've created a list to display those informations, each row with it's own table.

The problem is that for each list, it is printing the value twice, when it should read only once for each row. Pics with examples below:

The query result:

converted-file.png.eb89608a7a6dee28ccf177106ecd9b0a.png

The list result: 

converted-file.png.6c0d3880e2f65b6650852187b2fa960c.png

It should print only 1 column of information per list, and not the Duplicate ones. I hope you can understand :) 

Thanks!

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

Hi! First of all, thanks for the fast reply!!

So, This list is inside the detail band of a subreport, and this subreport is inside the Detail Band of the main report. 

Highlighted in red is the list position inside the subreport:

This is the main report: 

I want to send you a .jrxml example, but this is a report that I use inside my company, And I'm afraid that I cannot share it openly :( but if you know any way to do it the "safe" way let me know hahaha.

Parameter wise, this is what I'm using: 

Thanks for all the help so far!!

 

 

Link to comment
Share on other sites

What is the print order of the list? Is it horizontal? The parameter passing from subreport to list is that filtering the data to pick the matching record of that of subreport?  Also please pass the data's row identifier from subreport to list. ie., eg itemNo. $F{item} of subreport to list's parameter $P{item} and to the list's dataset's query to filter unnecessary only show the item of subreport passing to list.

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