Create a list on different datasets

Question

I want to display custom list as u can see below. The Items are results from DataSet1 and the Properties are results of DataSet2.

--------------
Items:  |  A  |
        |  B  |
        |  C  |  
--------|----|
 Prop:  | 1  |
--------|----|
 Prop:  | 2   |

To list my Items in that way I have to create a matrix with a parent and child group for that row. How to build a more complex list where I can reference to more then one data set?

Answer 1

Hi @Artimes ,
A data area must be bound to a dataset so that the fields in the dataset can be placed in the data area. In order to associate the data area with the data set, we can set the "dataset name" property for it, or drag a field in the dataset in the "report data" window to the text box of the data area, and after binding, you can no longer add fields from other datasets to the data area. But we could use expressions to refer to data from other datasets.
Referencing multiple datasets: We could use expressions to get the columns or rows of different datasets. For example:

Lookup Function:
Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column. There are two ways to use LOOKUP: Vector form and Array form.

First Function:
The First function returns the first value in a set of data after all sorting and filtering have been applied at the specified scope.
The First function cannot be used in group filter expressions with anything except the current (default) scope.

For more information about using Multiple Datasets in SSRS, please refer to:
Use Multiple Datasets in a Single Tablix Region in SSRS,
How to use multiple datasets in a single table in SSRS:
SSRS - Expression using different dataset fields

Hope this helps.
Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.