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!
0 Answers:
No answers yet
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:
https://community.jaspersoft.com/wiki/sample-report-creating-multi-sheet...
Thank you!!!