JonReport
-
Posts
8 -
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 JonReport
-
-
Nobody?
Perhaps I misspoke? My request is not clear enough? Please guys a little clarification. -
You, mariuss, make my day !
Your post is just what I needed! Documentation with simple but precise references and a concrete example !
My problem is now fully resolved :).
____________________________________________
For people in the same configuration as me :
Here is my current JAVA :
java -version
java version "1.6.0_27"
OpenJDK Runtime Environment (IcedTea6 1.12.6) (6b27-1.12.6-1ubuntu0.12.04.2)
OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode)
My JasperServer Reports Server is installed on a Ubuntu 12.04 LTS server through a .WAR compiled by me according to the documentation and executed by a Tomcat 6 Server.
In order to increase the JVM memory. I did an
ps -aux | grep java
which allowed me to see that my JVM was configured with a-Xmx128m.
To change the JAVA_OPTS (there are some ways), e.g.:
nano /etc/default/tomcat6
OR (depend of your tomcat version)
nano /etc/default/tomcat7
then add , e.g.:
JAVA_OPTS="-Djava.awt.headless=true -Xms512m -Xmx1024m -XX:PermSize=256m -XX:MaxPermSize=512m -Xss2m -XX:+UseConcMarkSweepGC -XX:+CMSClassUnloadingEnabled"
Then restart tomcat, ... and it works now :) !
-
Dear All,
I use JasperReport Server Community Edition.
I have a MySQL database with a table Project containing a large number of all lines corresponding to a different project.
I would like that every line of my table Project are automatically feed a dropdown menu to filter on a specific project to display only this selected project in my report.
In iReport, I have successfully set up a drop-down menu. For the moment, I did some tests and I have to manually put the title of the project in the pop-up (in iReport).
I tried to execute this test report the server that my end users use. During the execution of the report on my server I do not have a pop-up offering me to enter the name of my project when I have a pop-up when previewing in iReport.
Is this a limitation of the Community Edition or is it just a programming problem of my report ? -
Not finding how to change settings of JVM. I performed a clean install by uninstalling and re-installing completely JasperReport Server and Tomcat.
Now I have no more problems, so I did not do anything special from my point of view in terms of configuration. But I would still like to know for the future and my general knowledge how to change settings of JVM. If a kind soul going around, I'm interested.
My question is resolved in the sense that I have no more problems.Thank you very much to those who took the time to look at my problem.
-
Hello,
I am now almost certain that the configuration of JVM is the solution to my problem. I just really stuck on this step. I can not really passing the parameters -Xms and -Xmx to JVM.
Here is my current JAVA :
java -version
java version "1.6.0_27"
OpenJDK Runtime Environment (IcedTea6 1.12.6) (6b27-1.12.6-1ubuntu0.12.04.2)
OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode) -
Wow, so many answers! It's just great!
My JasperServer Reports Server is installed on a Ubuntu 12.04 LTS server through a .WAR compiled by me according to the documentation and executed by a Tomcat 6 Server.
In order to increase the JVM memory. I did an
ps -aux | grep java
which allowed me to see that my JVM was configured with a-Xmx128m. However I have not found how increase it. What is the magic command line ?
I tried this :
export set JAVA_OPTS="-Xms128m -Xmx512m"
Then restart :
service tomcat6 restart
But when I check with an
ps -aux | grep java
Nothing has changed I'm still-Xmx128m. I think I am doing wrong to apply the settings and check.
The solution to virtualize am also interested, but I would like to have a detailed step by step guide to setup it. It sounds complex but sustainable me.
-
Hello to you all ,
I started in the world of reporting. Here is my problem :
I created a report in iReport . The preview of the report in iReport is going very well , and I can export the results of my report in XLS format without worries. The generated report contains 422 pages ( a little over 10,000 lines of results) 9 columns.
When I upload the same report on my JasperServer Report and executes server, everything is going very well . By cons when exporting to XLS , I always error
An internal server error has occurred. Please contact your system administrator.Details : Handler processing failed ; nested exception is java.lang.OutOfMemoryError : Java heap space
I was fine read, Googled right and left in search of a solution , I can not find anything that solves my problem. But I have a good server core i5 , 16 GB of RAM ... So I do not think short side RAM. I think it's a bad configuration or I have read the solution without the skills to apply it.
I want to say that in other reports, is promptly executed and exports correctenet . My server works perfectly fine otherwise .
Tell me what you need to help me see more clearly and solve my problem :)
Thank you in advance .
Partial results in crosstab
in Products
Posted
Hello everyone,
I met a rather difficult problem to describe but the solution will be simple I think. Let's go!
I have a database with 4 tables:
Imputation:
Hours INT(11)
ToBeBilled TINYINT(1)
Day DATE
Description VARCHAR(256)
Employee:
Name VARCHAR(50)
Firstname VARCHAR(50)
Project:
Name VARCHAR(50)
TimeSheet:
Id INT(11)
I use these 4 tables to create the following crosstab in my report:
Imputation.`Day`, for example 01/01/2014
Employee.`Name`, Employee.`Firstname` : NAME, Firstname
Imputation.`ToBeBilled` : false
Project.Name
Imputation.`ToBeBilled` : true
Project.Name
I use some parameters:
Global_Liste_Projets
Global_Liste_Noms
Here is my SQL query :
So, report generation is going well. But when I read my final report and there is more than one imputation filled in billable or non-billable for a specific date, there is only one imutation which appears! Instead there have several. When I do not crosstab, I see all imputations. So I think my problem is located in my crosstab ?
Has anyone ever had a similar problem?
If I was not clear or missing information, do not hesitate :)
My complet XML: