Report with Columns

[mcgettge]

I am creating a report with columns. What I am looking to produce is a sales chart. I will show an example:

District 1 District 2 District 3
---------- ---------- ----------
Store10 - Sales Store21 - Sales Store31 - Sales
Store11 - Sales Store22 - Sales Store32 - Sales
Store12 - Sales Store23 - Sales Store33 - Sales
Store13 - Sales Store24 - Sales
Store25 - Sales District 6
District 4 ----------
---------- District 5
-----------

I am looking to find a way so that District 4-6 headers line up going across if the number od stores in the first 3 districts are not equal. I am also looking to make sure that if a district will not fit in a column that it will not start to print and continue to the next. Any help would be greatly appreciated.

 

[mcgettge]

I got the groups to stay together. Any ideas on how to Align the header (district name) for each group across the page?

 

[mcgettge]

Looking to get a report with columns to line up across the page. The first row does, but the remaining rows are staggered beased on the number of records reported.