Repeating a Matrix With Different Values

I have a basic matrix with a title in the top lef corner, a list of locations
down the left hand side and one column per day of reporting across the top.
My problem is that the title is actually data from another column of my
recordset. I am repeating the matrix several times and filtering on this
value to obtain the relevant records for that matrix.
What I want is to automatically repeat the matrix however many times is
necessary for the recordset to be fully output. I thought adding the matrix
to the detail row of a table would acheive this but ssrs won't allow me to do
this.
I'm relatively new to ssrs - is there any way of doing this?If i Understand your concern.
You want to show different matrices for each distinct value in the
Column of a Record set
why can't you have a list containing Matix and Group the List on column
name you want to
Group .Hope this will help you
if you want more detail
please reply
regards
Raj Deep.A
rocket salad wrote:
> I have a basic matrix with a title in the top lef corner, a list of locations
> down the left hand side and one column per day of reporting across the top.
> My problem is that the title is actually data from another column of my
> recordset. I am repeating the matrix several times and filtering on this
> value to obtain the relevant records for that matrix.
> What I want is to automatically repeat the matrix however many times is
> necessary for the recordset to be fully output. I thought adding the matrix
> to the detail row of a table would acheive this but ssrs won't allow me to do
> this.
> I'm relatively new to ssrs - is there any way of doing this?|||I've managed to get a list object to repeat the matrix. But I still can't set
the filter for the matrix to reference the list's filter's current value.
Help is much appreciated.
"rocket salad" wrote:
> I have a basic matrix with a title in the top lef corner, a list of locations
> down the left hand side and one column per day of reporting across the top.
> My problem is that the title is actually data from another column of my
> recordset. I am repeating the matrix several times and filtering on this
> value to obtain the relevant records for that matrix.
> What I want is to automatically repeat the matrix however many times is
> necessary for the recordset to be fully output. I thought adding the matrix
> to the detail row of a table would acheive this but ssrs won't allow me to do
> this.
> I'm relatively new to ssrs - is there any way of doing this?|||My test data only included one value, so the matrix didn't repeat. I had
assumed that when it did, it wouldn't automatically reference the list. As it
happens, since I've altered my source data it works fine.
Thanks.
"RajDeep" wrote:
> If i Understand your concern.
> You want to show different matrices for each distinct value in the
> Column of a Record set
> why can't you have a list containing Matix and Group the List on column
> name you want to
> Group .Hope this will help you
> if you want more detail
> please reply
> regards
> Raj Deep.A
>
> rocket salad wrote:
> > I have a basic matrix with a title in the top lef corner, a list of locations
> > down the left hand side and one column per day of reporting across the top.
> >
> > My problem is that the title is actually data from another column of my
> > recordset. I am repeating the matrix several times and filtering on this
> > value to obtain the relevant records for that matrix.
> >
> > What I want is to automatically repeat the matrix however many times is
> > necessary for the recordset to be fully output. I thought adding the matrix
> > to the detail row of a table would acheive this but ssrs won't allow me to do
> > this.
> >
> > I'm relatively new to ssrs - is there any way of doing this?
>|||So you are trying to catch something which is not in the scope.matrix
can be in Scope of list.But list cannot be in Scope of matrix
Try filter in the dataset tab.
Frankly to speak i didn't understand what exactly you are trying to do.
Filter on the Dataset will filter the records which is returned by the
datasource.
Regards
Raj Deep.A
rocket salad wrote:
> I've managed to get a list object to repeat the matrix. But I still can't set
> the filter for the matrix to reference the list's filter's current value.
> Help is much appreciated.
> "rocket salad" wrote:
> > I have a basic matrix with a title in the top lef corner, a list of locations
> > down the left hand side and one column per day of reporting across the top.
> >
> > My problem is that the title is actually data from another column of my
> > recordset. I am repeating the matrix several times and filtering on this
> > value to obtain the relevant records for that matrix.
> >
> > What I want is to automatically repeat the matrix however many times is
> > necessary for the recordset to be fully output. I thought adding the matrix
> > to the detail row of a table would acheive this but ssrs won't allow me to do
> > this.
> >
> > I'm relatively new to ssrs - is there any way of doing this?