scottward

Found a relevent thread: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=10&id=15023#15023 Is the exporting/importing of schedules fully functional in JI 1.1? Of am I getting this error because its not implemented yet? Thanks, Scott

For some reason, I can export all reports using: ./ji-import-export.sh --export --uri=/reports --export-path=/root/Desktop/jasperintelligence-1.1.0/scripts/ji-catalog --export-file=ji-cat.xml But, I can't export schedules using this command: ./ji-import-export.sh --export --scheduled-jobs=/reports/DailySales --export-path=/root/Desktop/jasperintelligence-1.1.0/scripts/ji-catalog --export-file=ji-cat.xml I get the following output: ExportImportCommand: START scheduled jobs value=/reports/DailySales ExportImportCommand: - running PROD Env mode ExportResource: top of process() ----- Processing Values: mProcessAll=false mProcessUriOnly=false mProcessUserRoleOnly=false mProcessReportJobsOnly=true mProcessNothing=false Exception in thread "main" java.lang.NullPointerException at com.jaspersoft.jasperserver.util.ExportResource.processReportJobs(ExportResource.java:481) at com.jaspersoft.jasperserver.util.ExportResource.process(ExportResource.java:319) at com.jaspersoft.jasperserver.util.ExportImportCommand.runExport(ExportImportCommand.java:170) at com.jaspersoft.jasperserver.util.ExportImportCommand.main(ExportImportCommand.java:102) Unfortunately, there's not much information to go on as far as figuring out what's wrong. All I know is that there's a "NullPointer Exception". Where to from here? Your help is appreciated. Sincerely, Scott

Hello, I have 4 reports associated with anywhere between 20 and 100 stores. I need to set up a schedule for each report for each store (so around 200 schedules). I am NOT excited about doing this by hand using the web interface. How can I automate this? The only idea I have is to write a routine that automatically generates an import file that has all the schedules. Then import that file into JasperIntelligence. Is there a better way? Thanks, Scott

Or another thought: I could make a measure that used SalePeriod as the expression and set the calculation to be Highest. However in the context of each cell, the value is just the highest for that cell, not total. How can I gain access within each cell to a variable that contains the Highest value of SalesPeriod for the entire crosstab?

Hello, I have two crosstabs (monthly sales and percentage change from previous year). Here's the issue: The Year To Date (YTD) column at the end allows us to see how well the store is doing compared to the same period time span but in the previous year. In other words, since our data for 2006 ends in November, the YTD field should contain the total for each previous year up to November. I have a YTDTotal measure defined with an expression like this: ($F{MonthNumber} <= $P{YTDMonth} ? $F{AvgAmount} : 0.0) Currently, I am manually entering a parameter called "YTDMonth". The YTDTotal_Sum measure is printed at the end and shows us where we are at compared to last year. But it ugly to have to manually enter the cutoff month. What I need to do is use a variable to track the last month in the current year for which I have data. That variable should then be used in the YTDTotal measure expression above to calculate the YTD totals for the subsequent years. This is what I've tried: 1) In the sub data set, create a integer, non-incrementing, non calculationg variable called AutoYTDMonth with an initial value of "new java.lang.Integer(0)" 2) Then, in the crosstab, I created a measure by the same name that with an expression that references that variable: $V{AutoYTDMonth} 3) As a test, I place a field in the value cell with a Text Expression of $V{AutoYTDMonth}. It prints null throughout the whole crosstab. I was hoping it would print 0. Then I would find a way to increment it. Maybe something like this: ($F{AvgAmount == null ? null : $V{AutoYTDMonth} = $V{AutoYTDMonth} + 1) So my questions are: 1) Why is $V{AutoYTDMonth} printing as null instead of 0. 2) Will my incrementing scheme work? Thanks! Scotty size=398]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/crosstab_example_2.PNG Post edited by: scottward, at: 2007/01/17 23:21

I need to be able to generate CSV reports using JI. Please, share the details of your patch! Thanks, Scott

I've experienced the same thing on a Windows XP machine.

