grl

Hi, I have installed jasperserver 6 on my machine. When I installed it, I selected the bundled Tomcat since I wanted to try it out. But I do also have an existing tomcat installation that I would now like jasperserver to use instead of the bundled tomcat. What is the simplest way to do it ? The Installation guide only explains how to select one or the other at installation, not after the jasperserver is installed. Thank you in advance,

I am trying scriptlets for the first time with jasper. I have a variable $V{options} in the sql statement like select state, sum(value) from mytable where locale in ('$V!{options}') group by state; The $V{options} is a String and its expression is value is set to $P{myscriptlet_SCRIPTLET}.getChoices{$P{param}) I also havve a $P{myscriptlet_SCRIPTLET} whose class is the custom based class I implemented. $V{options} is null ...

This question is a duplicate of http://community.jaspersoft.com/questions/843627/please-help-unsupported-majorminor-version-jasperstudio-56x-scriptlet-classes

I found this link to provide the solution: http://community.jaspersoft.com/questions/825226/jaspersoft-studio-macos-failed-create-java-virtual-machine

I have created a simple .jar with a class to process a parameter in my Jasper report via scriptlets. I have added the .jar to the build path of the report project. The .jar has been compiled with JDK 1.7, and the execution enviroment of the Jasper project is set to JRE 1.7, and also the Java Compiler compliance level is 1.7. JAVA_HOME points to jdk 1.7. Still JasperStudio complains of Unsupported major.minor version 51.0 when trying to access the .jar code through the scriptlet parameter. Is JasperStudio using jdk 1.6 ?! To check on this, on a separate report, I included a textfield just to print out the java version being used, and I set the textfield’s expression to System.getProperty("java.version”). It printed 1.6.0_65. There is sth about JasperStudio evidently that still is overriding my jre/jdk choices, but I do not know where/how. Please send me your suggestions on where to look. Thanks a million

I am trying to use a multi axis chart, the column spline from the HTML5 library in JasperStudio. So, I have defined a category, a series, and two measures, but I get the following configuration error: For ColumnSpline chart type, the last measure should be used for spline chart. WHat HighCharts properties should I set so that the last measure is used for spline chart ? ANd how ? I have tried: series.name = name of the last measuressriese.type = spline but that does not work at all, I get same error. I would really appreciate if you could help. Thanks !

anyone has any other suggestion on this issue ? Thanks !

Thank you so much for your answer, but I am still getting the same error ....

If I try to include a parameter in my sql statement select * from table where (...) group by (...) fetch first $P{param} rows only I get the error "mismatched input '$P{param}' expecting RULE_INT" $P{param} should evaluate to an integer, as set by the user. How could this error be avoided ? Thanks !

Thank you. I solved the problem with the zooming/panning feature in highcharts. http://jsfiddle.net/gh/get/jquery/1.7.2/highslide-software/highcharts.com/tree/master/samples/highcharts/chart/pankey/

My problem is that I have a very large data set I need to display in a bar chart. A possible solution is to allow the user to drag/zoom on the chart, and this javascript library seems to accomplish that. But I being relatively new to Jasper, I have never integrated a javascript library in Jasper Reports. Could someone please point to the correct resources ? Does one have to write a custom component ? http://dygraphs.com/tutorial.html Thanks in advance,

I have resolved it, it was an issue with the Measure

My sql query returns counts for a set of states, similarly to this select state, sum(occurrences) as count from myTable, group by state order by count desc. The sql statement appears to be working fine. The counts are very high as expected. Now, using a column bar chart, on the yAxis I am trying to display the counts, but all the report in preview displays on the yAxis is a max of 1.25. I have tried different things to change the max value, but to no avail. I would like to set the yAxis.max to the highest value of the field count. How to do that ?

Good morning, from the docs I have read, the drill down functionality of the HTML5 charts can only be tested on the Jasper Server. Why can't it be tested within JasperStudio when we run a report ? Thanks, G.

Thank you !