nicknxswart.nl
-
Posts
37 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by nicknxswart.nl
-
-
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.....?
-
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?
-
Hi!
I have a peace of JSON:
"vat_lines": {
"line": [
{
"rate": 0.21,
"amount": 16.00
},
{
"rate": 0.21,
"amount": 16.00
}
]
}I only want to print a band if there are more then 0 objects in the list.
I think it can be done by something with a variable but I cant seem to get it working.
Any tips?
-
You could do:
((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("employee") or
((net.sf.jasperreports.engine.data.JsonQLDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("employee")
Depending if your report data adapter query type is on JSON or jsonql
-
Just making my question a bit more specific, when I run the report in jasperstudio I use a local data source JSON file. When I run the report in production we send a parameter REPORT_DATA with json and then: new java.io.ByteArrayInputStream($P{REPORT_DATA}.getBytes("UTF-8")). So in production we can pass the REPORT_DATA parameter to the subreports and all the data is there. But when we run the report localy the REPORT_DATA contains no data because of the local JSON file. How should we do this that local and in production we could run the report and see it with data?
-
So say that you have a json:
{
"customer": {
"code": "102",
"name": "Jan"
}
}
What if you want to get the "name" from the JSON to display in a report.Normaly in the dataset and query I would set the query path to customer.
But say for example the json looks like:
{
"something": {
"customer": {
"code": "102",
"name": "Jan"
}
}
}I want to fetch the field name to display in the report.
I could set the dataset and query to "something" and the field expression to: customer.name.
Than it will work but what if I don't know and don't care about the parant.
Normaly in xpath I would do //name and it will fetch the field name from the xml.
But now in json I cant get it to work to in the field expression search for the field name.
-
Hi!
I switched from datasource from xml to JSON.
Before I did //name to get the field from the datasource because I do not know the parants of the object.
I want do do the same thing with JSON so I ried ..name and $..name and so on but I cant seem to get it to work.
Any tips?
-
The thing is that S1 is working like a switch so its opening in some cases S2 and in some case it will open a different subreport S3. S2 and S3 know what they will receive xml of json but S1 is stupid and must just pass the data. I can do a parameter tht will proably work.
-
Is there no empty space below them that forces the empty space to the next page? Maybe you can do something with giving the text fields a background collor to check if there going to the next page?
-
So in the footer of the third sub report you placed some text right?
-
Hi!
I have a report with a json data source and a subreport(S1) that opens a nother subreport(S2).
The idea is that S1 is dynamic and is just passing the received data source to the S3.
I know for sure that this is working:
((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource()
But this limits S1 for passing only Json data sources, so I'm looking for a more generic way of passing the data source.
I tried to only send the $P{REPORT_DATA_SOURCE} to S1 and pass it to S2 but this is not working.
Any one a idea on how to pass data to the subreports without specifying that it's JSON?
-
In the setenv.sh I added 2 lines and I hope they work:
JAVA_OPTS="-Xms1024m -Xmx2048m -Xss2m $JAVA_OPTS " # java-memory-settings
export CATALINA_OPTS="-Xms1024M -Xmx2048m" -
Hello, again and still I have the problem that my jasperserver on a Vultr VM breaks after generating around 400 reports.
I want to limit the java heap size but how to do this on a Ubuntu server?
Built in functions not working on 8.1.1
in Products
Posted
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:
Then I call the report by the rest api with a json string cast to the data bundle