SQL Server Reporting Services how to make a newspaper column report

Question

I want to print an employee directory with photos of each employee and need to be able to have 3 columns on the report. I selected the number of columns as 3 as a Report Property but it still only prints 1 column wide. What do I need to change?

Answer 1

Hi @Fandango1985 ,

Suppose you are using a Newsletter-Style Report.

You may edit the report with report builder.

Run the report and see the print layout, it will show the print style.

You said that it only print 1 column wide, I think it maybe related with the page size settings.

Please ensure that the page size is at-least equal to -> ([Original report body size times the number of columns] + all the column spacing values).

Or you may manual adjust the size to make it fit the print layout.

If I misunderstand your meaning, please incorrect me and design sample is better for us to do more test.
Regards，
Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

What can I do if my transaction log is full?--- Hot issues November

How to convert Profiler trace into a SQL Server table -- Hot issues November