Matrix Totals - left formatted

I have successfully created a matrix consisting of payroll dates as column
headers, with task types as my rows and hours/task/day the detail data. The
columns total perfectly, but the totals only display to the RIGHT of all the
data. We display our totals FIRST, then the detail data. Can I do this?
total hrs day 1 day 2
task 1 16 8 8Yes. Click on the little green triangle in the (row/column) heading to get
the subtotal properties and look at the properties window. There is a
"Position" property which is set to "After" by default. You can set it to
"Before", which gives you the effect you want.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"JeanSA" <JeanSA@.discussions.microsoft.com> wrote in message
news:C4A8ABDC-B776-4CE1-9B4B-1DDC70DD6B8A@.microsoft.com...
>I have successfully created a matrix consisting of payroll dates as column
> headers, with task types as my rows and hours/task/day the detail data.
> The
> columns total perfectly, but the totals only display to the RIGHT of all
> the
> data. We display our totals FIRST, then the detail data. Can I do this?
> total hrs day 1 day 2
> task 1 16 8 8|||Thank you. Wasn't sure what "Position" meant. I appreciate your quick
response.
"Robert Bruckner [MSFT]" wrote:
> Yes. Click on the little green triangle in the (row/column) heading to get
> the subtotal properties and look at the properties window. There is a
> "Position" property which is set to "After" by default. You can set it to
> "Before", which gives you the effect you want.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "JeanSA" <JeanSA@.discussions.microsoft.com> wrote in message
> news:C4A8ABDC-B776-4CE1-9B4B-1DDC70DD6B8A@.microsoft.com...
> >I have successfully created a matrix consisting of payroll dates as column
> > headers, with task types as my rows and hours/task/day the detail data.
> > The
> > columns total perfectly, but the totals only display to the RIGHT of all
> > the
> > data. We display our totals FIRST, then the detail data. Can I do this?
> > total hrs day 1 day 2
> > task 1 16 8 8
>
>

matrix total column

How do I get the 'Totals' column in a matrix to appear on the left, just
after the row headers instead of on the far right?In the very left hand column, insert a rectangle containing two text boxes
into each cell. This gives the impression of two columns, even though there
is only the one.
It's a work round but it does the job. It would be nice to see this
functionality appear out of the box.
"rocket salad" wrote:
> How do I get the 'Totals' column in a matrix to appear on the left, just
> after the row headers instead of on the far right?|||Here's a tip: Check what happens if you export this report to Excel. I got
into trouble with a report that looked good in RS and PDF, and threw a nice
little error message in my customized text box when doing something
similar...
Kaisa M. Lindahl Lervik
"rocket salad" <rocketsalad@.discussions.microsoft.com> wrote in message
news:005C4819-D8A9-4F59-B55F-87E41440DC6F@.microsoft.com...
> In the very left hand column, insert a rectangle containing two text boxes
> into each cell. This gives the impression of two columns, even though
> there
> is only the one.
> It's a work round but it does the job. It would be nice to see this
> functionality appear out of the box.
> "rocket salad" wrote:
>> How do I get the 'Totals' column in a matrix to appear on the left, just
>> after the row headers instead of on the far right?|||I'm actually quite surprised to find it works perfectly fine. What you say
makes sense, because the logic of having cells within cells sounds a bit
hokey. When I try it, though, it exports fine. I'm using RS2000 and Excel
2003, maybe you were having a problem with a different version of Excel?
"Kaisa M. Lindahl Lervik" wrote:
> Here's a tip: Check what happens if you export this report to Excel. I got
> into trouble with a report that looked good in RS and PDF, and threw a nice
> little error message in my customized text box when doing something
> similar...
> Kaisa M. Lindahl Lervik
> "rocket salad" <rocketsalad@.discussions.microsoft.com> wrote in message
> news:005C4819-D8A9-4F59-B55F-87E41440DC6F@.microsoft.com...
> > In the very left hand column, insert a rectangle containing two text boxes
> > into each cell. This gives the impression of two columns, even though
> > there
> > is only the one.
> >
> > It's a work round but it does the job. It would be nice to see this
> > functionality appear out of the box.
> >
> > "rocket salad" wrote:
> >
> >> How do I get the 'Totals' column in a matrix to appear on the left, just
> >> after the row headers instead of on the far right?
>
>|||Same version of Excel.
Nothing is better than it works for you. :)
Kaisa
"rocket salad" <rocketsalad@.discussions.microsoft.com> wrote in message
news:35CD264D-3EA7-4062-97A4-D9DE1457FB6B@.microsoft.com...
> I'm actually quite surprised to find it works perfectly fine. What you say
> makes sense, because the logic of having cells within cells sounds a bit
> hokey. When I try it, though, it exports fine. I'm using RS2000 and Excel
> 2003, maybe you were having a problem with a different version of Excel?
> "Kaisa M. Lindahl Lervik" wrote:
>> Here's a tip: Check what happens if you export this report to Excel. I
>> got
>> into trouble with a report that looked good in RS and PDF, and threw a
>> nice
>> little error message in my customized text box when doing something
>> similar...
>> Kaisa M. Lindahl Lervik
>> "rocket salad" <rocketsalad@.discussions.microsoft.com> wrote in message
>> news:005C4819-D8A9-4F59-B55F-87E41440DC6F@.microsoft.com...
>> > In the very left hand column, insert a rectangle containing two text
>> > boxes
>> > into each cell. This gives the impression of two columns, even though
>> > there
>> > is only the one.
>> >
>> > It's a work round but it does the job. It would be nice to see this
>> > functionality appear out of the box.
>> >
>> > "rocket salad" wrote:
>> >
>> >> How do I get the 'Totals' column in a matrix to appear on the left,
>> >> just
>> >> after the row headers instead of on the far right?
>>|||You can set this by a property called "position" as "Before" (default is
"After")
To do so, Click on the Green Triangle & property. There u can see position
as last property.
"rocket salad" wrote:
> How do I get the 'Totals' column in a matrix to appear on the left, just
> after the row headers instead of on the far right?

Matrix Row Headers After Data

