Duplicate entries on the printed report

10 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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)

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb
    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. 
    51,355 pointsBadges:
    report
  • TomLiotta
    Without any description of what is meant by "query", it's impossible to know. Much more info is needed about the problem.Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following