Took a look at my JasperServer log file. The exception that is thrown when I try to log in via the plugin has to do with: ClassCastException: gnu.mail.handler.TextXml I did some more research which led me to JavaMail and mail.jar (which is in WEB-INF/lib). I thought maybe I needed to upgrade to the latest JavaMail API, but it on the surface it looks like mail.jar is the latest already (1.4). I'm really beyond my depth here. Just trying to piece together the puzzle. Your help is appreciated. Scotty

I've solved the org.acegisecurity.vote.AbstractAclVoter issue. I just needed to upgrade to the Java Virtual Machine to JDK 1.5.0. I am using Fedora Core 6 and this resolved the issue. On a side note, if you are getting a "connection refused" error, double check your context.xml and jasperserver.xml files to make sure that the correct database (jasperserver) and MySQL port (usually 3306) are stipulated. I installed from the WAR file and they weren't right. There's probably a good reason for it, but as a newbie it threw me off for a while. Scotty

Hello, I too have JI 1.1 installed on a remote Linux server. I can log in just fine, but cannot connect with the plugin using IR 1.2.6 or 1.3. ERROR: MEP not complete: cannot reset > I have resolved the above issue. Jasper Server was > running on a Linux virtual machine called > "jasper_report". Most likely, the "_" in the hostname > was an issue. Can you explain this more? I only have one entry in my etc/hosts file: 127.0.0.1 localhost.localdomain localhost Do I need to add an entry? Or am I totally off here? Thanks, Scott

My setup is almost exactly the same, and I am getting the exact same 2 errors. I've solved the permission error for the log file: As the warning at the bottom of this page: http://www.springframework.org/docs/api/org/springframework/web/util/Log4jWebConfigurer.html Make sure that your tomcat5/webapps/jasperserver/WEB-INF/web.xml has: <context-param> <param-name>webAppRootKey</param-name> <param-value>jasperserver.root</param-value> </context-param> Then, in tomcat5/webapps/jasperserver/WEB-INF/classes/log4j.properties, make sure you have: log4j.appender.fileout.File=${jasperserver.root}/WEB-INF/log4j.log or jasperserver.log or whatever you want. Apparently, with Tomcat webapp.root doesn't contain anything which obviously breaks the location directive in log4j.properties. I am wondering if the second problem, (missing org.acegisecurity.vote.AbstractAclVoter) is related? What do you experts out there think? I'll keep plugging away to try to solve the mystery, but any insight would be greatly appreciated. Scotty

OK, if responses aren't coming because I should ask the question somewhere else, please advise. Or if I need to ask it differently, let me know. Scott

Can anybody shed some light on this? It'd be a great help to quite a few of us, I think. Scott

Try using field$P!{NUM}. Not sure of the details, but the ! causes the value to be inserted as a "literal" or something like that. As far as I can figure: If NUM = 2 $P{NUM} will enter '2' into the SQL statement $P!{NUM} will enter 2 into the SQL statement Let us know if this works. Scott

