views:

1695

answers:

2

I am new to SSRS, so forgive my newbieness. I am using Sql Server 2008 and I want to show 1 single field from a table in multiple columns in the report. Just like if I were to print labels. How can I achieve this?

Example:

Instead of printing:

Names Report

Andrea
Austin
Barbara
Bob
Bruno
Cathy
Chis
...

I want to print in columns (say 3 fixed columns):

Names Report

Andrea ---- Bruno ---- Darren
Austin ---- Cathy ---- Francis
Barbara ---- Chis ---- Gabriel
Bob ---- David ---- Gerald
....... ---- ....... ---- .......

Edit: If I run the report and click on "Print Layout" button, I can see multiple columns. Can I set this mode as default?

A: 

You really need to post more detail about what you are trying to achieve - but why not use a table element in the report designer.

Jim Evans
I agree. Sorry. I've updated the question adding more details.Thanks
Gustavo Cavalcanti
I only have one field (Name) begin displayed. I want to flow into multiple columns, like when you select a block of text in a text editor and format it to more than one column.
Gustavo Cavalcanti
A: 

Use the 'Report' menu in Visual Studio and select 'Report Properties'. You can set columns in the 'Layout' tab.

Try this msdn article for more details:

http://msdn.microsoft.com/en-us/library/ms159107.aspx

Bo Schatzberg
Bo, thanks but this really doesn't help much. Adding a column to the report doesn't automatically split the content in columns. What do I need to do to show the data in columns after adding the columns to the report?
Gustavo Cavalcanti
I tested this and it worked for me. I had to clean up the report to put the columns where I wanted, but there were automatically 3 columns on the page once I made room for everything. Perhaps I'm not exactly understanding what you need.
Bo Schatzberg
What did you use to display the data? What controls? In my case I have a Tablix containing a TextBox bound to the field. I still get 1 single column in the report even though, the report has 2 columns specified.
Gustavo Cavalcanti
If I run the report and click on "Print Layout" button, I can see multiple columns. Can I set this mode as default?
Gustavo Cavalcanti
Did you get this figured out?
Bo Schatzberg