Is there a way to ensure a matrix layout does not expand horizontally
past a certain point (i.e. page)? There appears to be an option to try
and fit the matrix on one page but that doesn't stop it going over
multiple pages in the horizontal direction.
ThanksOn Apr 16, 5:57 pm, "gommo" <colin.gou...@.gmail.com> wrote:
> Is there a way to ensure a matrix layout does not expand horizontally
> past a certain point (i.e. page)? There appears to be an option to try
> and fit the matrix on one page but that doesn't stop it going over
> multiple pages in the horizontal direction.
> Thanks
Outside of the option you mentioned, as far as I know, there is
nothing else available. Sorry I could not be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Apr 16, 5:57 pm, "gommo" <colin.gou...@.gmail.com> wrote:
> Is there a way to ensure a matrix layout does not expand horizontally
> past a certain point (i.e. page)? There appears to be an option to try
> and fit the matrix on one page but that doesn't stop it going over
> multiple pages in the horizontal direction.
> Thanks
It will cut off additional data, but you could filter the outermost
column group on {group expression} by "Top N" ={max columns}, i.e for
at most 5 columns grouped on myID you would have a group filter for
myID by 'Top N' with value of '=5'.
Hope this helps ~ K
Showing posts with label expand. Show all posts
Showing posts with label expand. Show all posts
Friday, March 23, 2012
Monday, March 12, 2012
Matrix inserting spacing in my report
The matrix in my report expands left to right and displaces the other
tables/charts in my report. I've left enough room for it to expand. Is
there a way to tell it not to push the other stuff?Try to move the items above the matrix (which get pushed to the right) into
one containing rectangle. The top/left of the rectangle has to be closer to
left page border than the matrix top/left position. Does it work then for
you?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cindy Lee" <dangreece@.hotmail.com> wrote in message
news:ubM9QFiXEHA.644@.tk2msftngp13.phx.gbl...
> The matrix in my report expands left to right and displaces the other
> tables/charts in my report. I've left enough room for it to expand. Is
> there a way to tell it not to push the other stuff?
>|||Thanks, putting it in a rectangle works great.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23HnITVkXEHA.1888@.TK2MSFTNGP11.phx.gbl...
> Try to move the items above the matrix (which get pushed to the right)
into
> one containing rectangle. The top/left of the rectangle has to be closer
to
> left page border than the matrix top/left position. Does it work then for
> you?
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Cindy Lee" <dangreece@.hotmail.com> wrote in message
> news:ubM9QFiXEHA.644@.tk2msftngp13.phx.gbl...
> > The matrix in my report expands left to right and displaces the other
> > tables/charts in my report. I've left enough room for it to expand. Is
> > there a way to tell it not to push the other stuff?
> >
> >
>
tables/charts in my report. I've left enough room for it to expand. Is
there a way to tell it not to push the other stuff?Try to move the items above the matrix (which get pushed to the right) into
one containing rectangle. The top/left of the rectangle has to be closer to
left page border than the matrix top/left position. Does it work then for
you?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cindy Lee" <dangreece@.hotmail.com> wrote in message
news:ubM9QFiXEHA.644@.tk2msftngp13.phx.gbl...
> The matrix in my report expands left to right and displaces the other
> tables/charts in my report. I've left enough room for it to expand. Is
> there a way to tell it not to push the other stuff?
>|||Thanks, putting it in a rectangle works great.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23HnITVkXEHA.1888@.TK2MSFTNGP11.phx.gbl...
> Try to move the items above the matrix (which get pushed to the right)
into
> one containing rectangle. The top/left of the rectangle has to be closer
to
> left page border than the matrix top/left position. Does it work then for
> you?
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Cindy Lee" <dangreece@.hotmail.com> wrote in message
> news:ubM9QFiXEHA.644@.tk2msftngp13.phx.gbl...
> > The matrix in my report expands left to right and displaces the other
> > tables/charts in my report. I've left enough room for it to expand. Is
> > there a way to tell it not to push the other stuff?
> >
> >
>
Subscribe to:
Posts (Atom)