Query400 report generation

255 pts.
Tags:
AS/400 Query
I'm using query400 tool and using output type as printer files.. I want to generate a report format of transactions like this.. date act# amount date1 act no1 total act no2 total act no3 total date1 act no1 total act no2 total Final Total example transaction is like date act# amount 23/10/12 100 200 23/10/12 101 300 23/10/12 100 200 23/10/12 102 500 23/10/12 103 200 23/10/12 101 600 24/10/12 101 200 24/10/12 103 200 24/10/12 102 200 24/10/12 102 200 25/10/12 101 200 25/10/12 103 200 25/10/12 103 200 25/10/12 104 200

Answer Wiki

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

Discuss This Question: 9  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
  • TomLiotta
    I had to copy/paste your example into a discussion box, and then remove formatting before I could make sense of it (which is very odd to have to do). I'd paste it back here with formatting, but I figure it won't look better.   For me, Query/400 query is too old and out of date for this kind of output. I'd use a Query Manager query and report form instead. But if anybody else can help, I hope I at least described how they can interpret your example. (It's not your fault. This editor needs a lot of work.)   BTW, if this was a QM query/report, the source could be posted. But you can't do that with Query/400.   Tom
    125,585 pointsBadges:
    report
  • sivakesava
    using query400 tool and using output type as printer files..i want to generate a report format of transactions like this..    date           act#       amount date1         act no1    total                    act no2    total                    act no3    total date1         act no1    total                   act no2    total                                     Final   Total example transaction is like date                                           act#                               amount23/10/12                                    100                                 20023/10/12                                    101                                 30023/10/12                                    100                                 20023/10/12                                    102                                 50023/10/12                                    103                                 20023/10/12                                    101                                 60024/10/12                                    101                                 20024/10/12                                    103                                 20024/10/12                                    102                                 20024/10/12                                    102                                 20025/10/12                                    101                                 20025/10/12                                    103                                 20025/10/12                                    103                                 20025/10/12                                    104                                 200  
    255 pointsBadges:
    report
  • sivakesava
    i try again to show the above example, but again it shows in zig zag manner  
    255 pointsBadges:
    report
  • TomLiotta
    I know. But I expect one of the Query/400 users will understand how to straighten it out. You probably can't make it look better. It gets messed up when browsers render it in HTML. -- Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    Sorry I got the input but do not understand the output format.  Phil    
    49,540 pointsBadges:
    report
  • TomLiotta
    Output is generally a simple summary of amount by account (minor) within date (major). Date is suppressed on summary lines after the first. It's a fairly simple report, but not trivial to describe for Query/400. -- Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    select sort fields 1. Date 2. Account Select report summary functions 1 (Total) Amount Define report breaks 1. Date 2. Account Surpress summary 'Y' twice   Select Output Type and Output Form 2 Preinter 1 include details or 2 don't include details Not sure how to get the repeating date to not print. Hope that helps
    49,540 pointsBadges:
    report
  • TomLiotta
    Not sure how to get the repeating date to not print.   That was the piece I wasn't sure about. I thought I remembered it from way back when I used to use Query/400. It's relatively easy with QM, but not sure about summary lines in Query/400.   Tom
    125,585 pointsBadges:
    report
  • ToddN2000
    doesn't usually sorting on the column and adding a break level on that column prevent the same value from printing ?
    8,185 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