Mutliple Datasets One List

  • I have three datasets I want in a matrix grouped by a list. However, if I put my second matrix in the list grouped by EmployeeID it then defaults my second matrix to the first matrix dataset.

    I want output below desired. All three datasets have 1 common identifier. 
    Employee Name
    Matrix1      Matrix2     Matrix3

    Employee Name
    Matrix1      Matrix2     Matrix3

    etc...

  • Hey Kyle,

    It sounds like you could be crafting a report that ends up performing poorly (i.e. renders slowly).  I'd recommend you consider how to get down to just 1 dataset.  You may consider using grouping within a single matrix or table.  Another option could be subreports, but performance could be a factor there too.  The server will query the database each time the subreport is needed.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply