Max Connections

On a SQL 2005 server I have set the max user connections to 500 and
restarted the SQL Services. The server is showing this as the current
running value.
However the user connections is reporting over 30,000 and sp_who
returns over 150 with the majority of these listed as sleeping.
Why is there difference between the values returned?You are comparing the results of sp_who and what else? Where
are you getting the user connections from?
If you are using @.@.connections, that is the number of
connections and attempted connections since SQL Server
started. It will not correlated to sp_who.
-Sue
On 24 Aug 2006 06:44:11 -0700, robin9876@.hotmail.com wrote:

>On a SQL 2005 server I have set the max user connections to 500 and
>restarted the SQL Services. The server is showing this as the current
>running value.
>However the user connections is reporting over 30,000 and sp_who
>returns over 150 with the majority of these listed as sleeping.
>Why is there difference between the values returned?|||It was a MoM rule which appears to be reporting all connections and
comparing at against concurrent connections.
Sue Hoegemeier wrote:[vbcol=seagreen]
> You are comparing the results of sp_who and what else? Where
> are you getting the user connections from?
> If you are using @.@.connections, that is the number of
> connections and attempted connections since SQL Server
> started. It will not correlated to sp_who.
> -Sue
> On 24 Aug 2006 06:44:11 -0700, robin9876@.hotmail.com wrote:
>|||But that doesn't answer what it's using. I don't have MOM
running where I'm at and don't remember all the details of
what runs what but there is a way to view what it's using.
Otherwise you can use Profiler and see what MOM is executing
when it checks your SQL Server.
-Sue
On 25 Aug 2006 01:32:13 -0700, robin9876@.hotmail.com wrote:
[vbcol=seagreen]
>It was a MoM rule which appears to be reporting all connections and
>comparing at against concurrent connections.
>
>Sue Hoegemeier wrote:

matrix subtotal

Hi Everyone,

I am trying to get something like this using matrix in reporting services

SE CP CG Total Qty Value Qty Value Qty Value Qty Value GST Net 7/07/2006 124 233 552 525 141 2544 563 4215 321 4536 8/07/2006 1245 211 11 142 555 1444 1987 1854 124 1978

The problem is, in the total group, the GST value and Net ( Net = Value + GST) can't added into the total group in the matrix.

Can somebody help... Thanks a lot.

You can use InScope in a matrix to determine 'where you are' e.g. are you a subtotal cell, are you within a particular column or row grouping

You can also create hidden groups

This helps to deal with non additive measures

In fact here's another post that may help

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1884435&SiteID=1

|||

Thanks a lot..

That help me a lot...

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 Pagination

Hello,
I've been developing a matrix report in Reporting Services, and for
some reason, pagination does not work. Instead of getting page breaks
when the report runs over the page height, the report renders as a
single page. PDF export seems to work fine (i.e., the pagination works
correctly), but regular HTML display of the report does not.
I've checked every parameter that I could find -- KeepTogether, page
height, etc. -- but the matrix does not paginate. Am I missing
something? What else should I check?
Thanks for your help,
GarrettIf your report uses toggles for visibility, pagination may not work correctly
in HTML, while it does render correctly in PDF. My understanding is that this
is being worked on for the next service pack.
John W
"Garrett" wrote:
> Hello,
> I've been developing a matrix report in Reporting Services, and for
> some reason, pagination does not work. Instead of getting page breaks
> when the report runs over the page height, the report renders as a
> single page. PDF export seems to work fine (i.e., the pagination works
> correctly), but regular HTML display of the report does not.
> I've checked every parameter that I could find -- KeepTogether, page
> height, etc. -- but the matrix does not paginate. Am I missing
> something? What else should I check?
> Thanks for your help,
> Garrett
>|||Bingo! I'm using an expression to determine visibility of the row
groups in my report. The report is meant to be dynamic so the user can
select which dimensions are displayed, and therefore the visibility is
based on specific report parameters.
I took out the visibility expressions, and pagination started working
again. Thanks for the suggestion and the quick response. Now I just
need to figure out a way to make pagination and dynamic groups work
together (besides waiting for the next service pack).
Garrett

Matrix Group Shading

I am using SQL 2000 Reporting Services.
I am trying to get a column group to shade if it starts with the word
Total. The problem is there is not always a "Total" value for a
particular "row group" (date). Is there a way to shade the entire
column?
Here is the current formula. Is there a way to reference the current
group header?
=iif (mid(Fields!SubType.Value,1,5)="Total","PaleGoldenrod","")
Thanks,Basically I want to set the background color on the entire column if
the group (column) header begins with the word "Total".
daveg.01@.gmail.com wrote:
> I am using SQL 2000 Reporting Services.
> I am trying to get a column group to shade if it starts with the word
> Total. The problem is there is not always a "Total" value for a
> particular "row group" (date). Is there a way to shade the entire
> column?
> Here is the current formula. Is there a way to reference the current
> group header?
> =iif (mid(Fields!SubType.Value,1,5)="Total","PaleGoldenrod","")
> Thanks,

