x

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
5k 29 30 34

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

1 answer: sort oldest
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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x593
x94

asked: Jun 30, 2010 at 02:04 AM

Seen: 1576 times

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