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

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