csbac

Hi! What are you trying to to ... Create asynch reports via the web interface, or programmatically? Via the web interface, just follow what I wrote below -- log in as administrator, navigate into the report directory, and click the "run in background", or the "schedule report" icon. Programmatically, I have no idea ... I didn't extend the JS code itself, yet. Yours, Sebastian

Hi! There functionality for this - look in the JS guide: When listing the reports, you have two icons - the first one of a calendar, to run the report on a schedule, the other one of a table with a blue arrow to the right in front of it, to run the report asychronously. Hope this helps, Sebastian

Hi! The best way is to use iReport and the jasperserver plugin ... Then, any image you drag&drop from the JS plugin view onto the report is reference by a repo:... url, which is then used for finding the image when running the report on the server. Of course, this requires the image to be on the server - which it does, anyway, if you want to use it from JasperServer. On the other hand, a repo: URL can't be accessed when you just run the report in iReport, only when running it via the plugin. Sebastian

Hi! I'm not a Jasper developer, yet IMO: If you downloaded it from SourceForge, it's open source and thus the LGPL version. The pro version you can't "just download" there. Sebastian

Hi! Maybe you have this problem: http://jasperforge.org/sf/go/artf2625?nav=1 Was fixed in 2.0.1 ... Sebastian

Hi! On Linux, usually, sh is a link to bash. Seems the sh on solaris is a real sh, possibly an older version, and whoever wrote the startup.sh script used bash, not sh syntax ... works on nearly all systems, but not on all, it seems ... Maybe you can file a bug report, that the script needs to be changed either to bash, or the "substitution" needs to be adjusted to sh syntax? I'd guess the Code: EXEDIR=${0%/*} is the problem ... Yours, Sebastian

csbac wrote: Hi! JFreeChart ChartFactory.createPieChart(String, PieDataset); Sorry, you're right ... I missed the three booleans ... JFreeChart ChartFactory.createPieChart(String, PieDataset, boolean, boolean, boolean); Sure you don't have an older version of jfreechart lying around in your tomcat installation? Seb.

You need to "pass" them on to the sub dataset, by setting the default values of the sub dataset parameters to the values of the main parameters. Hope this helps, Sebastian

It's always this way in SQL. Sebastian.

Hi! If you are using SQL ... any way of converting the string field into a double field in the SQL query already? Otherwise, the only way I see is writing a scriptlet that contains a "non-throwing" conversion function, and deploy the scriptlet together with the report, as svenn already mentioned ... Sebastian

Hi! Just a guess: error=2 means file not found ... is javac on the PATH? Sebastian

Hi! When you use a grouping expression, you need to sort the sql query by this expression ... So, it's Code: SELECT DISTINCT l.accountId, l.eventType, CONCAT_WS(', ',monthname(l.date),year(l.date)) as eventPeriod WHERE (l.eventType = 6 or l.eventType = 12) order by CONCAT_WS(', ',monthname(l.date),year(l.date)) or possibly Code:[code] order by eventPeriod not sure whether mysql supports this .. Sebastian

Alternatively: index.php?option=com_joomlaboard&Itemid=&func=view&catid=8&id=23959 Code:$X{IN, estimate_value, estimatevalues} Sebastian

Hi! Obviously, there is no X11 installed on the Linux machine, and AWT expects to find it ... You might have a try with java.awt.headless http://java.sun.com/developer/technicalArticles/J2SE/Desktop/headless/ , though I'm not sure whether this will help you with such a shared library loading issue ... Hope this helps, Sebastian

Hi! Does it work if you use the simpler query Code: SELECT {[Measures].[unit Sales], [Measures].[store Sales]} ON COLUMNS, {[Time]} ON ROWS FROM [sales] ? Sebastian

Hi! I'd guess you have an old version of apache commons in the server's library/class path ... which version do you find there? Hope this helps, Sebastian

Hi! I'd say you are using the wrong version of the JFreeChart-jar ... probably an older one than JasperReports expects. It's missing the method JFreeChart ChartFactory.createPieChart(String, PieDataset); Which jar do you use? Hope this helps, Sebastian

Hi! Use GROUP BY in the SQL clause(s), I'd say ... Sebastian

Mh ... Usually, NoClassDefFoundError also gives the name of the class that is missing ... The fact that it is on *n*x and the stack trace somewhere in the graphics environment, may point to http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=10&id=30852 this problem? Hope this helps, Sebastian

Hi! You are using Opensuse 10.1, so I assume your shell is a bash ... env unset==DISPLAY won't help you, but export DISPLAY= should. Even env --unset=DISPLAY won't help you, as changes done by env are only applied for the command that is given as a parameter, i.e., none, in this case ... the environment is ony printed. Seb.

Hi! When the applet loaded, have you been asked about trusting the certificate? If not, then the problem is to be found somewhere in the "signing the applet" stuff ... Hope this may help, Sebastian

Mh, seems the problem is with the X11 display ... - at 15:11:15,518, tries to connect to X11 on :0.0, from org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:142) - at 15:11:34,253, gives a NoClassDefFoundError, WITHOUT giving the name of the missing class!, yet again at the same place as above ... org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:142) So, I'd say it is not really a "NoClassDefFoundError", but a problem of not being able to access the X11 server ... and thus, not being able to either initialize the java.awt.Font or the JFreeChart class. When static initialisation code of a Java class throws an exception, this may be passed as a NoClassDefFoundError ... I believe. Try to remove the DISPLAY variable from the environment before starting the tomcat server. Then, Java should be able to recognize a headless (i.e., no X11) situation and cope with it. Possibly, you also need to pass -Djava.awt.headless=true, though I never had to do this when running a JBoss/tomcat on a machine with no X11. (see http://java.sun.com/developer/technicalArticles/J2SE/Desktop/headless/ . Hope this was the problem, Sebastian

I can't tell you what your problem is, yet - iReport 2.0.1 needs Java 1.5.0 or later - setting CLASSPATH to anything ...:path/lib does not work, a folder is only searched for class files, jars need to be added manually all of them. Why do you set any classpath and especially IREPORT_CLASSPATH variable before starting the script? Seb.

no you can't. ETL is for Export, Transform, Loading of data, not OLAP. Seb.

Hi! Have a look here http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=9&id=30669 Hope this helps, Sebastian