Text report writer for upload to mainframe.

[plang99]

Access, Crystal Reports and R&R are good for paper reports but their text export adds extra spaces.

Any suggestions on a third party report writer that has exact column beginning and ending alignment?

 

[plang99]

Had a brainstorm while driving in the car.
(I do my best programming in my head then with a note pad handy.)

I solved the problem of exporting fixed fields for the Grouped Orders and Order Details.

The queries and parameters were all done with SQL statements.
All the bands were done only in VBA Code including Counts and Sums.

The Report Header has Company Information and Products (as subreport) sold that week all in VBA Code.
The Order ID header has Orders information in VBA Code.
The Order Details in the Detail Band is in VBA Code.
The Report Footer with the Counts and Sums is in VBA Code.

I wrote the code in a Text Editor and pasted into Access Report bands.