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!
> >
>
>