Hello, I need to customize a chart in my report. Just basic things like the range, line colors, position of legend, etc. I understand that I have to use JRChartCustomizer to do this. Unfortunately, I've never programmed a line of java in my life, although I've used other programming languages. As has been pointed out by others, there is no step by step guide for those who are computer literate, but not familiar with java. Over and over, I've read something like, "To customize a chart all you have to do is implement the JRChartCustomizer interface..." Unfortunately, there are still lots of gaps for me. So what I'd like to do is work out a step by step process for the non Java programmer. If you veteran programmers out there could help me along, it will benefit quite a few people I think. OK, here we go. From what I can see, I need to write a custom snippet of code that will modify certain aspects of my chart. You tell iReport which snippet of code is to be used by: a) right clicking on the chart and selecting "Chart Properties" b) entering the name of the JAR file that contains the snippet of code in the field marked: Customizer Class. This is where I get fuzzy! Based on various posts I've put together some java code that I think will stipulate the colors of the first 2 lines on my line chart. Its is called "LineChartCustomizer.java" and the contents are as follows: Code: import net.sf.jasperreports.engine.JRChartCustomizer; import net.sf.jasperreports.engine.JRChartDataset; import net.sf.jasperreports.engine.JRChartPlot; import net.sf.jasperreports.engine.JRChart; import org.jfree.chart.JFreeChart; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.axis.CategoryLabelPositions; import java.awt.*; public class LineChartCustomizer implements JRChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { ChartRenderer renderer = (ChartRenderer) chart.getCategoryPlot().getRenderer(); renderer.setSeriesPaint(0, Color.green); renderer.setSeriesPaint(1, Color.orange); } } Please, advise if there are any problems in the code above. OK, I know this is all BASIC stuff for you Java programmers, but not for the rest of us. Apparently, creating a JAR file requires 2 commands from the command prompt: a) javac LineChartCustomizer.java (which will create LineChartCustomizer.class) b) jar cf LineChartCustomizer (which will create LineChartCustomizer.jar) Then, in iReport you go to Options->Class Path and tell iReport where the LineChartCustomizer.jar file is. Apparently, you can add a single jar file or an entire folder of jar files. Again, please correct my mistakes above. I haven't actually successfully made it through these steps yet! Here is where I am failing: When I run javac LineChartCustomizer.java, I get the following errors: C:Program FilesJasperSoftiReport-1.2.6>javac LineChartCustomizer.java LineChartCustomizer.java:1: package net.sf.jasperreports.engine does not exist import net.sf.jasperreports.engine.JRChartCustomizer; ^ LineChartCustomizer.java:2: package net.sf.jasperreports.engine does not exist import net.sf.jasperreports.engine.JRChartDataset; ^ LineChartCustomizer.java:3: package net.sf.jasperreports.engine does not exist import net.sf.jasperreports.engine.JRChartPlot; ^ LineChartCustomizer.java:4: package net.sf.jasperreports.engine does not exist import net.sf.jasperreports.engine.JRChart; ^ LineChartCustomizer.java:5: package org.jfree.chart does not exist import org.jfree.chart.JFreeChart; ^ LineChartCustomizer.java:6: package org.jfree.chart.renderer.category does not e xist import org.jfree.chart.renderer.category.BarRenderer; ^ LineChartCustomizer.java:7: package org.jfree.chart.axis does not exist import org.jfree.chart.axis.CategoryLabelPositions; ^ LineChartCustomizer.java:11: cannot find symbol symbol: class JRChartCustomizer public class LineChartCustomizer implements JRChartCustomizer { ^ LineChartCustomizer.java:13: cannot find symbol symbol : class JFreeChart location: class LineChartCustomizer public void customize(JFreeChart chart, JRChart jasperChart) { ^ LineChartCustomizer.java:13: cannot find symbol symbol : class JRChart location: class LineChartCustomizer public void customize(JFreeChart chart, JRChart jasperChart) { ^ LineChartCustomizer.java:15: cannot find symbol symbol : class ChartRenderer location: class LineChartCustomizer ChartRenderer renderer = (ChartRenderer) chart.getCategoryPlot() .getRenderer(); ^ LineChartCustomizer.java:15: cannot find symbol symbol : class ChartRenderer location: class LineChartCustomizer ChartRenderer renderer = (ChartRenderer) chart.getCategoryPlot() .getRenderer(); ^ 12 errors C:Program FilesJasperSoftiReport-1.2.6> Clearly, Java has no idea where all the classes that I am importing are located. Without them, the creation of the class file fails. So here are my questions: 1) What do I need to do to successfully compile the class file? 2) After that, do I simply type "jar cf LineChartCustomizer" and the jar file will be ready to go? Or is there more setup required? Thanks for helping out the non-programmers who love iReport and JasperReports! Sincerely, Scott

Ah!!! Dang...now I see. Thanks for sticking with me on that one. I really appreciate it. Works great. Scott

As far as the How To: I do nothing with the "Complile Sources" section. But I have copied over all the files and am starting iReport via iReport.bat as per the rest of the instrctions in the file. Here is what is happening with the plugin: size=361]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/JasperServer2.JPG Thanks for your help! Scott