Matrix custom subtotals ? How is it possible ?

Hi ALL,
I have a problem and i becoming crazy !
I create a report like this using a Matrix in Reporting Services
Sales
Area 1 250
Customer 1 100
Customer 2 150
Area 2 60
Customer 3 40
Customer 4 20
I need to add a total row witch is the sum of AREA 1 + AREA 2 lke this
IMPORTANT : rows in matrix becomes directly from my query... they are
not grouping.
Sales
Area 1 250
Customer 1 100
Customer 2 150
Area 2 60
Customer 3 40
Customer 4 20
TOTAL 310
How can I express the contition... If I add a total to the matrix my
total is 620 (wrong !...)
Thank you !
Gas1970On Jun 13, 11:16 am, alberto.gasta...@.libero.it wrote:
> Hi ALL,
> I have a problem and i becoming crazy !
> I create a report like this using a Matrix in Reporting Services
> Sales
> Area 1 250
> Customer 1 100
> Customer 2 150
> Area 2 60
> Customer 3 40
> Customer 4 20
> I need to add a total row witch is the sum of AREA 1 + AREA 2 lke this
> IMPORTANT : rows in matrix becomes directly from my query... they are
> not grouping.
> Sales
> Area 1 250
> Customer 1 100
> Customer 2 150
> Area 2 60
> Customer 3 40
> Customer 4 20
> TOTAL 310
> How can I express the contition... If I add a total to the matrix my
> total is 620 (wrong !...)
> Thank you !
> Gas1970
Traditionally, in some cases, I obtain my sums/totals in the stored
procedure/query that is sourcing my matrix report. This should be a
good option in your case as well. Also, depending on the complexity of
the matrix report, you may need to use a while loop/cursor to
determine the sum/totals. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Matrix Cross-tab Report Not Counting Records

I am new to Reporting Services and cross-tab reporting in general. I
need to create a basic report that has dates across the top and reps
down the left. The data I would like to see reflected is the number of
entries created in the table by rep by day with cross sums. What I am
getting is a report that has a column for every entry with the date
repeated over and over and no totals, only 1 in each column.
Visually I need to see:
Day 1 Day 2 Day 3 Total
__________________________________
Rep1 4 10 1 15
Rep2 2 4 3 9
Total 6 14 4 24
What I am getting is a report where Day 1 would be repeated 6 times
with an entry of 1.
Can someone point me in the right direction?I would like to add that my table uses a datetime field that has a
unique value for each record. I do need a specific timestamp.
Probably part of my problem, but how do I resolve it?
zanecolvin@.gmail.com wrote:
> I am new to Reporting Services and cross-tab reporting in general. I
> need to create a basic report that has dates across the top and reps
> down the left. The data I would like to see reflected is the number of
> entries created in the table by rep by day with cross sums. What I am
> getting is a report that has a column for every entry with the date
> repeated over and over and no totals, only 1 in each column.
> Visually I need to see:
> Day 1 Day 2 Day 3 Total
> __________________________________
> Rep1 4 10 1 15
> Rep2 2 4 3 9
> Total 6 14 4 24
> What I am getting is a report where Day 1 would be repeated 6 times
> with an entry of 1.
> Can someone point me in the right direction?|||Solved my own problem. Created a view converting data type from and
back to datetime to get 12:00 time on all entries. Used that for the
report.
zanecolvin@.gmail.com wrote:
> I would like to add that my table uses a datetime field that has a
> unique value for each record. I do need a specific timestamp.
> Probably part of my problem, but how do I resolve it?
>

Matrix Calculation - New to RS2000

