Joining two datasets to create a single tablix in report builder 3

Question

I am attempting to join two datasets in to one tablix for a report. The second dataset requires a personID from the first dataset as its parameter.

If i preview this report only the first dataset is shown. but for my final result what i would like to happen is for each row of a student there is a rowgrouping (?) of that one students modules with their month to month attendance. Can this be done in report builder?

Answer 1

The best practice here is to do the join within one dataset (i.e. joining in SQL)

---

But in cases that you need data from two separate cubes(SSAS) the only way is the following:

1. Select the main dataset for the Tablix

2. Use the lookup function to lookup values from the second dataset like this:

   =Lookup(Fields!ProductID.Value, Fields!ID.Value, Fields!Name.Value, "Product")
   

   Note: The granularity of the second dataset must match the first one.