Matrix width

How do you find out the width of a matrix control, I need this to
enable me to size the width of a Textbox, as the width needs to be the
same size as the Matrix control which keeps growing depending on the
dataThe width of your textbox is changing dynamically? Wow! How did you get it
to do that? The "increase to accomidate contents" checkbox only increases
the height on my version RS. I haven't found out to dynamically change the
width yet. And I believe several other people on this forum are searching
for this same functionality.
BTW, the only place I've seen the size properties (height & width) are in
the properties screen of the individual boxes or the rows or the
tables/matrices/lists. I asked a while back for how to call those properties
in an expression (I know it's similar to "Type!Name.Value" - still don't know
what type to use for properties), but no one answered the question.
Hopefully, someone will help us both out and answer the question here.
Catadmin
"Bryan Avery" wrote:
> How do you find out the width of a matrix control, I need this to
> enable me to size the width of a Textbox, as the width needs to be the
> same size as the Matrix control which keeps growing depending on the
> data
>sql

Matrix Width

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

Matrix tables - blank pages print

Hello,

I have a fairly large report with multiple matrix tables. They grow to a fixed width horizontally and may grow to various heights vertically. I have the interactive height set to zero so that it displays on the web page on one screen. When I go to print this report, I am getting a blank page between each page with data. Here are my dimensions:

Report:

height: 15 in

width: 8.5 in

interactive height: 0 in

interactive width: 8.5 in

left margin: .5 in

right margin: .5 in

top margin: .5 in

bottom margin: .5 in

Body:

height: 13.3875 in

width: 6.9 in

Would this problem be due to the fact that my matrix tables span an area greater than a normal page height in design mode even before they grow dynamically? Any suggestions would be appreciated.

Thanks.

Problem solved - it turned out to be hidden fields on the report that were causing the issue. Thanks.sql

Matrix sub-total column width

I have a matrix report which has a row total at the end e.g.
col1 col2 total
80.1 60.4 140.5
Is there a way in which I can make the total column wider than the data cells in the matrix or alternatively can I change the total format to have no decimal places? At the moment its width seems determined by the data cell width and formatting the column with #0 seems to have no effect.
Thanks1. Is there a way to make a matrix total column wider than the associated
data cells.
No. The width of the total column is bound to the width of the data cells.
2. Is there a way to format a total cell independently of the associated
data cells?
Yes. If you set the format code on the Subtotal cell (click on the green
arrow Total cell) it will be ignored. What you have to is use an expression
in the matrix data cell:
=iif(InScope("matrix1_ColumnGroupName"), "C", "C0")
Your expectation about being able to override the data cell format string
using the subtotal format property seems reasonable. I have passed your
observation along to the development team
-- Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"John H" <John H@.discussions.microsoft.com> wrote in message
news:951BAD17-40E0-4E7C-A76F-06323C08DF1B@.microsoft.com...
> I have a matrix report which has a row total at the end e.g.
> col1 col2 total
> 80.1 60.4 140.5
> Is there a way in which I can make the total column wider than the data
cells in the matrix or alternatively can I change the total format to have
no decimal places? At the moment its width seems determined by the data
cell width and formatting the column with #0 seems to have no effect.
> Thanks|||Many thanks Bruce, the formatting suggestion worked well. John
"Bruce Johnson [MSFT]" wrote:
> 1. Is there a way to make a matrix total column wider than the associated
> data cells.
> No. The width of the total column is bound to the width of the data cells.
> 2. Is there a way to format a total cell independently of the associated
> data cells?
> Yes. If you set the format code on the Subtotal cell (click on the green
> arrow Total cell) it will be ignored. What you have to is use an expression
> in the matrix data cell:
> =iif(InScope("matrix1_ColumnGroupName"), "C", "C0")
> Your expectation about being able to override the data cell format string
> using the subtotal format property seems reasonable. I have passed your
> observation along to the development team
>
> -- Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "John H" <John H@.discussions.microsoft.com> wrote in message
> news:951BAD17-40E0-4E7C-A76F-06323C08DF1B@.microsoft.com...
> > I have a matrix report which has a row total at the end e.g.
> >
> > col1 col2 total
> > 80.1 60.4 140.5
> >
> > Is there a way in which I can make the total column wider than the data
> cells in the matrix or alternatively can I change the total format to have
> no decimal places? At the moment its width seems determined by the data
> cell width and formatting the column with #0 seems to have no effect.
> >
> > Thanks
>
>|||Hi,
i have used matrix in one report. in that for ex i have Col1 in Row region,
Col2 in Dynamic column region,Col3 in data region. Is there a way to have
subtotal below Col3 and subtotal for Col2 side by Col2. when i right click on
Col3 it doesnt have Subtotal option.Please help me out. My expected output
should be as below
--|--|
| Col2 | Expected subtotal
--|--|
Col1 |Col3 |
--|--|
Expected
Total
"John H" wrote:
> I have a matrix report which has a row total at the end e.g.
> col1 col2 total
> 80.1 60.4 140.5
> Is there a way in which I can make the total column wider than the data cells in the matrix or alternatively can I change the total format to have no decimal places? At the moment its width seems determined by the data cell width and formatting the column with #0 seems to have no effect.
> Thanks

