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
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