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

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
 

i try again to show the above example, but again it shows in zig zag manner
 

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

Sorry I got the input but do not understand the output format. 
Phil
 
 

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

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

doesn’t usually sorting on the column and adding a break level on that column prevent the same value from printing ?