I have a report that uses Analysis Services data in a matrix. The column
groups in the matrix are based on date, and the number of column groups is
variable based on the start time and end time entered as report parameters.
I'd like to display the row headers after the column groups, regardless of
the number of column groups. The "GroupsBeforeRowHeaders" property looks
like it will work, but it only takes an integer - I would like to set it to
"All" or something similar.
Is there any way to do this without writing code that will calculate the
number of column groups and then using that in an expression for the
"GroupsBeforeRowHeaders" property? I'd like to avoid doing this because the
start and end times may be weeks, months, or years, so calculating the
number of columns would be a pain.
Thanks for any help,
Sean Carpenter
ProMetrics Consulting, Inc.Did you try setting the integer to a very large value, e.g. 100000000
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sean Carpenter" <stcarpenter2005@.community.nospam> wrote in message
news:u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl...
> I have a report that uses Analysis Services data in a matrix. The column
> groups in the matrix are based on date, and the number of column groups is
> variable based on the start time and end time entered as report
parameters.
> I'd like to display the row headers after the column groups, regardless of
> the number of column groups. The "GroupsBeforeRowHeaders" property looks
> like it will work, but it only takes an integer - I would like to set it
to
> "All" or something similar.
> Is there any way to do this without writing code that will calculate the
> number of column groups and then using that in an expression for the
> "GroupsBeforeRowHeaders" property? I'd like to avoid doing this because
the
> start and end times may be weeks, months, or years, so calculating the
> number of columns would be a pain.
> Thanks for any help,
> Sean Carpenter
> ProMetrics Consulting, Inc.
>|||Yes. If I set it to anything larger than the actual number of column
groups, it doesn't appear to do anything - the headers stay to the left of
all of the column groups.
Sean Carpenter
ProMetrics Consulting, Inc.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:u7k3Tj%235EHA.1408@.TK2MSFTNGP10.phx.gbl...
> Did you try setting the integer to a very large value, e.g. 100000000
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Sean Carpenter" <stcarpenter2005@.community.nospam> wrote in message
> news:u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl...
>> I have a report that uses Analysis Services data in a matrix. The column
>> groups in the matrix are based on date, and the number of column groups
>> is
>> variable based on the start time and end time entered as report
> parameters.
>> I'd like to display the row headers after the column groups, regardless
>> of
>> the number of column groups. The "GroupsBeforeRowHeaders" property looks
>> like it will work, but it only takes an integer - I would like to set it
> to
>> "All" or something similar.
>> Is there any way to do this without writing code that will calculate the
>> number of column groups and then using that in an expression for the
>> "GroupsBeforeRowHeaders" property? I'd like to avoid doing this because
> the
>> start and end times may be weeks, months, or years, so calculating the
>> number of columns would be a pain.
>> Thanks for any help,
>> Sean Carpenter
>> ProMetrics Consulting, Inc.
>>
>|||I have the same thing and I did not set the group header number. It is set
to 0 and the Matrix Columns expand Right to left is selected. Thus all of my
columns appear to the left and then my rows appear to right.
Hope this is not to late to help, if it works for you.
"Sean Carpenter" wrote:
> Yes. If I set it to anything larger than the actual number of column
> groups, it doesn't appear to do anything - the headers stay to the left of
> all of the column groups.
> Sean Carpenter
> ProMetrics Consulting, Inc.
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:u7k3Tj%235EHA.1408@.TK2MSFTNGP10.phx.gbl...
> > Did you try setting the integer to a very large value, e.g. 100000000
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> > "Sean Carpenter" <stcarpenter2005@.community.nospam> wrote in message
> > news:u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl...
> >> I have a report that uses Analysis Services data in a matrix. The column
> >> groups in the matrix are based on date, and the number of column groups
> >> is
> >> variable based on the start time and end time entered as report
> > parameters.
> >> I'd like to display the row headers after the column groups, regardless
> >> of
> >> the number of column groups. The "GroupsBeforeRowHeaders" property looks
> >> like it will work, but it only takes an integer - I would like to set it
> > to
> >> "All" or something similar.
> >>
> >> Is there any way to do this without writing code that will calculate the
> >> number of column groups and then using that in an expression for the
> >> "GroupsBeforeRowHeaders" property? I'd like to avoid doing this because
> > the
> >> start and end times may be weeks, months, or years, so calculating the
> >> number of columns would be a pain.
> >>
> >> Thanks for any help,
> >> Sean Carpenter
> >> ProMetrics Consulting, Inc.
> >>
> >>
> >
> >
>
>|||I didn't know about that property of the matrix. I tried it and it works,
except that it reverses the order of all of the columns (which makes sense
considering what the property does). I can reverse the order of the columns
in the query result so that when the matrix reverses them again they display
correctly, but it would be nice to have a "clean" way of doing this. This
will definitely get me through the current report, though.
Sean Carpenter
ProMetrics Consulting, Inc.
"HBWAL" wrote:
> I have the same thing and I did not set the group header number. It is set
> to 0 and the Matrix Columns expand Right to left is selected. Thus all of my
> columns appear to the left and then my rows appear to right.
> Hope this is not to late to help, if it works for you.
> "Sean Carpenter" wrote:
> > Yes. If I set it to anything larger than the actual number of column
> > groups, it doesn't appear to do anything - the headers stay to the left of
> > all of the column groups.
> >
> > Sean Carpenter
> > ProMetrics Consulting, Inc.
> >
> > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> > news:u7k3Tj%235EHA.1408@.TK2MSFTNGP10.phx.gbl...
> > > Did you try setting the integer to a very large value, e.g. 100000000
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > >
> > > "Sean Carpenter" <stcarpenter2005@.community.nospam> wrote in message
> > > news:u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl...
> > >> I have a report that uses Analysis Services data in a matrix. The column
> > >> groups in the matrix are based on date, and the number of column groups
> > >> is
> > >> variable based on the start time and end time entered as report
> > > parameters.
> > >> I'd like to display the row headers after the column groups, regardless
> > >> of
> > >> the number of column groups. The "GroupsBeforeRowHeaders" property looks
> > >> like it will work, but it only takes an integer - I would like to set it
> > > to
> > >> "All" or something similar.
> > >>
> > >> Is there any way to do this without writing code that will calculate the
> > >> number of column groups and then using that in an expression for the
> > >> "GroupsBeforeRowHeaders" property? I'd like to avoid doing this because
> > > the
> > >> start and end times may be weeks, months, or years, so calculating the
> > >> number of columns would be a pain.
> > >>
> > >> Thanks for any help,
> > >> Sean Carpenter
> > >> ProMetrics Consulting, Inc.
> > >>
> > >>
> > >
> > >
> >
> >
> >|||Regarding the order - you should add a sort expression on the column
grouping of the matrix. The RS processing engine does not change any order
if there is no sorting applied in the report. You get the data in the order
returned by the data provider.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sean Carpenter" <SeanCarpenter@.discussions.microsoft.com> wrote in message
news:34267414-52D0-45ED-8C0F-14C174F5D1D8@.microsoft.com...
> I didn't know about that property of the matrix. I tried it and it works,
> except that it reverses the order of all of the columns (which makes sense
> considering what the property does). I can reverse the order of the
columns
> in the query result so that when the matrix reverses them again they
display
> correctly, but it would be nice to have a "clean" way of doing this. This
> will definitely get me through the current report, though.
> Sean Carpenter
> ProMetrics Consulting, Inc.
> "HBWAL" wrote:
> > I have the same thing and I did not set the group header number. It is
set
> > to 0 and the Matrix Columns expand Right to left is selected. Thus all
of my
> > columns appear to the left and then my rows appear to right.
> >
> > Hope this is not to late to help, if it works for you.
> >
> > "Sean Carpenter" wrote:
> >
> > > Yes. If I set it to anything larger than the actual number of column
> > > groups, it doesn't appear to do anything - the headers stay to the
left of
> > > all of the column groups.
> > >
> > > Sean Carpenter
> > > ProMetrics Consulting, Inc.
> > >
> > > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in
message
> > > news:u7k3Tj%235EHA.1408@.TK2MSFTNGP10.phx.gbl...
> > > > Did you try setting the integer to a very large value, e.g.
100000000
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > > rights.
> > > >
> > > > "Sean Carpenter" <stcarpenter2005@.community.nospam> wrote in message
> > > > news:u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl...
> > > >> I have a report that uses Analysis Services data in a matrix. The
column
> > > >> groups in the matrix are based on date, and the number of column
groups
> > > >> is
> > > >> variable based on the start time and end time entered as report
> > > > parameters.
> > > >> I'd like to display the row headers after the column groups,
regardless
> > > >> of
> > > >> the number of column groups. The "GroupsBeforeRowHeaders" property
looks
> > > >> like it will work, but it only takes an integer - I would like to
set it
> > > > to
> > > >> "All" or something similar.
> > > >>
> > > >> Is there any way to do this without writing code that will
calculate the
> > > >> number of column groups and then using that in an expression for
the
> > > >> "GroupsBeforeRowHeaders" property? I'd like to avoid doing this
because
> > > > the
> > > >> start and end times may be weeks, months, or years, so calculating
the
> > > >> number of columns would be a pain.
> > > >>
> > > >> Thanks for any help,
> > > >> Sean Carpenter
> > > >> ProMetrics Consulting, Inc.
> > > >>
> > > >>
> > > >
> > > >
> > >
> > >
> > >|||I understand that RS doesn't change the order - the problem is that when I
set the matrix to expand from right to left, this effectively changes the
order of the data. I can't sort in the matrix because the groups need to be
sorted correctly by date, by the column grouping is based on the date name
returned from Analysis Services (which doesn't always sort the same as the
actual date).
Either way, it turns out this doesn't help since when I export to Excel, the
row headers are still on the left of the data - it seems the excel export
ignores the "LayoutDirection" property of the matrix.
I guess I'll be stuck with calculating the number of column groups and
setting the "GroupsBeforeRowHeaders" property using an expression.
Sean Carpenter
ProMetrics Consulting, Inc.
"Robert Bruckner [MSFT]" wrote:
> Regarding the order - you should add a sort expression on the column
> grouping of the matrix. The RS processing engine does not change any order
> if there is no sorting applied in the report. You get the data in the order
> returned by the data provider.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Sean Carpenter" <SeanCarpenter@.discussions.microsoft.com> wrote in message
> news:34267414-52D0-45ED-8C0F-14C174F5D1D8@.microsoft.com...
> > I didn't know about that property of the matrix. I tried it and it works,
> > except that it reverses the order of all of the columns (which makes sense
> > considering what the property does). I can reverse the order of the
> columns
> > in the query result so that when the matrix reverses them again they
> display
> > correctly, but it would be nice to have a "clean" way of doing this. This
> > will definitely get me through the current report, though.
> >
> > Sean Carpenter
> > ProMetrics Consulting, Inc.
> >
> > "HBWAL" wrote:
> >
> > > I have the same thing and I did not set the group header number. It is
> set
> > > to 0 and the Matrix Columns expand Right to left is selected. Thus all
> of my
> > > columns appear to the left and then my rows appear to right.
> > >
> > > Hope this is not to late to help, if it works for you.
> > >
> > > "Sean Carpenter" wrote:
> > >
> > > > Yes. If I set it to anything larger than the actual number of column
> > > > groups, it doesn't appear to do anything - the headers stay to the
> left of
> > > > all of the column groups.
> > > >
> > > > Sean Carpenter
> > > > ProMetrics Consulting, Inc.
> > > >
> > > > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in
> message
> > > > news:u7k3Tj%235EHA.1408@.TK2MSFTNGP10.phx.gbl...
> > > > > Did you try setting the integer to a very large value, e.g.
> 100000000
> > > > >
> > > > > --
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > > > rights.
> > > > >
> > > > > "Sean Carpenter" <stcarpenter2005@.community.nospam> wrote in message
> > > > > news:u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl...
> > > > >> I have a report that uses Analysis Services data in a matrix. The
> column
> > > > >> groups in the matrix are based on date, and the number of column
> groups
> > > > >> is
> > > > >> variable based on the start time and end time entered as report
> > > > > parameters.
> > > > >> I'd like to display the row headers after the column groups,
> regardless
> > > > >> of
> > > > >> the number of column groups. The "GroupsBeforeRowHeaders" property
> looks
> > > > >> like it will work, but it only takes an integer - I would like to
> set it
> > > > > to
> > > > >> "All" or something similar.
> > > > >>
> > > > >> Is there any way to do this without writing code that will
> calculate the
> > > > >> number of column groups and then using that in an expression for
> the
> > > > >> "GroupsBeforeRowHeaders" property? I'd like to avoid doing this
> because
> > > > > the
> > > > >> start and end times may be weeks, months, or years, so calculating
> the
> > > > >> number of columns would be a pain.
> > > > >>
> > > > >> Thanks for any help,
> > > > >> Sean Carpenter
> > > > >> ProMetrics Consulting, Inc.
> > > > >>
> > > > >>
> > > > >
> > > > >
> > > >
> > > >
> > > >
>
>|||It looks like my solution from the previous post won't work. I wrote a
function in the Custom Code section of the report to return the correct
number of column groups based on the report parameters. When I try to set
the "GroupsBeforeRowHeaders" property to "=Code.ColumnCount()", it won't let
me since it requires an Int32 value for the property.
Does anyone have any ideas on this one? I'd like to have the row headers to
the right of the column groups and have it appear that way on Excel export as
well.
Thanks,
Sean Carpenter
ProMetrics Consulting, Inc.
"Robert Bruckner [MSFT]" wrote:
> Regarding the order - you should add a sort expression on the column
> grouping of the matrix. The RS processing engine does not change any order
> if there is no sorting applied in the report. You get the data in the order
> returned by the data provider.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Sean Carpenter" <SeanCarpenter@.discussions.microsoft.com> wrote in message
> news:34267414-52D0-45ED-8C0F-14C174F5D1D8@.microsoft.com...
> > I didn't know about that property of the matrix. I tried it and it works,
> > except that it reverses the order of all of the columns (which makes sense
> > considering what the property does). I can reverse the order of the
> columns
> > in the query result so that when the matrix reverses them again they
> display
> > correctly, but it would be nice to have a "clean" way of doing this. This
> > will definitely get me through the current report, though.
> >
> > Sean Carpenter
> > ProMetrics Consulting, Inc.
> >
> > "HBWAL" wrote:
> >
> > > I have the same thing and I did not set the group header number. It is
> set
> > > to 0 and the Matrix Columns expand Right to left is selected. Thus all
> of my
> > > columns appear to the left and then my rows appear to right.
> > >
> > > Hope this is not to late to help, if it works for you.
> > >
> > > "Sean Carpenter" wrote:
> > >
> > > > Yes. If I set it to anything larger than the actual number of column
> > > > groups, it doesn't appear to do anything - the headers stay to the
> left of
> > > > all of the column groups.
> > > >
> > > > Sean Carpenter
> > > > ProMetrics Consulting, Inc.
> > > >
> > > > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in
> message
> > > > news:u7k3Tj%235EHA.1408@.TK2MSFTNGP10.phx.gbl...
> > > > > Did you try setting the integer to a very large value, e.g.
> 100000000
> > > > >
> > > > > --
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > > > rights.
> > > > >
> > > > > "Sean Carpenter" <stcarpenter2005@.community.nospam> wrote in message
> > > > > news:u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl...
> > > > >> I have a report that uses Analysis Services data in a matrix. The
> column
> > > > >> groups in the matrix are based on date, and the number of column
> groups
> > > > >> is
> > > > >> variable based on the start time and end time entered as report
> > > > > parameters.
> > > > >> I'd like to display the row headers after the column groups,
> regardless
> > > > >> of
> > > > >> the number of column groups. The "GroupsBeforeRowHeaders" property
> looks
> > > > >> like it will work, but it only takes an integer - I would like to
> set it
> > > > > to
> > > > >> "All" or something similar.
> > > > >>
> > > > >> Is there any way to do this without writing code that will
> calculate the
> > > > >> number of column groups and then using that in an expression for
> the
> > > > >> "GroupsBeforeRowHeaders" property? I'd like to avoid doing this
> because
> > > > > the
> > > > >> start and end times may be weeks, months, or years, so calculating
> the
> > > > >> number of columns would be a pain.
> > > > >>
> > > > >> Thanks for any help,
> > > > >> Sean Carpenter
> > > > >> ProMetrics Consulting, Inc.
> > > > >>
> > > > >>
> > > > >
> > > > >
> > > >
> > > >
> > > >
>
>|||Hello Sean,
GroupsBeforeRowHeaders property is indeed an integer and you will need to
know how many instances you want to move before row headings.
The matrix LayoutDirection = RTL should help you to achieve what you want
and adding a sort expression in the report (the sorting will be done by our
processing component) should help you to sort them in the order you want.
Could you provide the report (created by CU) and a screenshot with the
desired result? You could send them to me at petery@.microsoft.com
Thanks & Regards,
Peter Yang
MCSE2000, MCSA, MCDBA
Microsoft Partner Online Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Matrix Row Headers After Data
| thread-index: AcTuES8Dac2k+nRYQjO7EsINx2zh4g==| X-WBNR-Posting-Host: 141.151.17.169
| From: "=?Utf-8?B?U2VhbiBDYXJwZW50ZXI=?="
<SeanCarpenter@.discussions.microsoft.com>
| References: <u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl>
<u7k3Tj#5EHA.1408@.TK2MSFTNGP10.phx.gbl>
<emm2uuE6EHA.3336@.TK2MSFTNGP11.phx.gbl>
<3F5F013D-5CBD-4D63-AB93-1FAE12CD78FC@.microsoft.com>
<34267414-52D0-45ED-8C0F-14C174F5D1D8@.microsoft.com>
<etWT1$g6EHA.992@.TK2MSFTNGP12.phx.gbl>
| Subject: Re: Matrix Row Headers After Data
| Date: Wed, 29 Dec 2004 17:45:04 -0800
| Lines: 113
| Message-ID: <1032A92D-A366-4E70-8A5C-9734EB226004@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:38404
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| It looks like my solution from the previous post won't work. I wrote a
| function in the Custom Code section of the report to return the correct
| number of column groups based on the report parameters. When I try to
set
| the "GroupsBeforeRowHeaders" property to "=Code.ColumnCount()", it won't
let
| me since it requires an Int32 value for the property.
|
| Does anyone have any ideas on this one? I'd like to have the row headers
to
| the right of the column groups and have it appear that way on Excel
export as
| well.
|
| Thanks,
| Sean Carpenter
| ProMetrics Consulting, Inc.
|
| "Robert Bruckner [MSFT]" wrote:
|
| > Regarding the order - you should add a sort expression on the column
| > grouping of the matrix. The RS processing engine does not change any
order
| > if there is no sorting applied in the report. You get the data in the
order
| > returned by the data provider.
| >
| > --
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >
| > "Sean Carpenter" <SeanCarpenter@.discussions.microsoft.com> wrote in
message
| > news:34267414-52D0-45ED-8C0F-14C174F5D1D8@.microsoft.com...
| > > I didn't know about that property of the matrix. I tried it and it
works,
| > > except that it reverses the order of all of the columns (which makes
sense
| > > considering what the property does). I can reverse the order of the
| > columns
| > > in the query result so that when the matrix reverses them again they
| > display
| > > correctly, but it would be nice to have a "clean" way of doing this.
This
| > > will definitely get me through the current report, though.
| > >
| > > Sean Carpenter
| > > ProMetrics Consulting, Inc.
| > >
| > > "HBWAL" wrote:
| > >
| > > > I have the same thing and I did not set the group header number.
It is
| > set
| > > > to 0 and the Matrix Columns expand Right to left is selected. Thus
all
| > of my
| > > > columns appear to the left and then my rows appear to right.
| > > >
| > > > Hope this is not to late to help, if it works for you.
| > > >
| > > > "Sean Carpenter" wrote:
| > > >
| > > > > Yes. If I set it to anything larger than the actual number of
column
| > > > > groups, it doesn't appear to do anything - the headers stay to the
| > left of
| > > > > all of the column groups.
| > > > >
| > > > > Sean Carpenter
| > > > > ProMetrics Consulting, Inc.
| > > > >
| > > > > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in
| > message
| > > > > news:u7k3Tj%235EHA.1408@.TK2MSFTNGP10.phx.gbl...
| > > > > > Did you try setting the integer to a very large value, e.g.
| > 100000000
| > > > > >
| > > > > > --
| > > > > > This posting is provided "AS IS" with no warranties, and
confers no
| > > > > > rights.
| > > > > >
| > > > > > "Sean Carpenter" <stcarpenter2005@.community.nospam> wrote in
message
| > > > > > news:u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl...
| > > > > >> I have a report that uses Analysis Services data in a matrix.
The
| > column
| > > > > >> groups in the matrix are based on date, and the number of
column
| > groups
| > > > > >> is
| > > > > >> variable based on the start time and end time entered as report
| > > > > > parameters.
| > > > > >> I'd like to display the row headers after the column groups,
| > regardless
| > > > > >> of
| > > > > >> the number of column groups. The "GroupsBeforeRowHeaders"
property
| > looks
| > > > > >> like it will work, but it only takes an integer - I would like
to
| > set it
| > > > > > to
| > > > > >> "All" or something similar.
| > > > > >>
| > > > > >> Is there any way to do this without writing code that will
| > calculate the
| > > > > >> number of column groups and then using that in an expression
for
| > the
| > > > > >> "GroupsBeforeRowHeaders" property? I'd like to avoid doing
this
| > because
| > > > > > the
| > > > > >> start and end times may be weeks, months, or years, so
calculating
| > the
| > > > > >> number of columns would be a pain.
| > > > > >>
| > > > > >> Thanks for any help,
| > > > > >> Sean Carpenter
| > > > > >> ProMetrics Consulting, Inc.
| > > > > >>
| > > > > >>
| > > > > >
| > > > > >
| > > > >
| > > > >
| > > > >
| >
| >
| >
||||Peter,
I have emailed you an example report that exhibits the problem I'm having.
Thanks for you help.
Sean Carpenter
ProMetrics Consulting, Inc.
"Peter Yang [MSFT]" wrote:
> Hello Sean,
> GroupsBeforeRowHeaders property is indeed an integer and you will need to
> know how many instances you want to move before row headings.
> The matrix LayoutDirection = RTL should help you to achieve what you want
> and adding a sort expression in the report (the sorting will be done by our
> processing component) should help you to sort them in the order you want.
> Could you provide the report (created by CU) and a screenshot with the
> desired result? You could send them to me at petery@.microsoft.com
> Thanks & Regards,
> Peter Yang
> MCSE2000, MCSA, MCDBA
> Microsoft Partner Online Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Matrix Row Headers After Data
> | thread-index: AcTuES8Dac2k+nRYQjO7EsINx2zh4g==> | X-WBNR-Posting-Host: 141.151.17.169
> | From: "=?Utf-8?B?U2VhbiBDYXJwZW50ZXI=?="
> <SeanCarpenter@.discussions.microsoft.com>
> | References: <u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl>
> <u7k3Tj#5EHA.1408@.TK2MSFTNGP10.phx.gbl>
> <emm2uuE6EHA.3336@.TK2MSFTNGP11.phx.gbl>
> <3F5F013D-5CBD-4D63-AB93-1FAE12CD78FC@.microsoft.com>
> <34267414-52D0-45ED-8C0F-14C174F5D1D8@.microsoft.com>
> <etWT1$g6EHA.992@.TK2MSFTNGP12.phx.gbl>
> | Subject: Re: Matrix Row Headers After Data
> | Date: Wed, 29 Dec 2004 17:45:04 -0800
> | Lines: 113
> | Message-ID: <1032A92D-A366-4E70-8A5C-9734EB226004@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:38404
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | It looks like my solution from the previous post won't work. I wrote a
> | function in the Custom Code section of the report to return the correct
> | number of column groups based on the report parameters. When I try to
> set
> | the "GroupsBeforeRowHeaders" property to "=Code.ColumnCount()", it won't
> let
> | me since it requires an Int32 value for the property.
> |
> | Does anyone have any ideas on this one? I'd like to have the row headers
> to
> | the right of the column groups and have it appear that way on Excel
> export as
> | well.
> |
> | Thanks,
> | Sean Carpenter
> | ProMetrics Consulting, Inc.
> |
> | "Robert Bruckner [MSFT]" wrote:
> |
> | > Regarding the order - you should add a sort expression on the column
> | > grouping of the matrix. The RS processing engine does not change any
> order
> | > if there is no sorting applied in the report. You get the data in the
> order
> | > returned by the data provider.
> | >
> | > --
> | > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> | >
> | >
> | >
> | > "Sean Carpenter" <SeanCarpenter@.discussions.microsoft.com> wrote in
> message
> | > news:34267414-52D0-45ED-8C0F-14C174F5D1D8@.microsoft.com...
> | > > I didn't know about that property of the matrix. I tried it and it
> works,
> | > > except that it reverses the order of all of the columns (which makes
> sense
> | > > considering what the property does). I can reverse the order of the
> | > columns
> | > > in the query result so that when the matrix reverses them again they
> | > display
> | > > correctly, but it would be nice to have a "clean" way of doing this.
> This
> | > > will definitely get me through the current report, though.
> | > >
> | > > Sean Carpenter
> | > > ProMetrics Consulting, Inc.
> | > >
> | > > "HBWAL" wrote:
> | > >
> | > > > I have the same thing and I did not set the group header number.
> It is
> | > set
> | > > > to 0 and the Matrix Columns expand Right to left is selected. Thus
> all
> | > of my
> | > > > columns appear to the left and then my rows appear to right.
> | > > >
> | > > > Hope this is not to late to help, if it works for you.
> | > > >
> | > > > "Sean Carpenter" wrote:
> | > > >
> | > > > > Yes. If I set it to anything larger than the actual number of
> column
> | > > > > groups, it doesn't appear to do anything - the headers stay to the
> | > left of
> | > > > > all of the column groups.
> | > > > >
> | > > > > Sean Carpenter
> | > > > > ProMetrics Consulting, Inc.
> | > > > >
> | > > > > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in
> | > message
> | > > > > news:u7k3Tj%235EHA.1408@.TK2MSFTNGP10.phx.gbl...
> | > > > > > Did you try setting the integer to a very large value, e.g.
> | > 100000000
> | > > > > >
> | > > > > > --
> | > > > > > This posting is provided "AS IS" with no warranties, and
> confers no
> | > > > > > rights.
> | > > > > >
> | > > > > > "Sean Carpenter" <stcarpenter2005@.community.nospam> wrote in
> message
> | > > > > > news:u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl...
> | > > > > >> I have a report that uses Analysis Services data in a matrix.
> The
> | > column
> | > > > > >> groups in the matrix are based on date, and the number of
> column
> | > groups
> | > > > > >> is
> | > > > > >> variable based on the start time and end time entered as report
> | > > > > > parameters.
> | > > > > >> I'd like to display the row headers after the column groups,
> | > regardless
> | > > > > >> of
> | > > > > >> the number of column groups. The "GroupsBeforeRowHeaders"
> property
> | > looks
> | > > > > >> like it will work, but it only takes an integer - I would like
> to
> | > set it
> | > > > > > to
> | > > > > >> "All" or something similar.
> | > > > > >>
> | > > > > >> Is there any way to do this without writing code that will
> | > calculate the
> | > > > > >> number of column groups and then using that in an expression
> for
> | > the
> | > > > > >> "GroupsBeforeRowHeaders" property? I'd like to avoid doing
> this
> | > because
> | > > > > > the
> | > > > > >> start and end times may be weeks, months, or years, so
> calculating
> | > the
> | > > > > >> number of columns would be a pain.
> | > > > > >>
> | > > > > >> Thanks for any help,
> | > > > > >> Sean Carpenter
> | > > > > >> ProMetrics Consulting, Inc.
> | > > > > >>
> | > > > > >>
> | > > > > >
> | > > > > >
> | > > > >
> | > > > >
> | > > > >
> | >
> | >
> | >
> |
>|||Hello Sean,
After consulting the proudct team, there are no plans to change
GroupsBeforeRowHeaders to be an expression.
One possible workaround is to add an outer column grouping with a
GroupExpression like "=1" (so you will have only on column), set its height
to zero and set GroupsBeforeRowHeaders to 1.
Hope this is helpful.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Matrix Row Headers After Data
| thread-index: AcTuiwA5dD+6t9c8QheMRd1ZJCE6Wg==| X-WBNR-Posting-Host: 65.126.12.173
| From: "=?Utf-8?B?U2VhbiBDYXJwZW50ZXI=?="
<SeanCarpenter@.discussions.microsoft.com>
| References: <u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl>
<u7k3Tj#5EHA.1408@.TK2MSFTNGP10.phx.gbl>
<emm2uuE6EHA.3336@.TK2MSFTNGP11.phx.gbl>
<3F5F013D-5CBD-4D63-AB93-1FAE12CD78FC@.microsoft.com>
<34267414-52D0-45ED-8C0F-14C174F5D1D8@.microsoft.com>
<etWT1$g6EHA.992@.TK2MSFTNGP12.phx.gbl>
<1032A92D-A366-4E70-8A5C-9734EB226004@.microsoft.com>
<v9rQBQi7EHA.2768@.cpmsftngxa10.phx.gbl>
| Subject: Re: Matrix Row Headers After Data
| Date: Thu, 30 Dec 2004 08:17:04 -0800
| Lines: 208
| Message-ID: <B598246D-BBB6-4269-A943-F082FC51E5DD@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:38437
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Peter,
| I have emailed you an example report that exhibits the problem I'm having.
|
| Thanks for you help.
|
| Sean Carpenter
| ProMetrics Consulting, Inc.
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello Sean,
| >
| > GroupsBeforeRowHeaders property is indeed an integer and you will need
to
| > know how many instances you want to move before row headings.
| >
| > The matrix LayoutDirection = RTL should help you to achieve what you
want
| > and adding a sort expression in the report (the sorting will be done by
our
| > processing component) should help you to sort them in the order you
want.
| >
| > Could you provide the report (created by CU) and a screenshot with the
| > desired result? You could send them to me at petery@.microsoft.com
| >
| > Thanks & Regards,
| >
| > Peter Yang
| > MCSE2000, MCSA, MCDBA
| > Microsoft Partner Online Support
| >
| > Get Secure! - www.microsoft.com/security
| >
| > =====================================================| > When responding to posts, please "Reply to Group" via
| > your newsreader so that others may learn and benefit
| > from your issue.
| > =====================================================| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| > --
| > | Thread-Topic: Matrix Row Headers After Data
| > | thread-index: AcTuES8Dac2k+nRYQjO7EsINx2zh4g==| > | X-WBNR-Posting-Host: 141.151.17.169
| > | From: "=?Utf-8?B?U2VhbiBDYXJwZW50ZXI=?="
| > <SeanCarpenter@.discussions.microsoft.com>
| > | References: <u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl>
| > <u7k3Tj#5EHA.1408@.TK2MSFTNGP10.phx.gbl>
| > <emm2uuE6EHA.3336@.TK2MSFTNGP11.phx.gbl>
| > <3F5F013D-5CBD-4D63-AB93-1FAE12CD78FC@.microsoft.com>
| > <34267414-52D0-45ED-8C0F-14C174F5D1D8@.microsoft.com>
| > <etWT1$g6EHA.992@.TK2MSFTNGP12.phx.gbl>
| > | Subject: Re: Matrix Row Headers After Data
| > | Date: Wed, 29 Dec 2004 17:45:04 -0800
| > | Lines: 113
| > | Message-ID: <1032A92D-A366-4E70-8A5C-9734EB226004@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:38404
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | It looks like my solution from the previous post won't work. I wrote
a
| > | function in the Custom Code section of the report to return the
correct
| > | number of column groups based on the report parameters. When I try
to
| > set
| > | the "GroupsBeforeRowHeaders" property to "=Code.ColumnCount()", it
won't
| > let
| > | me since it requires an Int32 value for the property.
| > |
| > | Does anyone have any ideas on this one? I'd like to have the row
headers
| > to
| > | the right of the column groups and have it appear that way on Excel
| > export as
| > | well.
| > |
| > | Thanks,
| > | Sean Carpenter
| > | ProMetrics Consulting, Inc.
| > |
| > | "Robert Bruckner [MSFT]" wrote:
| > |
| > | > Regarding the order - you should add a sort expression on the column
| > | > grouping of the matrix. The RS processing engine does not change
any
| > order
| > | > if there is no sorting applied in the report. You get the data in
the
| > order
| > | > returned by the data provider.
| > | >
| > | > --
| > | > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| > | >
| > | >
| > | >
| > | > "Sean Carpenter" <SeanCarpenter@.discussions.microsoft.com> wrote in
| > message
| > | > news:34267414-52D0-45ED-8C0F-14C174F5D1D8@.microsoft.com...
| > | > > I didn't know about that property of the matrix. I tried it and
it
| > works,
| > | > > except that it reverses the order of all of the columns (which
makes
| > sense
| > | > > considering what the property does). I can reverse the order of
the
| > | > columns
| > | > > in the query result so that when the matrix reverses them again
they
| > | > display
| > | > > correctly, but it would be nice to have a "clean" way of doing
this.
| > This
| > | > > will definitely get me through the current report, though.
| > | > >
| > | > > Sean Carpenter
| > | > > ProMetrics Consulting, Inc.
| > | > >
| > | > > "HBWAL" wrote:
| > | > >
| > | > > > I have the same thing and I did not set the group header
number.
| > It is
| > | > set
| > | > > > to 0 and the Matrix Columns expand Right to left is selected.
Thus
| > all
| > | > of my
| > | > > > columns appear to the left and then my rows appear to right.
| > | > > >
| > | > > > Hope this is not to late to help, if it works for you.
| > | > > >
| > | > > > "Sean Carpenter" wrote:
| > | > > >
| > | > > > > Yes. If I set it to anything larger than the actual number
of
| > column
| > | > > > > groups, it doesn't appear to do anything - the headers stay
to the
| > | > left of
| > | > > > > all of the column groups.
| > | > > > >
| > | > > > > Sean Carpenter
| > | > > > > ProMetrics Consulting, Inc.
| > | > > > >
| > | > > > > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote
in
| > | > message
| > | > > > > news:u7k3Tj%235EHA.1408@.TK2MSFTNGP10.phx.gbl...
| > | > > > > > Did you try setting the integer to a very large value, e.g.
| > | > 100000000
| > | > > > > >
| > | > > > > > --
| > | > > > > > This posting is provided "AS IS" with no warranties, and
| > confers no
| > | > > > > > rights.
| > | > > > > >
| > | > > > > > "Sean Carpenter" <stcarpenter2005@.community.nospam> wrote
in
| > message
| > | > > > > > news:u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl...
| > | > > > > >> I have a report that uses Analysis Services data in a
matrix.
| > The
| > | > column
| > | > > > > >> groups in the matrix are based on date, and the number of
| > column
| > | > groups
| > | > > > > >> is
| > | > > > > >> variable based on the start time and end time entered as
report
| > | > > > > > parameters.
| > | > > > > >> I'd like to display the row headers after the column
groups,
| > | > regardless
| > | > > > > >> of
| > | > > > > >> the number of column groups. The "GroupsBeforeRowHeaders"
| > property
| > | > looks
| > | > > > > >> like it will work, but it only takes an integer - I would
like
| > to
| > | > set it
| > | > > > > > to
| > | > > > > >> "All" or something similar.
| > | > > > > >>
| > | > > > > >> Is there any way to do this without writing code that will
| > | > calculate the
| > | > > > > >> number of column groups and then using that in an
expression
| > for
| > | > the
| > | > > > > >> "GroupsBeforeRowHeaders" property? I'd like to avoid
doing
| > this
| > | > because
| > | > > > > > the
| > | > > > > >> start and end times may be weeks, months, or years, so
| > calculating
| > | > the
| > | > > > > >> number of columns would be a pain.
| > | > > > > >>
| > | > > > > >> Thanks for any help,
| > | > > > > >> Sean Carpenter
| > | > > > > >> ProMetrics Consulting, Inc.
| > | > > > > >>
| > | > > > > >>
| > | > > > > >
| > | > > > > >
| > | > > > >
| > | > > > >
| > | > > > >
| > | >
| > | >
| > | >
| > |
| >
| >
||||I guess the bigger problem for me right now is that the Excel export ignores
the "LayoutDirection" property of the matrix. Is it possible to get this
fixed as a bug?
My overall problem (which is displaying row headers to the right of the
columns) still exists. Does anyone have any ideas? The whole idea of the
matrix is to have a variable number of columns - if I knew how many columns I
had I could use a table instead.
Sean Carpenter
ProMetrics Consulting, Inc.
"Peter Yang [MSFT]" wrote:
> Hello Sean,
> After consulting the proudct team, there are no plans to change
> GroupsBeforeRowHeaders to be an expression.
> One possible workaround is to add an outer column grouping with a
> GroupExpression like "=1" (so you will have only on column), set its height
> to zero and set GroupsBeforeRowHeaders to 1.
> Hope this is helpful.
> Thanks & Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Matrix Row Headers After Data
> | thread-index: AcTuiwA5dD+6t9c8QheMRd1ZJCE6Wg==> | X-WBNR-Posting-Host: 65.126.12.173
> | From: "=?Utf-8?B?U2VhbiBDYXJwZW50ZXI=?="
> <SeanCarpenter@.discussions.microsoft.com>
> | References: <u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl>
> <u7k3Tj#5EHA.1408@.TK2MSFTNGP10.phx.gbl>
> <emm2uuE6EHA.3336@.TK2MSFTNGP11.phx.gbl>
> <3F5F013D-5CBD-4D63-AB93-1FAE12CD78FC@.microsoft.com>
> <34267414-52D0-45ED-8C0F-14C174F5D1D8@.microsoft.com>
> <etWT1$g6EHA.992@.TK2MSFTNGP12.phx.gbl>
> <1032A92D-A366-4E70-8A5C-9734EB226004@.microsoft.com>
> <v9rQBQi7EHA.2768@.cpmsftngxa10.phx.gbl>
> | Subject: Re: Matrix Row Headers After Data
> | Date: Thu, 30 Dec 2004 08:17:04 -0800
> | Lines: 208
> | Message-ID: <B598246D-BBB6-4269-A943-F082FC51E5DD@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:38437
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Peter,
> | I have emailed you an example report that exhibits the problem I'm having.
> |
> | Thanks for you help.
> |
> | Sean Carpenter
> | ProMetrics Consulting, Inc.
> |
> | "Peter Yang [MSFT]" wrote:
> |
> | > Hello Sean,
> | >
> | > GroupsBeforeRowHeaders property is indeed an integer and you will need
> to
> | > know how many instances you want to move before row headings.
> | >
> | > The matrix LayoutDirection = RTL should help you to achieve what you
> want
> | > and adding a sort expression in the report (the sorting will be done by
> our
> | > processing component) should help you to sort them in the order you
> want.
> | >
> | > Could you provide the report (created by CU) and a screenshot with the
> | > desired result? You could send them to me at petery@.microsoft.com
> | >
> | > Thanks & Regards,
> | >
> | > Peter Yang
> | > MCSE2000, MCSA, MCDBA
> | > Microsoft Partner Online Support
> | >
> | > Get Secure! - www.microsoft.com/security
> | >
> | > =====================================================> | > When responding to posts, please "Reply to Group" via
> | > your newsreader so that others may learn and benefit
> | > from your issue.
> | > =====================================================> | > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> | >
> | >
> | > --
> | > | Thread-Topic: Matrix Row Headers After Data
> | > | thread-index: AcTuES8Dac2k+nRYQjO7EsINx2zh4g==> | > | X-WBNR-Posting-Host: 141.151.17.169
> | > | From: "=?Utf-8?B?U2VhbiBDYXJwZW50ZXI=?="
> | > <SeanCarpenter@.discussions.microsoft.com>
> | > | References: <u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl>
> | > <u7k3Tj#5EHA.1408@.TK2MSFTNGP10.phx.gbl>
> | > <emm2uuE6EHA.3336@.TK2MSFTNGP11.phx.gbl>
> | > <3F5F013D-5CBD-4D63-AB93-1FAE12CD78FC@.microsoft.com>
> | > <34267414-52D0-45ED-8C0F-14C174F5D1D8@.microsoft.com>
> | > <etWT1$g6EHA.992@.TK2MSFTNGP12.phx.gbl>
> | > | Subject: Re: Matrix Row Headers After Data
> | > | Date: Wed, 29 Dec 2004 17:45:04 -0800
> | > | Lines: 113
> | > | Message-ID: <1032A92D-A366-4E70-8A5C-9734EB226004@.microsoft.com>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:38404
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | It looks like my solution from the previous post won't work. I wrote
> a
> | > | function in the Custom Code section of the report to return the
> correct
> | > | number of column groups based on the report parameters. When I try
> to
> | > set
> | > | the "GroupsBeforeRowHeaders" property to "=Code.ColumnCount()", it
> won't
> | > let
> | > | me since it requires an Int32 value for the property.
> | > |
> | > | Does anyone have any ideas on this one? I'd like to have the row
> headers
> | > to
> | > | the right of the column groups and have it appear that way on Excel
> | > export as
> | > | well.
> | > |
> | > | Thanks,
> | > | Sean Carpenter
> | > | ProMetrics Consulting, Inc.
> | > |
> | > | "Robert Bruckner [MSFT]" wrote:
> | > |
> | > | > Regarding the order - you should add a sort expression on the column
> | > | > grouping of the matrix. The RS processing engine does not change
> any
> | > order
> | > | > if there is no sorting applied in the report. You get the data in
> the
> | > order
> | > | > returned by the data provider.
> | > | >
> | > | > --
> | > | > This posting is provided "AS IS" with no warranties, and confers no
> | > rights.
> | > | >
> | > | >
> | > | >
> | > | > "Sean Carpenter" <SeanCarpenter@.discussions.microsoft.com> wrote in
> | > message
> | > | > news:34267414-52D0-45ED-8C0F-14C174F5D1D8@.microsoft.com...
> | > | > > I didn't know about that property of the matrix. I tried it and
> it
> | > works,
> | > | > > except that it reverses the order of all of the columns (which
> makes
> | > sense
> | > | > > considering what the property does). I can reverse the order of
> the
> | > | > columns
> | > | > > in the query result so that when the matrix reverses them again
> they
> | > | > display
> | > | > > correctly, but it would be nice to have a "clean" way of doing
> this.
> | > This
> | > | > > will definitely get me through the current report, though.
> | > | > >
> | > | > > Sean Carpenter
> | > | > > ProMetrics Consulting, Inc.
> | > | > >
> | > | > > "HBWAL" wrote:
> | > | > >
> | > | > > > I have the same thing and I did not set the group header
> number.
> | > It is
> | > | > set
> | > | > > > to 0 and the Matrix Columns expand Right to left is selected.
> Thus
> | > all
> | > | > of my
> | > | > > > columns appear to the left and then my rows appear to right.
> | > | > > >
> | > | > > > Hope this is not to late to help, if it works for you.
> | > | > > >
> | > | > > > "Sean Carpenter" wrote:
> | > | > > >
> | > | > > > > Yes. If I set it to anything larger than the actual number
> of
> | > column
> | > | > > > > groups, it doesn't appear to do anything - the headers stay
> to the
> | > | > left of
> | > | > > > > all of the column groups.
> | > | > > > >
> | > | > > > > Sean Carpenter
> | > | > > > > ProMetrics Consulting, Inc.
> | > | > > > >
> | > | > > > > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote
> in
> | > | > message
> | > | > > > > news:u7k3Tj%235EHA.1408@.TK2MSFTNGP10.phx.gbl...
> | > | > > > > > Did you try setting the integer to a very large value, e.g.
> | > | > 100000000
> | > | > > > > >
> | > | > > > > > --
> | > | > > > > > This posting is provided "AS IS" with no warranties, and
> | > confers no
> | > | > > > > > rights.
> | > | > > > > >
> | > | > > > > > "Sean Carpenter" <stcarpenter2005@.community.nospam> wrote
> in
> | > message
> | > | > > > > > news:u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl...
> | > | > > > > >> I have a report that uses Analysis Services data in a
> matrix.
> | > The
> | > | > column
> | > | > > > > >> groups in the matrix are based on date, and the number of
> | > column
> | > | > groups
> | > | > > > > >> is
> | > | > > > > >> variable based on the start time and end time entered as
> report
> | > | > > > > > parameters.
> | > | > > > > >> I'd like to display the row headers after the column
> groups,
> | > | > regardless
> | > | > > > > >> of
> | > | > > > > >> the number of column groups. The "GroupsBeforeRowHeaders"
> | > property
> | > | > looks
> | > | > > > > >> like it will work, but it only takes an integer - I would
> like
> | > to
> | > | > set it
> | > | > > > > > to
> | > | > > > > >> "All" or something similar.
> | > | > > > > >>
> | > | > > > > >> Is there any way to do this without writing code that will
> | > | > calculate the
> | > | > > > > >> number of column groups and then using that in an
> expression
> | > for
> | > | > the
> | > | > > > > >> "GroupsBeforeRowHeaders" property? I'd like to avoid
> doing
> | > this
> | > | > because
> | > | > > > > > the
> | > | > > > > >> start and end times may be weeks, months, or years, so
> | > calculating
> | > | > the
> | > | > > > > >> number of columns would be a pain.
> | > | > > > > >>
> | > | > > > > >> Thanks for any help,
> | > | > > > > >> Sean Carpenter
> | > | > > > > >> ProMetrics Consulting, Inc.
> | > | > > > > >>
> | > | > > > > >>
> | > | > > > > >
> | > | > > > > >
> | > | > > > >
> | > | > > > >
> | > | > > > >
> | > | >
> | > | >
> | > | >
> | > |
> | >
> | >
> |
>|||Hello Sean,
I'd like to know if you have try the workaround as I suggested on the
sample report you send to me.
Set outer column grouping with a GroupExpression like "=1"
1). Change the dataset query to: (remove the sorting function)
SELECT { Measures.[Unit Sales] } on columns,
NON EMPTY CROSSJOIN({ Store.[Store State].Members },
Time.[1997].[Q1].[1]:Time.[1997].[Q4].[12] ) on rows
from Sales
2). Right click the Matrix up-right corner->Properties
3). On Group tab, select a Column group, click Add to add a new column
group. Name it Columngroup2
4). On the General tab, type "=1" (without quotos) in Expression textbox
under "Group on"
5). Move it to the first one in the column group.
6). On General tab of Matrix property dialog, select "Left to right"
7). Select "1" under Groups before row headers.
8). Right click cell with "=1" in matrix->Properties->Advanced->Visibility,
select Hidden.
9). Preview the report, you shall see the proper sequece of rows and row
headers
10). Deploy and export the report to excel, the sequence is also correct.
Thus, we need not set LayoutDirection from "right to left". You can sort it
as you want in dataset query and it will properly shown in the report.
Because there is a hidden column group with only 1 column, you can always
set "Groups before row headers" to 1 no matter how many real column in the
secondary column group.
Hope this is helpful.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security|||Peter -
I'm sorry - when I first read your reply with the workaround, I misread
adding the hidden column group as adding a hidden row group and didn't see
how it would work. This workaround did work for me and my report now works
the way I need it to.
Thanks for your help,
Sean Carpenter
ProMetrics Consulting, Inc.
"Peter Yang [MSFT]" wrote:
> Hello Sean,
> I'd like to know if you have try the workaround as I suggested on the
> sample report you send to me.
> Set outer column grouping with a GroupExpression like "=1"
> 1). Change the dataset query to: (remove the sorting function)
> SELECT { Measures.[Unit Sales] } on columns,
> NON EMPTY CROSSJOIN({ Store.[Store State].Members },
> Time.[1997].[Q1].[1]:Time.[1997].[Q4].[12] ) on rows
> from Sales
> 2). Right click the Matrix up-right corner->Properties
> 3). On Group tab, select a Column group, click Add to add a new column
> group. Name it Columngroup2
> 4). On the General tab, type "=1" (without quotos) in Expression textbox
> under "Group on"
> 5). Move it to the first one in the column group.
> 6). On General tab of Matrix property dialog, select "Left to right"
> 7). Select "1" under Groups before row headers.
> 8). Right click cell with "=1" in matrix->Properties->Advanced->Visibility,
> select Hidden.
> 9). Preview the report, you shall see the proper sequece of rows and row
> headers
> 10). Deploy and export the report to excel, the sequence is also correct.
> Thus, we need not set LayoutDirection from "right to left". You can sort it
> as you want in dataset query and it will properly shown in the report.
> Because there is a hidden column group with only 1 column, you can always
> set "Groups before row headers" to 1 no matter how many real column in the
> secondary column group.
> Hope this is helpful.
> Thanks & Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
>|||Hello Sean,
Glad to hear this work for you. Have a great day!
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Matrix Row Headers After Data
| thread-index: AcTz8/os9oJcCNQXSAetcHm6AQwaQQ==| X-WBNR-Posting-Host: 65.126.12.173
| From: "=?Utf-8?B?U2VhbiBDYXJwZW50ZXI=?="
<SeanCarpenter@.discussions.microsoft.com>
| References: <u2lwLU55EHA.1632@.tk2msftngp13.phx.gbl>
<u7k3Tj#5EHA.1408@.TK2MSFTNGP10.phx.gbl>
<emm2uuE6EHA.3336@.TK2MSFTNGP11.phx.gbl>
<3F5F013D-5CBD-4D63-AB93-1FAE12CD78FC@.microsoft.com>
<34267414-52D0-45ED-8C0F-14C174F5D1D8@.microsoft.com>
<etWT1$g6EHA.992@.TK2MSFTNGP12.phx.gbl>
<1032A92D-A366-4E70-8A5C-9734EB226004@.microsoft.com>
<v9rQBQi7EHA.2768@.cpmsftngxa10.phx.gbl>
<B598246D-BBB6-4269-A943-F082FC51E5DD@.microsoft.com>
<kBQgVJy8EHA.3520@.cpmsftngxa10.phx.gbl>
<1ED5A573-D4EE-43A6-B0F9-E9389D41DBC1@.microsoft.com>
<vRavHH78EHA.3520@.cpmsftngxa10.phx.gbl>
| Subject: Re: Matrix Row Headers After Data
| Date: Thu, 6 Jan 2005 05:31:07 -0800
| Lines: 65
| Message-ID: <36BE3E3D-63BE-45EE-9A5E-2737921B3644@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:38820
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Peter -
| I'm sorry - when I first read your reply with the workaround, I misread
| adding the hidden column group as adding a hidden row group and didn't
see
| how it would work. This workaround did work for me and my report now
works
| the way I need it to.
|
| Thanks for your help,
| Sean Carpenter
| ProMetrics Consulting, Inc.
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello Sean,
| >
| > I'd like to know if you have try the workaround as I suggested on the
| > sample report you send to me.
| >
| > Set outer column grouping with a GroupExpression like "=1"
| >
| > 1). Change the dataset query to: (remove the sorting function)
| >
| > SELECT { Measures.[Unit Sales] } on columns,
| > NON EMPTY CROSSJOIN({ Store.[Store State].Members },
| > Time.[1997].[Q1].[1]:Time.[1997].[Q4].[12] ) on rows
| > from Sales
| >
| > 2). Right click the Matrix up-right corner->Properties
| >
| > 3). On Group tab, select a Column group, click Add to add a new column
| > group. Name it Columngroup2
| >
| > 4). On the General tab, type "=1" (without quotos) in Expression
textbox
| > under "Group on"
| >
| > 5). Move it to the first one in the column group.
| >
| > 6). On General tab of Matrix property dialog, select "Left to right"
| >
| > 7). Select "1" under Groups before row headers.
| >
| > 8). Right click cell with "=1" in
matrix->Properties->Advanced->Visibility,
| > select Hidden.
| >
| > 9). Preview the report, you shall see the proper sequece of rows and
row
| > headers
| >
| > 10). Deploy and export the report to excel, the sequence is also
correct.
| >
| > Thus, we need not set LayoutDirection from "right to left". You can
sort it
| > as you want in dataset query and it will properly shown in the report.
| > Because there is a hidden column group with only 1 column, you can
always
| > set "Groups before row headers" to 1 no matter how many real column in
the
| > secondary column group.
| >
| > Hope this is helpful.
| >
| > Thanks & Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > Get Secure! - www.microsoft.com/security
| >
| >
|

