Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Behavior of a 2-Column report in FPW2.6a

Status
Not open for further replies.

ChrisMc

Programmer
Apr 24, 2002
43
GB
I have a two-column report: items of [Group type 1] must be in column 1, items of [Group type 2] must be in column 2. The table contains records where [Group type 1] are first, but the number of records of [Group type 1] is variable.

In the report, [Group type] is set to start a new column when it changes; the detail it contains has 'If less than x cm below header, begin new page' set to 2cm (I've tried altering this).

I would expect that if [Group type] is 1 and the column has been filled, a new page would be started, but this is not so - the detail overflows to column 2.

Does anybody have a method that would allow me to FORCE a new page when column 1 is full and [Group type] is still 1

Thanks in advance
ChrisMc
 
You could maybe just stick to a one column report and have two fields: one in the first column and one in the second. Set the 'print when' on the field something like:
IIF(group1, .T., .F.)

Same with column/field 2:
IIF(group2, .T., .F.)



-Dave Summers-
[cheers]
Even more Fox stuff at:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top