Why is my subreport displaying all the result in each cell in the main report?

See more:

VB

ASP.NET

RDLC

I do have RDLC files named MainReport.rdlc and SubReport.rdlc.

Subreport.rdlc (Obviously, act as my subreport).

I was able to display the details of my subreport in my Main Table. but the problem is that the subreport displays all the data on each row in my subreport

What I want is this:

================================================================================
   Scope         Tasks           Quality           Quantity         Accuracy
================================================================================
  Scope 1      Task # 1         3 - Amazing                       3 - Perfect
               Task # 2         2 - Good                          2 - Less Error
               Task # 3         1 - Bad                           1 - Many Error
================================================================================
  Scope 2      Task # 4         3 - Amazing      3 - Too many
               Task # 5         2 - Good         2 - Enough
                                1 - Bad          1 - Lacking
================================================================================

But what is happening is this:

================================================================================
   Scope         Tasks           Quality           Quantity         Accuracy
================================================================================
  Scope 1      Task # 1         3 - Amazing                       3 - Perfect
               Task # 2         2 - Good                          2 - Less Error
               Task # 3         1 - Bad                           1 - Many Error
               Task # 4         
               Task # 5         
================================================================================
  Scope 2      Task # 1         3 - Amazing      3 - Too many
               Task # 2         2 - Good         2 - Enough
               Task # 3         1 - Bad          1 - Lacking
               Task # 4         
               Task # 5
================================================================================

What I have tried:

The dataset query on MainReport

Select DISTINCT tblMain.ID_Num, tblMain.fldDate,Scope.Description,tblMain.Accomplishment,Rating.fldQuality, Rating.fldQuantity, Rating.fldAccuracy from tblMain 
JOIN tblScope as SCOPE on  tblMain.Scope = Scope.Id
LEFT JOIN tblRatings as Rating on tblMain.RatingRefCode = Rating.ScopeCode 
where tblMain.ID_Num = @RefNo AND fldDate between @Start and @End
Group By tblMain.ID_Num, tblMain.fldDate,Scope.Description,tblMain.Accomplishment,Rating.fldQuality, Rating.fldQuantity, Rating.fldAccuracy

Here is the dataset query on Subreport

Select DISTINCT tblMain.ID_Num, tblMain.fldDate,Scope.Description,tblMain.Accomplishment from tblMain 
JOIN tblScope as SCOPE on  tblMain.Scope = Scope.Id
LEFT JOIN tblRatings as Rating on tblMain.RatingRefCode = Rating.ScopeCode 
where tblMain.ID_Num = @RefNo AND fldDate between @Start and @End
Group By tblMain.ID_Num, tblMain.fldDate,Scope.Description,tblMain.Accomplishment