Environment: - Windows XP SP2 - J2DK 1.5.0_08 - JasperIntelligence 1.0.1 - iReport 1.2.6 - Need anything else? > Did you add the server from the plugin? Nothing happens when click on JasperServer Plugin. > If the plugin opens is all set... It doesn't open. Nothing happens. Do you have an XML file for the JasperServer plugin in the plugin directory of iReport? I don't. Thanks, Scott

Also, I tried setting compatibility to 1.2.5 with no change.

OK, finally figured out that the error "Exception in thread "main" java.lang.UnsupportedClassVersionError: com/jaspersoft/jasperserver/irplugin/IRPlugin (Unsupported major.minor version 49.0)" resulted because I had J2SDK 1.4 instead of 1.5 installed. iReport now loads. HOWEVER, when I click Plugins->JasperServer Plugin, nothing at all happens. When I click on Options->Configure Plugins->JasperServer Plugin->Configure, I get a dialog that says "Hello from plugin". Here are the steps I am taking: 1) Download the file http://kent.dl.sourceforge.net/sourceforge/jasperintel/iReport-plugin-1.0.1_ir126.zip 2) Copy everything from lib to iReport's lib 3) Copy JasperServerIRPlugin-1.0.1_ir126.jar to iReport's lib. 4) Run iReport. Loads fine and plugin appears, but nothing happens when I click on it. JasperServer 1.0.1 is running if that matters. I am running Windows XP and J2DK 1.5. Questions: 1) Is there supposed to be an JasperServer xml file in the plugin directory? 2) What am I doing wrong? Why won't the plugin load? Thanks! Scott

OK, now its getting interesting. I installed downloaded iReport-1.2.4-with-JasperIntelligence-1.0.1-plugin.zip and tried to run iReport version 1.2.4 with the plugin. I got the same exact error as previously posted! So it seems that its not just the new plugin that isn't working for me, its the JasperServer plugin in general that isn't working. From the error: "Exception in thread "main" java.lang.UnsupportedClassVersionError: com/jaspersof t/jasperserver/irplugin/IRPlugin (Unsupported major.minor version 49.0)" What does "Unsupported major.minor version 49.0" mean? Thanks for any insight, Scott

Thanks for helping me with this... I just tried it again to make sure. I copied a total of 18 files as you described over with the same results. When I remove those 18 files, iReport works fine again. Is there nothing that needs to take place with the plugin directory? Do I need to make any adjustments on the JasperServer in order for it to run? Thanks, Scott

Hello, I am painfully aware that this is likely a very basic question. I am just starting out with JasperReports and with Java. I am on a Windows XP machine running IReport 1.2.6 and JasperIntelligence 1.0.1. I've downloaded the files for the plugin as described in this post and copied the files over to the iReport lib directory as instructed in the howto. However, I get the following error once iReport gets to the plugin loading stage: Code:Exception in thread "main" java.lang.UnsupportedClassVersionError: com/jaspersof t/jasperserver/irplugin/IRPlugin (Unsupported major.minor version 49.0) at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:539) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:12 3) at java.net.URLClassLoader.defineClass(URLClassLoader.java:251) at java.net.URLClassLoader.access$100(URLClassLoader.java:55) at java.net.URLClassLoader$1.run(URLClassLoader.java:194) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:187) at java.lang.ClassLoader.loadClass(ClassLoader.java:289) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274) at java.lang.ClassLoader.loadClass(ClassLoader.java:235) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:141) at it.businesslogic.ireport.PluginEntry.getPlugin(PluginEntry.java:110) at it.businesslogic.ireport.gui.MainFrame.loadPlugins(MainFrame.java:955 3) at it.businesslogic.ireport.gui.MainFrame.<init>(MainFrame.java:729) at it.businesslogic.ireport.gui.MainFrame.main(MainFrame.java:7281) Is this because I didn't do anything with step 1 in the how to? I am not really sure what build file to edit and what to do with it. Am I right to think that I don't need to carry out that step since I am launching iReport with iReport.bat instead of iReport.exe? Thanks for your help. Scott

Any help with this?

I too am just learning iReport/Jasper and have the same problem. A crosstab that should take 3 pages to render is duplicating over and over so that it covers 256 pages!