Expand

Hi,
I have a report with a matrix. The width of the body is 10in and the reportmargings are .5in. Above the matrix is a textbox with some information regarding the report. It as a width of 10in. The matrix has three groups above the columns where I put some daterelated fields in so I can simulate a date hierarchy. The hierarchy consists of the fields Year, Quarter and Month.
When I preview the report and set the Date level to Month the width of the matrix becomes greater than the width of the page. But the width of the textbox stays on 10in. Can this be dynamically adjusted to the width of the report?
QThere's no general "Grow to fit container" behavior in the current version.
But you can take advantage of the fact that table cells do have this feature
via the following sleazy hack:
1. Add a table to your report with one column, two header rows, no
groupings and no detail rows.
2. Put the textbox in the first cell
3. Put the matrix in the second cell
When the matrix expands, it will force the column to expand.
And the contents of the cells (including the textbox) must expand with it.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Qbee" <Qbee@.discussions.microsoft.com> wrote in message
news:3B04CD11-5C12-4E71-BA95-97E185784A31@.microsoft.com...
> Hi,
> I have a report with a matrix. The width of the body is 10in and the
reportmargings are .5in. Above the matrix is a textbox with some information
regarding the report. It as a width of 10in. The matrix has three groups
above the columns where I put some daterelated fields in so I can simulate a
date hierarchy. The hierarchy consists of the fields Year, Quarter and
Month.
> When I preview the report and set the Date level to Month the width of the
matrix becomes greater than the width of the page. But the width of the
textbox stays on 10in. Can this be dynamically adjusted to the width of the
report?
> Q
>|||Brilliant!...;-)
Q
"Chris Hays [MSFT]" wrote:
> There's no general "Grow to fit container" behavior in the current version.
> But you can take advantage of the fact that table cells do have this feature
> via the following sleazy hack:
> 1. Add a table to your report with one column, two header rows, no
> groupings and no detail rows.
> 2. Put the textbox in the first cell
> 3. Put the matrix in the second cell
> When the matrix expands, it will force the column to expand.
> And the contents of the cells (including the textbox) must expand with it.
> --
> This post is provided 'AS IS' with no warranties, and confers no rights. All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach of
> children under 3.
> "Qbee" <Qbee@.discussions.microsoft.com> wrote in message
> news:3B04CD11-5C12-4E71-BA95-97E185784A31@.microsoft.com...
> > Hi,
> >
> > I have a report with a matrix. The width of the body is 10in and the
> reportmargings are .5in. Above the matrix is a textbox with some information
> regarding the report. It as a width of 10in. The matrix has three groups
> above the columns where I put some daterelated fields in so I can simulate a
> date hierarchy. The hierarchy consists of the fields Year, Quarter and
> Month.
> >
> > When I preview the report and set the Date level to Month the width of the
> matrix becomes greater than the width of the page. But the width of the
> textbox stays on 10in. Can this be dynamically adjusted to the width of the
> report?
> >
> > Q
> >
> >
>
>