Using 2 excel data sources for primary and subreport

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.

     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's picture
Joined: Jul 30 2017 - 2:56pm
Last seen: 1 year 1 month ago

0 Answers:

No answers yet