fiyov46807

Hello, I am trying to use Spring Boot and Jasper Report, to create an excel file that has the following format. I would like to group by EMP_ID and merge the repeated values of that column. EMP_IDDATEAMOUNTPAYMENT_DESCRIPTION2507/12/20211500DESC 124/05/20222300DESC 211/09/2022500DESC 34024/05/20221800TRAVEL EXP 16224/02/20231500BUY HARDWARE The above table shows that I would like to merge EMP_ID with the same value. I have attached the .jrxml file How can I do something like that? I think it can be possibly done by using sub-report, but I do not know the way. I crated the .jrxml report on Jaspersoft Studio and then I used Spring Boot to populate the report. I have seen this post: https://community.jaspersoft.com/wiki/how-merge-table-rows-repeated-values but I was unable to fix my issue because I am not very familiar with jasper reports. Thank you in advance!

Thank you!!!

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!

Hello, I would like to ask if there is a way to use the latest JasperReport Library to create a pdf in a Spring Boot project. maven repo: https://mvnrepository.com/artifact/net.sf.jasperreports/jasperreports/6.20.0 I have noticed that the version 6.20.0 does not have the following dependency In order to fix this error, I had to set the dependencies in the POM file, as follows: <dependency> <groupId>net.sf.jasperreports</groupId> <artifactId>jasperreports</artifactId> <version>6.20.0</version> <exclusions> <exclusion> <groupId>com.lowagie</groupId> <artifactId>itext</artifactId> </exclusion> </exclusions></dependency><dependency> <groupId>com.lowagie</groupId> <artifactId>itext</artifactId> <version>2.1.7</version> <scope>compile</scope></dependency>[/code]As you can see above, I had to use an older version of itext 2.1.7 Furthermore, itext has moved to itextpdf. Assume that I would like to use the latest versions of JasperReports (6.20.0) and itextpdf (5.5.13.3). As soon as I try to generate the pdf file, I get the following error: Caused by: java.lang.ClassNotFoundException: com.lowagie.text.DocumentException I read in this thread, that I have to use itext 2.1.7: https://community.jaspersoft.com/questions/986581/jasperreports-621-classes-import-comlowagie Is there a possibility that this issue could be fixed in the future? Thank you in advance!

Hello, I am trying to generate a PDF report using the following entities, but I cannot do it. public class EmployeeReportData { private int id; private string firstName; private string lastName; private string department; private List<WorkedDayAndHours> dayAndHours; // Getters and Setters ...}public class WorkedDayAndHours { private Date workedDay; private int workedHours; // Getters and Setters ...}[/code]I would like to create a PDF report using the EmployeeReportData class. Something like the following output: IDFirst NameLast NameDepartmentWorked DayWorked Hours1JohnWickSecurity10 / 02 / 202182JohnWickSecurity12 / 02 / 20219Total Worked Hours173MarcoPoloCloud12 / 02 / 20218Total Worked Hours8Is it possible to implement something like this using Spring Boot and Jasper Report? The only issue I have is the List<WorkedDayAndHours> inside the EmployeeReportData class. I do not know how to work with nested lists inside an object. Normally, I would like to send to jasper a List<EmployeeReportData > which contains a List<WorkedDayAndHours> for each EmployeeReportData record.

I found the solution. I will answer my question so that if someone wants the answer, they can have it. For instance, if you need to use page break when Department code changes you can do the following steps. Right click on your project and select Create GroupIn the pop-up window select a Group Name and from the Reports Objects below, select the field value you want. In this example we want the Department Code. Then select Next, select only Add the Header Group and Finish.In the Outline window you will see that the new group appeared. You will notice that the height of the new Group inside the Design Tab is big. Select the Group from the Outline window and in the Properties window check the following.In the Group Properties have the name of the group. Verify that the Expression is correct ($F{DepartmentCode}) . Select Reprint Header on Each Page (because on each page you have the Department Code). Select Start New Page and set the Height in the Band Properties to 1 px

Hello guys, I am trying to find a way to change page based on a specific value that exist as a field on my table. For instance, I have a list of records where each record has an id and belongs to a Departement (integer values). On each Header page I print the Department code and below I have Column Header and Detail. How can I change page if the Department code changes? I have seen online that I have to use Group By but I did not understand how to implement it. Can someone help me with an example please? Some people mentioned that you could use the Break Element, but yet again I could not implement it. Thank you.