jgust

Firefox is also reporting a false positive for JasperReports-Library_6.21.2.zip. The virus total report confirms it is clean: https://www.virustotal.com/gui/file/9e5e5394dc7f7a609824d7d9e7374184ee41b5609bf23e8b913067acfb57c26d

If you have a large library of reports what you can do is recompile all of them to make sure that you are not using a feature that has been deprecated. This is what I ran into when upgrading 6.5.x to 6.14.x. By doing this I found a few reports that needed to be fixed. To do that easily I created a "TO_COMPILE" folder in my workspace and then put a copy of all the jrxml files there. In Studio you can navigate to the "TO_COMPILE" folder on the project explorer and select Build Project. You can view any issues on the problems tab. If everything checks out you will not need to make modifications to your existing compiled reports.

I got back into editing more reports today and found that the input parameter text field is back to being half-size and unreadable. I cannot continue to make new workspaces when this happens. Has anybody run into this and is there a permanent solution?

I created a new fresh workspace for 6.21.2. After setting it all up again and restarting Jasper my prompt window has been fixed. Maybe the issue had to do with the 6.10.0 workspace not playing well with 6.21.2?

Yesterday I installed Jaspersoft-Studio-CE_6.21.2_windows_x86_64.zip where I was previously using 6.14.0. I noticed when a report has a java.util.ArrayList parameter that the input window is too small and you cannot read the values. Has anybody run into this? How can I get the input box size corrected? Here is the definition of the parameter.

Raphaël is correct about an XML comment line indicating the JSS and JRL used to create the file but you must look at that line using a text editor that is not Jasper Studio. The reason is that Jasper Studio will update that comment as it opens the file skewing the results. I verified this by opening a 6.14.0 file in a 6.20.6 studio and then looked at the source. Comment in text editor <!-- Created with Jaspersoft Studio version 6.14.0.final using JasperReports Library version 6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f --> After opening on 6.20.6 Studio and looking at the source tab <!-- Created with Jaspersoft Studio version 6.20.6.final using JasperReports Library version 6.20.6-5c96b6aa8a39ac1dc6b6bea4b81168e16dd39231 -->

Update 2023-Dec-28, the company decided not to move forward with the homegrown solution and instead use a 3rd party to do the lion's share of the conversion. They were wonderful. The developer who wrote the conversion tool left and we do not have that source since it never became a supported project.

We had this same issue where our sub-report path would change depending on what environment the report was executed for. Our solution was to write a scriptlet that read a configuration file. We would pass the application to it and in return, it would pass back the full path to the location of the report being executed. Here is an example of our development configuration file: # Modify the JASPER_SUBREPORT_PATH to identify where # japer will look for the sub reports # #files on server JASPER_SUBREPORT_PATH=\\\\server\\project\\DEV\\%APP%\\REPORTS\\TEMPLATES\\ Here is an example of our sub-report expression: $P{JasperUtils_SCRIPTLET}.getSubReportPath( "OCR" )+"AAA3-555-001-1295-PDF-SUB01.jasper" The result of that expression using the development configuration previously mentioned would be: \\server\project\DEV\OCR\REPORTS\TEMPLATES\AAA3-555-001-1295-PDF-SUB01.jasper

Yes, variables can be used inside of other variables. Below is an example where I use three different variables in my $V{Campus Header} variable. I believe the issue you are running into is trying to do a direct translation between Crystal and Jasper. You have to work within the reports' defined expression language. You have three built-in options to choose from (java, groovy, and javascript). You can enhance the report engine to add more. You can get more info about that in JasperReports-Ultimate-Guide-3.pdf

100%, the issue is with the $p!{} parameters. I recommend temporarily removing them and putting valid hard-coded values in their place. Once you have a working version add one $p!{} and make sure it works before moving on. Do this for all three parameters. By the end, you should have a working report.

I don't believe there is a way to determine height based on content. When I was making statements/invoices for customers in Asia and Europe I would put the address in multiple bands due to the issue you are running into. To do that I would make sure NOT to use the page header but instead use a group header to display the address. With the address in the group header, you can have multiple bands each one displaying an address part. GH_1a (name) GH_1b (street) GH_1c (city, principal subdivision) GH_1d (country) If the address belongs to the same country that is sending the document then you can suppress that band.

Please see the sample reference: JasperReports - Styled Text Sample (version 6.20.5) https://jasperreports.sourceforge.net/sample.reference/styledtext/index.html

>> I need to do the recursion from the start date to the end date. Example: >> 2023-06-21 (Initial Date)>> 2023-06-25 (End Date)>> I need to create a table containing:>> 2023-06-21>> 2023-06-22>> 2023-06-23>> 2023-06-24>> 2023-06-25 In Oracle, I would use "CONNECT BY LEVEL" to assist in creating fake rows SELECT extract(YEAR from SYSDATE) - LEVEL + 3 yrFROM DUALCONNECT BY LEVEL <= 7;SELECT trunc(SYSDATE) - LEVEL + 3 dtFROM DUALCONNECT BY LEVEL <= 7;[/code] I'm sure other databases have a similar ability. Another approach and more general would be to create a CTE with a cross join. In the example below fake_rows returns 100 rows. That is then used in MyDate to increment the date. Works great for when I need to create a By Date revenue report and enforce a row for when there is no data on the given date. with fake_rows as ( select a.fr, row_number() over (order by a.fr) as rn from ( SELECT 1 AS fr from dual UNION ALL SELECT 1 from dual UNION ALL SELECT 1 from dual UNION ALL SELECT 1 from dual UNION ALL SELECT 1 from dual UNION ALL SELECT 1 from dual UNION ALL SELECT 1 from dual UNION ALL SELECT 1 from dual UNION ALL SELECT 1 from dual UNION ALL SELECT 1 from dual ) a cross join ( SELECT 1 AS fr from dual UNION ALL SELECT 1 from dual UNION ALL SELECT 1 from dual UNION ALL SELECT 1 from dual UNION ALL SELECT 1 from dual UNION ALL SELECT 1 from dual UNION ALL SELECT 1 from dual UNION ALL SELECT 1 from dual UNION ALL SELECT 1 from dual UNION ALL SELECT 1 from dual ) b), MyDate as ( select sysdate, sysdate + fr.RN as dt, rn from fake_rows fr)select * from mydate;[/code]

From: https://community.jaspersoft.com/sites/default/files/docs/js-jss_8.2.0_user-guide_0.pdf The file you are looking for is located in the Jasper Studio installation folder. If you are using the community version it would be "Jaspersoft Studio.ini".

From: https://community.jaspersoft.com/documentation/jaspersoft%C2%AE-studio/tibco-jaspersoft-studio-user-guide/v820/jss-user-_-getting-started/ The file you are looking for is located in the Jasper Studio installation folder. If you are using the community version it would be "Jaspersoft Studio.ini".