How can I generate multiple Excel sheets with JasperReports (6.20.0) and Spring Boot

Hello, I would like to ask if there is a way to generate multiple Excel sheets using JasperReports (6.20.0) and Spring Boot

For instance, make first query to retrieve a List<Employee> listOfEmployees which will populate the first excel sheet called Employees. Then, make a second query to retrieve List<Department> listOfDepartments which will be used to populate the same excel report but on another sheet called Departments. Eventually, we have to create on Excel file with two sheets.

Is it possible to do something like that?

Thank you in advance!

fiyov46807's picture
Joined: Apr 28 2020 - 12:01am
Last seen: 5 months 1 day ago

1) produce list of employees and list of department in two separate reports;

2) create a main report to call those two sub reports and produce multi-sheet xls report output as demonstrated here:

tchen - 10 months 5 days ago

Thank  you!!!

fiyov46807 - 6 months 3 weeks ago

0 Answers:

No answers yet