Matrix with more than one table possible?

Hi,
I would like to use a Matrix where the first table defines the
Columns, the second table the rows and a third table holds the data -
which needs to be associated by the values from column and row. But
for some reason I can only set one table from a data set as the data
source (e.g.: dsData_tblDefinitions).
How can this be done? If I drag and drop the other fields from the
same or other datasets it can't find the tables / fields.
Thanks,
OlcayOn Apr 30, 10:37 am, olc...@.gmail.com wrote:
> Hi,
> I would like to use a Matrix where the first table defines the
> Columns, the second table the rows and a third table holds the data -
> which needs to be associated by the values from column and row. But
> for some reason I can only set one table from a data set as the data
> source (e.g.: dsData_tblDefinitions).
> How can this be done? If I drag and drop the other fields from the
> same or other datasets it can't find the tables / fields.
> Thanks,
> Olcay
Normally, matrix reports cannot include multiple datasets by default
(if its possible at all, outside of specific referenced aggregates in
a particular cell), etc. Why is the standard matrix report not an
option in this case (one pivot column for the column names, one column
for the row info and the remaining columns for the data)?
Enrique Martinez
Sr. Software Consultant|||On 1 Mai, 05:37, EMartinez <emartinez...@.gmail.com> wrote:
> On Apr 30, 10:37 am, olc...@.gmail.com wrote:
> > Hi,
> > I would like to use a Matrix where the first table defines the
> > Columns, the second table the rows and a third table holds the data -
> > which needs to be associated by the values from column and row. But
> > for some reason I can only set one table from a data set as the data
> > source (e.g.: dsData_tblDefinitions).
> > How can this be done? If I drag and drop the other fields from the
> > same or other datasets it can't find the tables / fields.
> > Thanks,
> >Olcay
> Normally, matrix reports cannot include multiple datasets by default
> (if its possible at all, outside of specific referenced aggregates in
> a particular cell), etc. Why is the standard matrix report not an
> option in this case (one pivot column for the column names, one column
> for the row info and the remaining columns for the data)?
> Enrique Martinez
> Sr. Software Consultant
Hi Enrique,
the problem is, that my colum names are also dynamic. Columns
(tblTasks), Rows (tblObjects) and Data (tblValues - the result of
applying the tasks on those objects) are all dynamic.
Thanks,
Olcay

Matrix visibility and toggling with multi row fields

I have a matrix with two row fields. The second one doesnt show unless i press the toggle button on the first row field. How can make the first row field automatically expanded to show the second row field?

Thanks.

Is it 2 row groups? If so, go to your second row group, edit and check the visibility tab. Make sure it isn't controlled by another report item.|||Yes it is 2 row groups, it is not controlled by any other items and it is not set to hidden. This is in the properties of the textbox correct?|||I found the problem, i was looking at the text box properties, when you right click on the cell, you must select edit group, not properties.

matrix problem!

I created a matrix and everything looks good except that when I do a preview
the first page is ok but the second to the last pages my matrix shifts a bit
to the right. Anyone has an idea what's causing this? I can't seem to
reproduce this in my other report so I'm wondering what's up with this?
Thanks!Does this mean that no one has an answer to my question? I just want to know
if this is a bug or something I'm doing wrong?
"Laura" wrote:
> I created a matrix and everything looks good except that when I do a preview
> the first page is ok but the second to the last pages my matrix shifts a bit
> to the right. Anyone has an idea what's causing this? I can't seem to
> reproduce this in my other report so I'm wondering what's up with this?
> Thanks!