Using 2 excel data sources for primary and subreport

[kristjan.grm1gmail.com]

Hello, I am new to using jaspersoft. 

Software im using is JasporSoft studio. I have 2 tables in excel. One contains 365 rows for each day of the day (table A). The second table (table B) containts around 1600 rows each row had column called date, so there are 3-6 rows in table B for every day in table A.

My report would look like this at the end.

tableA.DATE
     tableB.(where DATE=tableA.DATE)
     tableB.(where DATE=tableA.DATE)
     tableB.(where DATE=tableA.DATE)

for everyday so 365 prints like this. 

Im having problems grouping data from tableB per date, so for every day program should print new table

please help