Matrix Report Column break in PrintPreview

Hi,

I have a problem in matrix report printpreview where the Column break doesn't happen correctly in printpreview. Some columns go to the next page. Is there any solution to fix this problem.

Below is an example, while print preview some columns are displayed in the next page. I want all the 4 columns to fit in one page.

Name
-----------
Col1|Col2|Col3|Col4

set the width of the matrix to 8.5 or less...

|||

Try to adjust your matrix chart size

Matrix break to next row (not span across pages)

I have a 8.5 X 11 report (portrait)
I have a matrix with two static rows and dynamic columns. The no. of
columns are anywhere between 4 to 8. Under that I have a graph.
What I want is simple. In my report, if the columns go beyond 4, they
seem to span across pages. While it keeps the graph on the first page.
I don't want that. Instead, I want the whole matrix to continue on the
same page (in two matrices, if needed). The graph can pushed out to
the next page.
Here is a visual:
THIS IS WHAT IS HAPPENING:
========================== Page 1
|Col1|Col2|Col3|Col4|
--
Row1| | | | |
--
Row2| | | | |
--
[Graph]
Page 2
|Col5|Col6|Col7|Col8|
--
Row1| | | | |
--
Row2| | | | |
--
THIS IS WHAT I WANT:
==================== Page 1
|Col1|Col2|Col3|Col4|
--
Row1| | | | |
--
Row2| | | | |
--
|Col5|Col6|Col7|Col8|
--
Row1| | | | |
--
Row2| | | | |
--
Page 2
[Graph]
Must be something simple... just don't seem find the answer.
ThxThis is not possible. Based on the runtime matrix size we will produce
multiple horizontal pages (the matrix witdth > page width) and multiple
vertical pages (matrix height > page height). We will not split at runtime
the matrix in multiple small matrices.
You need to create a report with 2 matrices or a matrix inside of a list and
filter/hide the columns accordinglly.
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407080821.2ead760@.posting.google.com...
> I have a 8.5 X 11 report (portrait)
> I have a matrix with two static rows and dynamic columns. The no. of
> columns are anywhere between 4 to 8. Under that I have a graph.
> What I want is simple. In my report, if the columns go beyond 4, they
> seem to span across pages. While it keeps the graph on the first page.
> I don't want that. Instead, I want the whole matrix to continue on the
> same page (in two matrices, if needed). The graph can pushed out to
> the next page.
>
> Here is a visual:
> THIS IS WHAT IS HAPPENING:
> ==========================> Page 1
> |Col1|Col2|Col3|Col4|
> --
> Row1| | | | |
> --
> Row2| | | | |
> --
> [Graph]
>
> Page 2
>
> |Col5|Col6|Col7|Col8|
> --
> Row1| | | | |
> --
> Row2| | | | |
> --
>
> THIS IS WHAT I WANT:
> ====================> Page 1
> |Col1|Col2|Col3|Col4|
> --
> Row1| | | | |
> --
> Row2| | | | |
> --
> |Col5|Col6|Col7|Col8|
> --
> Row1| | | | |
> --
> Row2| | | | |
> --
> Page 2
> [Graph]
>
> Must be something simple... just don't seem find the answer.
> Thx