all groups > sql server reporting services > october 2007 >
You're in the

sql server reporting services

group:

Multiple Body Columns



Multiple Body Columns Mike
10/19/2007 9:30:20 AM
sql server reporting services: How do I setup multiple columns in a report? For example: How would I take a
report that has 1 table with 1 column. Currently this one column is written
vertically down from top to bottom over 10 pages. If I repeat the column
multiple times on the same page I can cut the report down to 2 pages. In
Crystal Reports they call it "Formatting Groups with multiple columns". Can
anyone point me in the right direction?

Thanks!

Re: Multiple Body Columns Mike
10/19/2007 9:37:21 AM
I have seen the columns property on the body, but when I set it to something
other than 1 shows multiple columns in design, but does not output them in
preview.


[quoted text, click to view]

Re: Multiple Body Columns Alain Quesnel
10/19/2007 1:05:04 PM
I read somewhere that this in only possible in certain rendering formats
(i.e. TIFF or printer, I can't remember which). I couldn't make it work in
any format, so I used a workaround with a stored proc that returns a dataset
with extra columns (in your case 4 or 6 columns) containing the extra
records. Then I put the data in a grid that has a blank, non-framed column
between each set of extra columns. I can send you a pdf of the output if you
like. If you don't know the exact number of pages, that solution might
become complicated. In my case, that part of the report never goes over one
page.

--


Alain Quesnel
alainsansspam@logiquel.com

www.logiquel.com


[quoted text, click to view]
Re: Multiple Body Columns Mike
10/19/2007 1:54:57 PM
You're right! I tried to view the report as a tiff and as a PDF and they
displayed properly. I should be able to use that. Too bad the HTML format
doesn't work. Thanks for the lead on this.

Mike

[quoted text, click to view]

Re: Multiple Body Columns Alain Quesnel
10/20/2007 5:09:57 PM
I just checked. The printer output also works (i. .e. paper).

--


Alain Quesnel
alainsansspam@logiquel.com

www.logiquel.com


[quoted text, click to view]
RE: Multiple Body Columns calton NO[at]SPAM online.microsoft.com
10/22/2007 5:55:42 PM
You can find more information about Multi-Column reports and how to
make/design them at the link here:
http://msdn2.microsoft.com/en-us/library/ms155816.aspx
-------------------------------------
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
[quoted text, click to view]
AddThis Social Bookmark Button