henriquep.freitas Posted August 21, 2023 Share Posted August 21, 2023 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:The list result: 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 More sharing options...
rpachipu Posted August 22, 2023 Share Posted August 22, 2023 Hi , Please check whether the list is placed in the detail band in main report? Also check list design and parameters passing to list dataset. It will be help to guess the issue if there is any sample jrxml. Link to comment Share on other sites More sharing options...
henriquep.freitas Posted August 22, 2023 Author Share Posted August 22, 2023 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 More sharing options...
rpachipu Posted August 23, 2023 Share Posted August 23, 2023 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now