matrix row header

In RS 2000, how do you place headers on the columns in the row section of a
matrix?I've added a rectangle to the header section in a matrix, and then placed
individual textboxes inside the rectangle.
At first I used a table instead of rectangles and textboxes, but this gave
me an error message when exporting to Excel. The rectangle + textboxes
should be safe, though. (I've had no complaints. :) )
Kaisa M. Lindahl Lervik
"Rob K" <RobK@.discussions.microsoft.com> wrote in message
news:9B0EA510-629F-4EF7-87B3-DF6F990897DE@.microsoft.com...
> In RS 2000, how do you place headers on the columns in the row section of
> a
> matrix?|||Thanks. This solution works.
"Kaisa M. Lindahl Lervik" wrote:
> I've added a rectangle to the header section in a matrix, and then placed
> individual textboxes inside the rectangle.
> At first I used a table instead of rectangles and textboxes, but this gave
> me an error message when exporting to Excel. The rectangle + textboxes
> should be safe, though. (I've had no complaints. :) )
> Kaisa M. Lindahl Lervik
> "Rob K" <RobK@.discussions.microsoft.com> wrote in message
> news:9B0EA510-629F-4EF7-87B3-DF6F990897DE@.microsoft.com...
> > In RS 2000, how do you place headers on the columns in the row section of
> > a
> > matrix?
>
>|||However ,if you are exporting to an excel this report you may face
problem with row merging and takind time to open the file when it has
huge data.
make sure that you aligned them perfectly to the grid
you can also type in the textbox without rectangle and textboxes on the
space,but you cant have borders and formattings
Thank you
Raj Deep.A
Rob K wrote:
> Thanks. This solution works.
> "Kaisa M. Lindahl Lervik" wrote:
> > I've added a rectangle to the header section in a matrix, and then placed
> > individual textboxes inside the rectangle.
> > At first I used a table instead of rectangles and textboxes, but this gave
> > me an error message when exporting to Excel. The rectangle + textboxes
> > should be safe, though. (I've had no complaints. :) )
> >
> > Kaisa M. Lindahl Lervik
> > "Rob K" <RobK@.discussions.microsoft.com> wrote in message
> > news:9B0EA510-629F-4EF7-87B3-DF6F990897DE@.microsoft.com...
> > > In RS 2000, how do you place headers on the columns in the row section of
> > > a
> > > matrix?
> >
> >
> >

Matrix problems:any help needed urgent

Hi,
Im breaking my head trying to use a matrix...... :((
My first problem in having column headers for the static columns in the
matrix,
i solved it by using a table within the corner tag in the matrix,thanks to
one of the posts here...
but when i export it to excel it throws a message
Data Regions within table/matrix cells are ignored.
what im missing here...
Im displaying a date in the format
dd-MMM ddd
But when exported to excel it shows ####
Please any1 help me out...
Thanks,Last thing first:
##### for date: I think you are getting date correctly ,just increase the
width of date column in excel after you export and see ...
Matrix: For Static column add another row of columns under the column
grouping and put your Header text there..
"CCP" wrote:
> Hi,
> Im breaking my head trying to use a matrix...... :((
> My first problem in having column headers for the static columns in the
> matrix,
> i solved it by using a table within the corner tag in the matrix,thanks to
> one of the posts here...
> but when i export it to excel it throws a message
> Data Regions within table/matrix cells are ignored.
> what im missing here...
> Im displaying a date in the format
> dd-MMM ddd
> But when exported to excel it shows ####
> Please any1 help me out...
> Thanks,

Matrix Columns on opposite sides

How do I put a group's row header at the right of the matrix and the column
headers at the bottom?
Many thanks
ScottHello Scott,
Thank you for your posting!
Based on my experience, you could not move the row header to the right of
the matrix and the column header to the bottom.
I would like to know why you want to do this. Since the row number and
column number of the matrix are dynamic, the width of the matrix may be
very long that you will need to scroll the screen to see the row header and
the column header.
Also, if you want to send this feedback to the Product team, please visit
the following website:
http://connect.microsoft.com/SQLServer/
Thank you for your understanding!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
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.)|||Hello Scott,
How is everythin going? If you have any question, please feel free to let
me know.
Sincerely,
Wei Lu
Microsoft Online Community Support|||I had a group (column) in a Matrix control that an executive wanted to see
one of the data elements on the right and the left of the data. Also, I
have to put "compound" aggregates into a matrix. So, to do the
calculations(IE, a total and percent of total) I have to add another matrix
control as a "grand total".
I tried to make the second matrix control look like it was "attached" as a
total to the original Matrix control. If I put the second control close to
the first control then the second control would be in the middle of the
first Matrix control. I wanted to place the header on the bottom so I
could have the control adjacent to each other.
Does this make any sense?
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:vc2H726tGHA.1992@.TK2MSFTNGXA01.phx.gbl...
> Hello Scott,
> How is everythin going? If you have any question, please feel free to let
> me know.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
>|||Hello Scott,
Thank you for the reply.
Unfortunately, the Matrix control was limited. As for the total value, I
think you could add some Calculation field in the dataset to complete this
function.
Hope the following url will be helpful!
Working with Data in Reporting Services
http://msdn2.microsoft.com/en-us/library/ms160324.aspx
Sincerely,
Wei Lu
Microsoft Online Community Support|||Hello Scott,
Is my response make sense to you? If you have any question, please feel
free to let
me know.
Sincerely,
Wei Lu
Microsoft Online Community Support

Matrix - Row Headers

does anyone know how to add row headers? I have a matrix with a row composed
of 5 groups, but I'm not able to add headers to each group because the header
cells are merged into one.
Also, is there a way to move selective row groups around? i.e. I would like
to move row group 2 and 4 to the end of the column grouping and leave 1,3 and
5 in front.
Any suggestions?I haven't been able to find a way to split that merged cell above the row
headers in a matrix. I have asked this group a couple of times, but didn't
get a response.
I need to do it because I want titles above the row group headers in a
matrix, and I can't insert white space to separate the headers in the merged
cell. (see Ponnurangam's post earlier today).
This is the one issue my users are not happy about. It is confusing when
there are several row headers in a matrix with no titles above them.
-Bill
"Nikki" <Nikki@.discussions.microsoft.com> wrote in message
news:BB861543-CC35-4F4A-9A5F-2B8DB2226860@.microsoft.com...
> does anyone know how to add row headers? I have a matrix with a row
composed
> of 5 groups, but I'm not able to add headers to each group because the
header
> cells are merged into one.
> Also, is there a way to move selective row groups around? i.e. I would
like
> to move row group 2 and 4 to the end of the column grouping and leave 1,3
and
> 5 in front.
> Any suggestions?
>|||bill wrote:
> I haven't been able to find a way to split that merged cell above the row
> headers in a matrix. I have asked this group a couple of times, but didn't
> get a response.
> I need to do it because I want titles above the row group headers in a
> matrix, and I can't insert white space to separate the headers in the merged
> cell. (see Ponnurangam's post earlier today).
> This is the one issue my users are not happy about. It is confusing when
> there are several row headers in a matrix with no titles above them.
> -Bill
>
> "Nikki" <Nikki@.discussions.microsoft.com> wrote in message
> news:BB861543-CC35-4F4A-9A5F-2B8DB2226860@.microsoft.com...
>>does anyone know how to add row headers? I have a matrix with a row
> composed
>>of 5 groups, but I'm not able to add headers to each group because the
> header
>>cells are merged into one.
>>Also, is there a way to move selective row groups around? i.e. I would
> like
>>to move row group 2 and 4 to the end of the column grouping and leave 1,3
> and
>>5 in front.
>>Any suggestions?
>>
>
>
I've managed to insert a table in the matrix field. Even if i have to
align all columns by hand it works ;). Just drag and drop from the
toolbox inte the header area.
One problem though. Theay are not visible in any Excel export.
But for the web it works quite ok.
Regards
// Jonas Montonen|||In my case at least, not only are headers not visible in Excel, but I get
an error message "Data Regions within table/matrix cells are ignored." This
happens to be the exact problem I was just searching this forum, hoping to
find a solution for.
Bob
"Jonas Montonen" wrote:
> bill wrote:
> > I haven't been able to find a way to split that merged cell above the row
> > headers in a matrix. I have asked this group a couple of times, but didn't
> > get a response.
> >
> > I need to do it because I want titles above the row group headers in a
> > matrix, and I can't insert white space to separate the headers in the merged
> > cell. (see Ponnurangam's post earlier today).
> >
> > This is the one issue my users are not happy about. It is confusing when
> > there are several row headers in a matrix with no titles above them.
> >
> > -Bill
> >
> >
> > "Nikki" <Nikki@.discussions.microsoft.com> wrote in message
> > news:BB861543-CC35-4F4A-9A5F-2B8DB2226860@.microsoft.com...
> >
> >>does anyone know how to add row headers? I have a matrix with a row
> >
> > composed
> >
> >>of 5 groups, but I'm not able to add headers to each group because the
> >
> > header
> >
> >>cells are merged into one.
> >>
> >>Also, is there a way to move selective row groups around? i.e. I would
> >
> > like
> >
> >>to move row group 2 and 4 to the end of the column grouping and leave 1,3
> >
> > and
> >
> >>5 in front.
> >>
> >>Any suggestions?
> >>
> >>
> >
> >
> >
> I've managed to insert a table in the matrix field. Even if i have to
> align all columns by hand it works ;). Just drag and drop from the
> toolbox inte the header area.
> One problem though. Theay are not visible in any Excel export.
> But for the web it works quite ok.
> Regards
> // Jonas Montonen
>|||I ran in to this one today and found a work around. Design your matrix first
with the 5 groups. Then separately add a table object on the report with
five columns. The table will only have one HEADER row and 5 columns. Put
the column headings in the table. Then cut and paste the table into the
matrix textbox spanning over the groups. Then just resize the cells of the
table with the matrix cell resizing. It's best if the matrix groups can be
fixed. This is a little tricky to control but it does work.
--Good luck!!
"Nikki" wrote:
> does anyone know how to add row headers? I have a matrix with a row composed
> of 5 groups, but I'm not able to add headers to each group because the header
> cells are merged into one.
> Also, is there a way to move selective row groups around? i.e. I would like
> to move row group 2 and 4 to the end of the column grouping and leave 1,3 and
> 5 in front.
> Any suggestions?
>|||Has anyone fixed this issue...
I nned urgent help on how to accomplish this......
Thanks,
"allen" wrote:
> I ran in to this one today and found a work around. Design your matrix first
> with the 5 groups. Then separately add a table object on the report with
> five columns. The table will only have one HEADER row and 5 columns. Put
> the column headings in the table. Then cut and paste the table into the
> matrix textbox spanning over the groups. Then just resize the cells of the
> table with the matrix cell resizing. It's best if the matrix groups can be
> fixed. This is a little tricky to control but it does work.
> --Good luck!!
> "Nikki" wrote:
> > does anyone know how to add row headers? I have a matrix with a row composed
> > of 5 groups, but I'm not able to add headers to each group because the header
> > cells are merged into one.
> >
> > Also, is there a way to move selective row groups around? i.e. I would like
> > to move row group 2 and 4 to the end of the column grouping and leave 1,3 and
> > 5 in front.
> >
> > Any suggestions?
> >
> >|||I finally found a way to add row headers that will render to Excel without
errors. It's pretty easy but not readily intuitive.
1. Resize the report body by dragging the lower edge downward to create some
working space.
2. Drop a "Rectangle" control onto the report body.
3. Drop one "Textbox" control onto the rectangle control for each row header
needed.
4. Resize the textboxes so that they are the right size for each row column
and line them up starting in the upper left corner of the rectangle control.
5. Resize the rectangle control so that it fits around the texboxes.
6. Select the entire rectangle control, cut it and then paste it into the
single textbox area in the matrix where the row headers belong.
Voila! Now why couldn't Microsoft have included this in the Books Online?
Cheers,
John
"Nikki" wrote:
> does anyone know how to add row headers? I have a matrix with a row composed
> of 5 groups, but I'm not able to add headers to each group because the header
> cells are merged into one.
> Also, is there a way to move selective row groups around? i.e. I would like
> to move row group 2 and 4 to the end of the column grouping and leave 1,3 and
> 5 in front.
> Any suggestions?
>|||Yes - great solution. Simple and exports nicely to Excel.
Thanks John!
"John Chorlton" wrote:
> I finally found a way to add row headers that will render to Excel without
> errors. It's pretty easy but not readily intuitive.
> 1. Resize the report body by dragging the lower edge downward to create some
> working space.
> 2. Drop a "Rectangle" control onto the report body.
> 3. Drop one "Textbox" control onto the rectangle control for each row header
> needed.
> 4. Resize the textboxes so that they are the right size for each row column
> and line them up starting in the upper left corner of the rectangle control.
> 5. Resize the rectangle control so that it fits around the texboxes.
> 6. Select the entire rectangle control, cut it and then paste it into the
> single textbox area in the matrix where the row headers belong.
> Voila! Now why couldn't Microsoft have included this in the Books Online?
> Cheers,
> John
>
> "Nikki" wrote:
> > does anyone know how to add row headers? I have a matrix with a row composed
> > of 5 groups, but I'm not able to add headers to each group because the header
> > cells are merged into one.
> >
> > Also, is there a way to move selective row groups around? i.e. I would like
> > to move row group 2 and 4 to the end of the column grouping and leave 1,3 and
> > 5 in front.
> >
> > Any suggestions?
> >
> >|||John,
I've tried your suggested solution. The Headers display Okay in Report
Preview and export Okay to PDF. They don't however export to Excel (2003
SP1), which is unfortunate as it's the only format the users are interested
in.
Any suggestions?
Regards,
John Marsh
"John Chorlton" wrote:
> I finally found a way to add row headers that will render to Excel without
> errors. It's pretty easy but not readily intuitive.
> 1. Resize the report body by dragging the lower edge downward to create some
> working space.
> 2. Drop a "Rectangle" control onto the report body.
> 3. Drop one "Textbox" control onto the rectangle control for each row header
> needed.
> 4. Resize the textboxes so that they are the right size for each row column
> and line them up starting in the upper left corner of the rectangle control.
> 5. Resize the rectangle control so that it fits around the texboxes.
> 6. Select the entire rectangle control, cut it and then paste it into the
> single textbox area in the matrix where the row headers belong.
> Voila! Now why couldn't Microsoft have included this in the Books Online?
> Cheers,
> John
>
> "Nikki" wrote:
> > does anyone know how to add row headers? I have a matrix with a row composed
> > of 5 groups, but I'm not able to add headers to each group because the header
> > cells are merged into one.
> >
> > Also, is there a way to move selective row groups around? i.e. I would like
> > to move row group 2 and 4 to the end of the column grouping and leave 1,3 and
> > 5 in front.
> >
> > Any suggestions?
> >
> >