Create Report from 2 Datasets using Matrix with Report Builder SSRS

Question

I need help in building a report with Matrix using Report builder to produce the output below

I am using the following datasets

Answer 1

Hi @Emmanuel Debrah ，
I did some tests, the following is the effect you need, but I did not set the sorting.
Design:

Preview：

I created two tables in the local database. The difference from you is that I added an extra column [Column_State] on this basis, as shown in the following figure:

Then I created a dataset through the following statement (combined two tables into one)：

SELECT        Program, Sex, Freq, column_State  
FROM            Dataset_01(TableName)  
UNION  
SELECT        Program, Sex, Freq, column_State  
FROM            Dataset_02(TableName)  

I got a table like this:

On this basis, I created a matrix, the steps are as follows：

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.