Dev Tips#52 How to create a subreport in Jasper report

How to create a subreport in Jasper report

[ainigma]

Thank you for your video. Assume that we have the following example:

Employee class
int id;
string firstName;
string lastName;
string department;
// extra attribute
List<WorkedDayAndHours> dayAndHours;

WorkedDayAndHours class
date workedDay;
int workedHours;

Is it possible to have a List<WorkedDayAndHours> in the Employee class and create a jasperreport using that field as well?

I would like to have the following report structure:
ID | First Name | Last Name | Department | Worked Day | Worked Hours
1 | Nick | Smith | Security | 12/03/2021 | 8
2 | Nick | Smith | Security | 14/04/2021 | 10

I know that there are some redundant values. I just wanted to see how to implement it. Thank you!

[ainigma]

Can we create different excel sheets using jasper report and spring boot? Assume that we have an excel with 2 sheets. Can we use jasper to populate 1 sheet with one query and another sheet with another query? Eventually, we should have 1 excel file with 2 sheets

[AhmedKhaled-hemf]

Thanks for your efforts bro, you create a nice explain for subreport Jasper

Excuse me please I need you help
is there any way to chat with you?
I want to send you some files (videos or if you want my reports) for my issue
please bro any help

[dineshmittal]

Hi all..
Can any one please solve my query....I have a report with the dynamic text feild of subreport doesn't stretch .
Can any one please help

[cjritzua]

in java please with spring boot thanks