Hi Brian,

British Virgin Islands

Tortola

                   151   284‑987‑4738

 

 

Canada

BC

                    24   604‑941‑4617

                    51   604‑298‑4841

                    60   604‑681‑9443

                    50   604‑941‑5469

                    45   604‑685‑0019

 

MB

                   222   204‑949‑6053

 

NS

                   221   902‑477‑9666

 

ON

                   219      416‑766‑5007

                   223      613‑235‑6617

 

PQ

                   220      514‑697‑0077

 

 

Chile

Providencia

                   150     56‑2‑2942‑9021

 

 

China

Guangdong

                   226     86‑21‑3492‑3294

 

Hong Kong SAR

                   228     852‑4667‑9393

                   229     852‑3778‑2929

                   230     852‑3838‑1919

                   231     852‑3998‑2044

                   161     852‑6274‑9201

is this what you looking for  the first column is customer id and second is telephone number ,

I have grouped on Country and then Region.... with the following settings Details Section Expert Format with Multiple columns selected

then in Layout tab  Down then Across selected

 

Format Groups with Multiple Columns Selected.

 

Cheers

Rahul

 

Edited by rahulwalawalkar - 25 Jan 2008 at 12:51am

I got it working! The answer is very odd though (I don't like how they implemented this at all).

Here's the deal, if you create a report using the Mailing Label wizard and you add groups to it, then you can't do "Newspaper columns" like I'm trying to do. As I showed in the first post, it treats a group as going across all the columns in the page. The option "Down then Across" doesn't look right.

So what you have to do is create a normal report and fit the fields into the desired width of the column size. After doing this, go to Section Expert and on the Details section select option Format With Multiple Columns. After doing that, the Layout tab magically appears. Click on that and set up the width of your label sizes. Secondly, check the option Format Groups with Multiple Columns. After making these changes, click OK to save and close the dialog box.

Viola! Your report will print in newspaper column format and the columns accurately go completely down the first column before starting at the top of the next column.

I will DEFINITELY be writing about this in the next book!