Hello!
Iâ'm hoping somebody out there can help me! I am a new user of SQL Reporting
Services 2000 and have been asked to create a report showing studentsâ'
attendance. After a lot of reading and research I created a matrix report
that looks like this;
=Fields!attendance_type.value Total
=Fields!student_id.value
=Fields!week_no.value =Fields!register_id.Value =count(Fields!attendance_type.value)
It gives me the following results;
PR AA AB Total
0003 7 ACCA2 4 0 0 4
BUSA2 4 0 0 4
LANA2 2 2 0 4
8 ACCA2 2 2 0 4
BUSA2 2 2 0 4
LANA2 2 0 0 2
9 ACCA2 4 0 0 4
BUSA2 2 0 2 4
LANA2 3 0 0 3
10 ACCA2 4 0 0 4
BUSA2 4 0 0 4
LANA2 3 0 0 3
I would now like to add another column next to Total (subtotal of
=Fields!attendance_type.value) to calculate the % Attendance by using
PR/Total*100.
So in the end, I want something like this;
PR AA AB Total % Attendance
0003 7 ACCA2 4 0 0 4 100
BUSA2 4 0 0 4 100
LANA2 2 2 0 4 50
8 ACCA2 2 2 0 4 50
BUSA2 2 2 0 4 50
LANA2 2 0 0 2 100
Your help would be much appreciatedâ?¦
Wilma KhaliqYou can do a second query and append it to this one with "union", like
select blah blah from blah where blah
union
select blah2 blah2 from blah2 where blah2
except in the bottom select you can do your total, making a new type called
'TOTAL'
--
"Everyone knows something you don't know"
"Whee4ever" wrote:
> Hello!
> Iâ'm hoping somebody out there can help me! I am a new user of SQL Reporting
> Services 2000 and have been asked to create a report showing studentsâ'
> attendance. After a lot of reading and research I created a matrix report
> that looks like this;
> =Fields!attendance_type.value Total
> =Fields!student_id.value
> =Fields!week_no.value =Fields!register_id.Value =count(Fields!attendance_type.value)
> It gives me the following results;
> PR AA AB Total
> 0003 7 ACCA2 4 0 0 4
> BUSA2 4 0 0 4
> LANA2 2 2 0 4
> 8 ACCA2 2 2 0 4
> BUSA2 2 2 0 4
> LANA2 2 0 0 2
> 9 ACCA2 4 0 0 4
> BUSA2 2 0 2 4
> LANA2 3 0 0 3
> 10 ACCA2 4 0 0 4
> BUSA2 4 0 0 4
> LANA2 3 0 0 3
> I would now like to add another column next to Total (subtotal of
> =Fields!attendance_type.value) to calculate the % Attendance by using
> PR/Total*100.
> So in the end, I want something like this;
> PR AA AB Total % Attendance
> 0003 7 ACCA2 4 0 0 4 100
> BUSA2 4 0 0 4 100
> LANA2 2 2 0 4 50
> 8 ACCA2 2 2 0 4 50
> BUSA2 2 2 0 4 50
> LANA2 2 0 0 2 100
> Your help would be much appreciatedâ?¦
> Wilma Khaliq

Matrix Aggregation to a Column only

Hello,
I have a matrix report displaying data from a data cube, via analysis
services. It contains column groupings for Months, Quarters and Year as well
as row groups for Team, User and Region. This allows the user to drill down
from a top level "All Teams" total for the whole year, down to a full view of
a region for a particular month.
To achieve this, the "Sum" function is used to aggregate the figures. But,
we wish to also use a running total of Sales by region using Brought Forward
and Carried Forward balances. This needs to be aggregated by column (region
to user to team), but not by row. (Otherwise the Jan, Feb and March totals
are added together for example for Q1, which is incorrect).
Is there a way to specify the axis for the Sum function? Or another way to
create the report that still allows the drill-down/up functionality?
Many Thanks.
Ben Mann.Although I don't understand the business part of your question... Matrix
allows aggregations to be done on rows OR columns... It looks like you
wanted some aggregation on both axes... Matrixes can do this...
Also you can use any of the aggregate functions that RS supports, take a
look at runningvalue... that might be what you are lookin for...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ben Mann" <Ben Mann@.discussions.microsoft.com> wrote in message
news:37B6B96A-FF6F-4D63-A820-B6E588C13233@.microsoft.com...
> Hello,
> I have a matrix report displaying data from a data cube, via analysis
> services. It contains column groupings for Months, Quarters and Year as
well
> as row groups for Team, User and Region. This allows the user to drill
down
> from a top level "All Teams" total for the whole year, down to a full view
of
> a region for a particular month.
> To achieve this, the "Sum" function is used to aggregate the figures. But,
> we wish to also use a running total of Sales by region using Brought
Forward
> and Carried Forward balances. This needs to be aggregated by column
(region
> to user to team), but not by row. (Otherwise the Jan, Feb and March totals
> are added together for example for Q1, which is incorrect).
> Is there a way to specify the axis for the Sum function? Or another way to
> create the report that still allows the drill-down/up functionality?
> Many Thanks.
> Ben Mann.

Matrix - No data display "NaN"

Hello,

I have matrix object in reportin (SQL 2005 reporting services)

When in some field have no data it display NaN.

How can I change it ?

I try to use iif(my function = nothing.....) but didn't help

Hi there,

Here's a blog posting that may help

http://blogs.digineer.com/blogs/jasons/archive/2006/08/18/374.aspx

cheers,

Andrew