Friday, March 9, 2012

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

No comments:

Post a Comment