Possible to add columns to the right-hand side of a matrix?

Is it possible to add columns to the right-hand side of a matrix? Does anyone
have an example of joining a matrix and a table? Our report designs are never
as simple as the AdventureWorks examples. Currently, we use Actuate, which
allows for practically unlimited possibilities for report layout. We are
investigating migrating to Reporting Services, and we would appreciate any
tips/examples for achieving more complex layouts. Thanks!Not sure that I understand your question.
The Idea with the matrix is to dynammically add columns based on the group
you picked for the columns.
Maybe introduce some black"null" members in that group.
i.e if the dataset read something like
rowgroup1,columngroup1,measurefield1
a x1 10
b x2 20
c x3 30
d x4 40
try make it look like
rowgroup1,columngroup1,measurefield1
a x1 10
b x2 20
c x3 30
d x4 40
a Z NULL
b Z1 NULL
then on the report in the measure field ...iif (columngroup1='Z',"",.....)
marcell
We moved to ReportingServices with schemtisism, and have been waiting to
reach a stage where we hit a wall.
Still hasnt happened and I have developed some insanely complicated reports.
Flexibility is great!
"chatlineboy" <chatlineboy@.discussions.microsoft.com> wrote in message
news:79300D9D-0EFA-4047-B8B5-A231FBD68115@.microsoft.com...
> Is it possible to add columns to the right-hand side of a matrix? Does
> anyone
> have an example of joining a matrix and a table? Our report designs are
> never
> as simple as the AdventureWorks examples. Currently, we use Actuate, which
> allows for practically unlimited possibilities for report layout. We are
> investigating migrating to Reporting Services, and we would appreciate any
> tips/examples for achieving more complex layouts. Thanks!
>|||Thanks brickmouse! Yes, we had thought of that, also just introducing extra
groups with repeating values. We are continuing to evaluate Reporting
Services, but so far we are not convinced it is as flexible as Actuate.
"brickmouse" wrote:
> Not sure that I understand your question.
> The Idea with the matrix is to dynammically add columns based on the group
> you picked for the columns.
> Maybe introduce some black"null" members in that group.
> i.e if the dataset read something like
> rowgroup1,columngroup1,measurefield1
> a x1 10
> b x2 20
> c x3 30
> d x4 40
> try make it look like
> rowgroup1,columngroup1,measurefield1
> a x1 10
> b x2 20
> c x3 30
> d x4 40
> a Z NULL
> b Z1 NULL
> then on the report in the measure field ...iif (columngroup1='Z',"",.....)
>
> marcell
>
> We moved to ReportingServices with schemtisism, and have been waiting to
> reach a stage where we hit a wall.
> Still hasnt happened and I have developed some insanely complicated reports.
> Flexibility is great!
>
> "chatlineboy" <chatlineboy@.discussions.microsoft.com> wrote in message
> news:79300D9D-0EFA-4047-B8B5-A231FBD68115@.microsoft.com...
> > Is it possible to add columns to the right-hand side of a matrix? Does
> > anyone
> > have an example of joining a matrix and a table? Our report designs are
> > never
> > as simple as the AdventureWorks examples. Currently, we use Actuate, which
> > allows for practically unlimited possibilities for report layout. We are
> > investigating migrating to Reporting Services, and we would appreciate any
> > tips/examples for achieving more complex layouts. Thanks!
> >
>
>

Possible BUG in RS.

When populating a matrix and having an expression to set the background of
the row , in this case I am setting alternate shading of rows to make reading
easier, I would expect the whole matrix row to to be shaded, not just the
groups in the row that have a value in them.
To simplify my descritpion here, I ask MS why does RS only allow the data
groups that have a value in them set the background to that of the expression
I specify.
Surely the group should set the background attribute I specify regardless of
a value contained in the group.
The resultant display is like a checker board effect, as groups in the row
with data will be grey background and those without the value in the same
group will remain transparent.
Has anyone else had similar issues with Matrices in RS?
cheers
PaulYou want to read the following blog article:
http://blogs.msdn.com/chrishays/archive/2004/08/30/223068.aspx
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"PaulQld" <PaulQld@.discussions.microsoft.com> wrote in message
news:E2EFE16E-98F0-4DC2-A55D-40709956C697@.microsoft.com...
> When populating a matrix and having an expression to set the background of
> the row , in this case I am setting alternate shading of rows to make
> reading
> easier, I would expect the whole matrix row to to be shaded, not just the
> groups in the row that have a value in them.
> To simplify my descritpion here, I ask MS why does RS only allow the data
> groups that have a value in them set the background to that of the
> expression
> I specify.
> Surely the group should set the background attribute I specify regardless
> of
> a value contained in the group.
> The resultant display is like a checker board effect, as groups in the row
> with data will be grey background and those without the value in the same
> group will remain transparent.
> Has anyone else had similar issues with Matrices in RS?
> cheers
> Paul
>|||Robert, thankyou for your link to Chris's blogg.
Paul
"Robert Bruckner [MSFT]" wrote:
> You want to read the following blog article:
> http://blogs.msdn.com/chrishays/archive/2004/08/30/223068.aspx
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "PaulQld" <PaulQld@.discussions.microsoft.com> wrote in message
> news:E2EFE16E-98F0-4DC2-A55D-40709956C697@.microsoft.com...
> > When populating a matrix and having an expression to set the background of
> > the row , in this case I am setting alternate shading of rows to make
> > reading
> > easier, I would expect the whole matrix row to to be shaded, not just the
> > groups in the row that have a value in them.
> >
> > To simplify my descritpion here, I ask MS why does RS only allow the data
> > groups that have a value in them set the background to that of the
> > expression
> > I specify.
> >
> > Surely the group should set the background attribute I specify regardless
> > of
> > a value contained in the group.
> >
> > The resultant display is like a checker board effect, as groups in the row
> > with data will be grey background and those without the value in the same
> > group will remain transparent.
> >
> > Has anyone else had similar issues with Matrices in RS?
> >
> > cheers
> > Paul
> >
> >
>
>

Positioning Subtotal in Matrix

Is there a way to re-position the subtotal in a matrix report such that the
subtotal is displayed at the beginning of the report instead of at the end.
Currently:
Q1 10
Q2 5
Q3 10
Q4 3
Total 28
Need:
Total 28
Q1 10
Q2 5
Q3 10
Q4 3
Thanks!You can change the subtotal position. Click on the little green triangle in
the (row/column) heading to get the subtotal properties and look at the VS
properties window. There is a "Position" property which is set to "After" by
default. You can set it to "Before", which results in the desired effect.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Teresa" <Teresa@.discussions.microsoft.com> wrote in message
news:8565A38F-17B9-40F9-BDF2-499E73A3FC85@.microsoft.com...
> Is there a way to re-position the subtotal in a matrix report such that
> the
> subtotal is displayed at the beginning of the report instead of at the
> end.
> Currently:
> Q1 10
> Q2 5
> Q3 10
> Q4 3
> Total 28
> Need:
> Total 28
> Q1 10
> Q2 5
> Q3 10
> Q4 3
> Thanks!
>