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.

Reply via email to