Newspaper column style report

We have a report that shows the staff phone list in a table. It's quite narrow (Name, Extension, Full Number) but long and now prints on two pages. Most people want to print it (I know!) and they want me to wrap the list round to the top of the page and show a second set of columns beside the first set, so the list prints on one page. Like this:

Name  Ext   Full No.        Name  Ext  Full No.

I can't find any obvious properties in the Tablix or Tablix group to enable this, but I'd be surprised if it's not possible.

Any ideas, please?
more ▼

asked Jun 30, 2010 at 02:04 AM in Default

David Wimbush gravatar image

David Wimbush
5.2k 29 31 34

(comments are locked)
10|1200 characters needed characters left

1 answer: sort newest
Right click in the body of the report and then go to the properties, there is a column property that is set to 1 by default. Change that to 2 and you may well have what you want ...
more ▼

answered Jun 30, 2010 at 03:18 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

Jack, you beauty! Thanks very much. For the record it's a property of the Report, not the Body. It's odd but it only goes to 2 columns when you print the report or open it as a PDF. Apparently this is by design, though, so that's alright.
Jun 30, 2010 at 06:15 AM David Wimbush
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 30, 2010 at 02:04 AM

Seen: 1596 times

Last Updated: Jun 30, 2010 at 02:04 AM