matrix moving other controls

RS 2005

I have a matrix item in a report. It is only about 7cm in width in design mode but obviously explodes out to about 30cm in when the report is run as thats the way the query behind it works.

The problem is any control e.g. a chart placed above and to the right of the matrix in design mode gets pushed across to the end of the matrix's width when the report is run, which causes extra pages in the report.

Other controls placed directly above the matrix in design mode hold their position when the report is run, it is only those controls placed further right than the end of the matrix (and above the matrix) in design mode that get pushed across. Why is this, is there a way to fix it?

Thanks

N

Have you looked into grouping the items above / below the matrix with a rectangle so that all these items are contained within that rectangle and the rectangle is closer to the left edge of the report than the left edge of the matrix?

Once the other items are contained within a rectangle - only the layout dependencies between the matrix and the rectangle remain. The position of the items contained within the rectangle will be unaffected by the growth of the matrix.

-- Robert

|||

I have the same problem

how do you group the rectangle to the controls ?

I have 2 images the top image near the table header stays put but the one below that moves with the table..

I place a rectangle but the image still moves

matrix moving other controls

RS 2005

I have a matrix item in a report. It is only about 7cm in width in design mode but obviously explodes out to about 30cm in when the report is run as thats the way the query behind it works.

The problem is any control e.g. a chart placed above and to the right of the matrix in design mode gets pushed across to the end of the matrix's width when the report is run, which causes extra pages in the report.

Other controls placed directly above the matrix in design mode hold their position when the report is run, it is only those controls placed further right than the end of the matrix (and above the matrix) in design mode that get pushed across. Why is this, is there a way to fix it?

Thanks

N

Have you looked into grouping the items above / below the matrix with a rectangle so that all these items are contained within that rectangle and the rectangle is closer to the left edge of the report than the left edge of the matrix?

Once the other items are contained within a rectangle - only the layout dependencies between the matrix and the rectangle remain. The position of the items contained within the rectangle will be unaffected by the growth of the matrix.

-- Robert

|||

I have the same problem

how do you group the rectangle to the controls ?

I have 2 images the top image near the table header stays put but the one below that moves with the table..

I place a rectangle but the image still moves

Matrix column size

Hi
Can I set dynamically the width of a matrix column at runtime?
I'm using VisualStudio 2008 and a rdlc local report.
Thank's in advanceHello Giorgio,
Based on my research, there is not method to modify the width of a matrix
column on the fly when rendering the report. Also, we could use expression
to change the column width.
If you'd like to control column width you can use a table control (or a
matrix control with static columns), which would give you individual
control over the column widths.
Please rest assured your feedback on this is routed to the right channel.
In the mean time, you could submit via the link below
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Matrix - Limiting the width

Hi,

I have a matrix object in a report that sometimes runs off the side of the page based on the underlying data. Essentially if there are more than 11 columns it stretches out my page.

How can I fix this? Ideally, I would like to show only the Top 11 results but cannot seem to figure out how (or where, or on what data element) to properly set a filter.

Thanks.

Brad

You mean if there are more than 11 rows?

To get the top 11 results, you can do this:

select top 11 * FROM ... WHERE ....