Is there a way to do a "column-break"? (1 Viewer)

[bpd]

I am doing a report where I have my page formatted into two columns. I have the same basic info in each column (name, qualification %). They are basically split up into section 1 and section 2, that is why I have the two columns. Right now my report just lists them in order (down the left column and then starting in the right column) with all of the ones from section 1 followed by section 2.

I would like to put a "column break" in so that regardless of the space at the bottom of the page, it will kick the remaining entries into the second column. Page break won't work, but is there a way to do a column break???

Thanks,
Brian

 

[oldaf294]

column break

bpd,
Open the report in design view and click on the "sorting and grouping" icon in the task bar.
Set the options below "sorting" as;

Group Properties
group header "yes"
group footer "yes"
group on "each value"
group interval "1"
keep togeather "whole group"

open the report.

 

[oldaf294]

grouping

bpd,

I forgot to add an important instruction!!!

Open the report in design view and click on the "sorting and grouping" icon in the task bar.
Select the field you want to group on. (your "section")
Set the options below "sorting" as;

Group Properties
group header "yes"
group footer "yes"
group on "each value"
group interval "1"
keep togeather "whole group"