Home > IT Answers > AS/400 > Duplicate entries on the printed report
63bunnies
10 pts.
 Duplicate entries on the printed report
AS/400, AS/400 Query
I have a written a query and do get results however when it populates the information it duplicates each entry X4.    

Software/Hardware used:
HMS / AS400
ASKED: August 22, 2012  11:36 PM
UPDATED: August 23, 2012  12:37 PM
RELATED QUESTIONS
Answer Wiki:
We would need more information to assist you. My guess is that you are joining files and are getting data from the primary file multiple times because of multiple records in the secondary file(s)
Last Wiki Answer Submitted:  August 23, 2012  12:47 pm  by  CharlieBrowne   32,905 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,905 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

or perhaps the “Define report breaks” doesn’t make sense .. especially if you haven’t set the “Select sort fields” to the sequence the data properly. 

philpl1jb
 44,190 pts.
 

Without any description of what is meant by “query”, it’s impossible to know. Much more info is needed about the problem.Tom

TomLiotta
 108,260 pts.