Create Report from 2 Datasets using Matrix with Report Builder SSRS

Emmanuel Debrah 21 Reputation points
2021-10-04T00:45:42.213+00:00

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

137209-image.png

I am using the following datasets

137216-image.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,867 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,571 Reputation points
    2021-10-04T05:48:22.88+00:00

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

    137306-03.jpg

    Preview:

    137307-04.jpg
    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:

    137302-01.jpg
    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:
    137268-02.jpg
    On this basis, I created a matrix, the steps are as follows:
    137160-17.gif
    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.

    0 comments No comments

0 additional answers

Sort by: Most helpful