question

David Wimbush avatar image
David Wimbush asked

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?
sql-server-2008-r2reporting
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Fatherjack avatar image
Fatherjack answered
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 ...
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image David Wimbush commented ·
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.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.