Report with each group in a new column

[sv89]

Hi, I'm trying to build a report with each group in a new column similar to 'Products by Category' report in the Nwind example.

I've set it such that 2 groups appear on a page.

The problem is that the 1st group appears in the middle of the first page and only 1 group appears on the 1st page. How do I make this appear at the left margin? Hopefully, if I fix that the 2nd group will appear on the 1st page.

It works fine on the 2nd and subsequent pages where 2 groups appear on a page and the group appears near the left margin.

 

[vbaInet]

Perhaps some legible screenshots would help. A screenshot of your form in design view and a labelled screenshot of it in Print Preview highlighting the problem areas.

 

[sv89]

Decided to go with a report based on a cross tabbed query instead. Thanks.

 

[vbaInet]

Good to know you thought out a solution and thanks for coming back.