Digging around I found this note in the VFP 9 SP2 help file: How to: Define Columns in Reports
In Visual FoxPro 9.0, setting label-style print order has some additional impact on reports. When you use this option to make columns flow from left to right, group and detail header and footer bands extend across the page, so they can provide true header information for the entire row. The detail band starts one row down from any header bands you design in the layout. In earlier versions, **Column print order** did not change the behavior of group header and footer bands, so the first detail item printed adjacent to the innermost group header on the same row. The logic to display only specific data that is gathered in variables in the report should be printed in a group footer. The group footer no longer moves from column to column. Setting the "Associated header and footer bands" in the Detail Band Properties results in the detail band never going to the right columns. May this help someone in the future. Tracy -----Original Message----- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Monday, January 16, 2023 12:28 PM To: profoxt...@leafe.com Subject: Report with 2 Columns, Left to Right and Groups Hello everyone, I don't work with the VFP reports very often. My coworker brought up a problem he has found when building a custom report for a customer. Using a single flat table and building a report with multiple columns and have it go left to right the details properly go left to right. Once a grouping is added to the report, everything prints in the left column only. Switch the report to be Top to Bottom and both columns are used. For what is in this report, it would be better to have this left to right. Custom programming to group things before going to the report is not an option. Creating a similar report in the IDE, not the runtime, does not exhibit this behavior. Does anyone have an idea on how to get the report to behave? We have tried this in VFP 9 SP 2 HF 3 Thank you, Tracy [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/005301d929f5$f18a0160$d49e0420$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.