nicknxswart.nl

Alright just did a new linux installation, created a blank report with only your code and the error that I get: 2023-04-17T17:40:40,510 ERROR SecureExceptionHandlerImpl,pool-9-thread-3:125 - There was an error on the server. Try again or contact site administrators. (Error UID: 2de27cbd-da38-43ba-8204-c01b12afb788). Could not find matching constructor for: java.util.Date(BigDecimal) net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: DAYSINMONTH(new java.util.Date(03/01/2023)) So there is a problem in the linux installation. The steps I did: apt-get updatesudo apt install chromium-browserwget -O jasperserver.run "https:/"chmod +x jasperserver.runsudo ./jasperserver.runufw allow 8080cd /opt/jasperreports-server-cp-8.1.1 ./ctlscript.sh start[/code]Then I call the report by the rest api with a json string cast to the data bundle

I did a clean install on ubuntu 22.04 I have a java.sql.date. So I'm doing: DAYSINMONTH($F{EndDate}) and the EndDate is mapped to a field from a json file with the type java.sql.date. I have both the joda-convert-1.3.1.jar and the joda-time-2.2.jar file in the lib folder. Probably you did not do a linux install right? I will set up a new VPS and install again the latest version and let you know if I have the problem again. If so than the problem is within the linux installer.

Fixed the problem there is a bug in the jasper studio 6.20.1 so I downloaded the 6.20.0 version and now it works.

Hi! I installed jasperserver 8.1.1 and migrated some reports. Only the discrover that the reports on the new server not work because the use build in functions like: DAYSINMONTH. Any advice on how to fix this, is there a bug in server 8.1.1. or are jar files missing that should be in the default installation but are not there?

@lucianc thanks for your reply. If I for example follow https://community.jaspersoft.com/wiki/custom-font-font-extension I cant get the custom front added there because of a bug in the jasper studio 6.20.1 I created a jar file manualy but I do not if it's correct: The jasperreports_extension.properties looks like: net.sf.jasperreports.extension.registry.factory.fonts=net.sf.jasperreports.engine.fonts.SimpleFontExtensionsRegistryFactory net.sf.jasperreports.extension.registry.factory.simple.font.families=net.sf.jasperreports.engine.fonts.SimpleFontExtensionsRegistryFactory net.sf.jasperreports.extension.simple.font.families.calibri=net/sf/jasperreports/fonts/fonts.xml The font.xml like: <?xml version="1.0" encoding="UTF-8"?> <fontFamilies> <fontFamily name="Calibri"> <normal>net/sf/jasperreports/fonts/calibri/calibri.ttf</normal> <bold>net/sf/jasperreports/fonts/calibri/calibrib.ttf</bold> <italic>net/sf/jasperreports/fonts/calibri/calibrii.ttf</italic> <boldItalic>net/sf/jasperreports/fonts/calibri/calibriz.ttf</boldItalic> <pdfEncoding>Identity-H</pdfEncoding> <pdfEmbedded>true</pdfEmbedded> </fontFamily> </fontFamilies> And the fonts are also in the jar. I added this jar file to the WEB-INF/lib folder and restarted the server but if I run the report the font's are not working

Hi! Can you help me setting up the Calibri font on the 8.1.1 community edition. I have this working on a 7.2.0 version but can't get it working on the 8.1.1. I migrated the reports from the 7.2.0 version to the new server that is running 8.1.1. I tried adding the fonts.xml and even a jar file but all not working. Also I don't see any errors in the catalina.out even when I set the ignore font to false. Help would be really great!

When I check the error log I see: 2021-09-16 09:38:22,406 ERROR SecureExceptionHandlerImpl,pool-5-thread-289:116 - There was an error on the server. Try again or contact site administrators. (Error UID: daf28a1e-52a0-4d29-863b-4566a0d7cf3a) 2021-09-16 09:40:03,990 ERROR SecureExceptionHandlerImpl,pool-5-thread-290:116 - There was an error on the server. Try again or contact site administrators. (Error UID: 35507256-efeb-419b-b3ad-26167210cba8) 2021-09-16 09:41:57,231 ERROR SecureExceptionHandlerImpl,pool-5-thread-292:116 - There was an error on the server. Try again or contact site administrators. (Error UID: 1cd808fa-df3f-42b2-b92b-92dbd0b0123f) After that jasperserver stops working and when I go to the url I know see: 502 Bad Gateway Any idea what could cause this crash or how I could find out?

We are using the Rest API to generate a report. There we can set the output format like for example pdf. But in a use case we need to display the report as a image so we are wondering if it would be possilbe to generate a report in a image format like png? Greetz

Did you managed to get the report as an image? can you share on how you did this? We in a use case need a report that is generated by the Rest API as a image instead of PDF.

Try to use en_US

I have a field for example $F{name} and a piece of text in the resource bundle for example like: "Hello my name is: X and I have to say jasper is a great tool!" I would like to have the $F{name} on the X but I can't add the field to the resource bundle because it will then be printed as plain text. Anyone a idea on how to do this?

Again a good question and no answers jaspersoft community.....?

When you want to pash the full json to the sub report you could use: ((net.sf.jasperreports.engine.data.JsonQLDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("*^")

Hi Wim, it's a old post but I have something a bit the same! I want to change the html body background color. Do you have any idea on how to do this from jaspersoft? Greetz

We need to send customized emails, just like reports we tought we could create those reports in Jasper. Then fetch the HTML and use that to send as a email. In this case all the designing takes part in Jasper. Only I did not see a way to insert css in the report and some overhead is generated in the HTML. Does anyone have some experience with this?