all groups > sql server reporting services > march 2005 >
You're in the

sql server reporting services

group:

Multiple Column Reports Problem



Multiple Column Reports Problem JeffW
3/30/2005 2:51:43 PM
sql server reporting services: Have a report containing a single matrix. Have narrowed the matrix to
2.5 inches wide and specified 2 columns in the report layout.

I am aware that previewing the report will only display data in the
first column and that's what it does. However, when I Print Preview or
Export to PDF, I still only see data in the first column.

What am I missing? Thanks.

Jeff
Re: Multiple Column Reports Problem JeffW
3/31/2005 12:14:34 PM
Correction: the report contains a table, not a matrix. Any advice
would be greatly appreciated.
Re: Multiple Column Reports Problem Kaisa M. Lindahl
4/1/2005 9:52:13 AM

[quoted text, click to view]

Have you added content to the second column? Or is it conditional or
something?
Wrong font color?
Sounds weird.

Kaisa M. Lindahl

Re: Multiple Column Reports Problem JeffW
4/1/2005 1:49:48 PM
Not sure I follow. It's not a problem displaying a column inside the
table. I want the report itself to display as two columns on the page.
Re: Multiple Column Reports Problem Kaisa M. Lindahl
4/4/2005 1:00:12 PM

[quoted text, click to view]

Not sure if I'm following you either.
Have you deployed your report to Report Manager? Does it show one or two
columns there?
If you know it won't display more than one column during preview, I don't
think it will display any more than what is there if you export the preview
to PDF. The pdf just renders what's in the webpage to the pdf format.

Kaisa

Re: Multiple Column Reports Problem JeffW
4/21/2005 12:53:26 PM
Largely solved my problem. Must set the following to display 2 columns
on 1 page:

1. Report parameter columns=2 (obviously)
2. Report Body parameter width=3in or so (less obvious). Must set the
body width to correspond to the column. Otherwise, the body fills the
page and only contains one column.

Note that the report preview still displays only one column. Also the
Report Manager still only displays the report with one column.
Exporting to "HTML with Office Web Components" still only displays one
column. However, exporting to PDF or TIFF generates the report I'm
looking for -- 2 columns on a single page.

For what I need, this will do the trick. However, not seeing 2 columns
in the Report Manager is a bit inconvenient, not being WYSIWYG and all.
Any suggestions here?

Thanks.
AddThis Social Bookmark Button