bichonfrise74

I'm using the Adhoc Editor of JasperServer PRO. I created a topic in JasperStudio where the sql is simply select createdate, id from table. The createdate has a field type date and the database is running in MySQL 5.0.24. When I create the an adhoc report, I am able to drag the fields. But when I ran the report, I get the error below. This seems to be a weird error and it is referring to the createdate data. Anyone knows how to go around this? com.jaspersoft.jasperserver.api.JSException: DataSetIterator.getObject(Date) returned a class java.util.Date, expecting a java.sql.Date

Thanks anyway.

I have been reading the JasperServer Professional Evaluation Guide and this guide seems to refer a lot to the "JasperServer Professional User Guide". Does anyone know the link where I can find this? Thanks, BichonFrise74

Hi, Thanks! I'll try this out and let you know. It looks like this is the answer to my problem.

I have a parameterized input control where it ask for a value before a report is run. On a specific value, parts of the report (where it needs 2nd or 3rd pages) does not appear. But in iReport, all of the pages show up. Not sure if anyone can help me with this.

What is the difference between series expression and category expression in the bar chart? Why do you have the same value for both items? I tried to emulate your example and it works fine, I just want to know why it works.

Thanks... I've reported this as a bug.

In the Report Wizard -> Design Query, when you try to drag your tables to the right-hand side, if your tables are in Upper Case, then it will report that the table does not exist. Has anyone seen this problem?

I wonder whether if anyone knows where the reports submitted in the report contest are stored? It would be very helpful if there is a consolidated archive of all the sample reports.

Ooops, I meant the linux binary installer (jasperserver-2.1-linux-installer.bin). One would assume that if you said 'no' to the installation of the reports and databases, that it would not install it. Not sure why it is doing this. I checked my MySQL database and I see those databases there eventhough I manually dropped them before I started running the installation. BichonFrise74

Hi, When I was using the automated installation of JasperServer, I noticed that whether I choose the option to install or not to install the sample reports, JasperServer will still install the sample reports and database. Has anyone seen this problem before? If so, how did you fix it so that you can skip the installation of the reports? BichonFrise74

Thanks!

Hi, Is it really necessary to use the MySQL root user in the installation of JasperServer? What are the grant privileges that the JasperServer needs to have so I can just create another user which is specific to JasperServer? Thanks, BichonFrise

Ah okay. Thanks.

When I finish using the iReport Wizard, the error shows up in the iReport logs. Does anyone know what this means? locationFileName does not exisit Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException at com.sun.java.swing.plaf.gtk.Metacity.getNode(Metacity.java:1457) at com.sun.java.swing.plaf.gtk.Metacity.paintButtonBackground(Metacity.java:258) at com.sun.java.swing.plaf.gtk.GTKPainter.paintButtonBackground(GTKPainter.java:321) at javax.swing.plaf.synth.SynthButtonUI.paintBackground(SynthButtonUI.java:184) at javax.swing.plaf.synth.SynthButtonUI.update(SynthButtonUI.java:157) at javax.swing.JComponent.paintComponent(JComponent.java:742) at javax.swing.JComponent.paint(JComponent.java:1005) at javax.swing.JComponent.paintChildren(JComponent.java:842) at javax.swing.JComponent.paint(JComponent.java:1014) at javax.swing.JComponent.paintChildren(JComponent.java:842) at javax.swing.JComponent.paint(JComponent.java:1014) at javax.swing.JComponent.paintChildren(JComponent.java:842) at javax.swing.JComponent.paint(JComponent.java:1014) at javax.swing.JLayeredPane.paint(JLayeredPane.java:559) at javax.swing.JComponent.paintWithOffscreenBuffer(JComponent.java:4963) at javax.swing.JComponent.paintDoubleBuffered(JComponent.java:4916) at javax.swing.JComponent._paintImmediately(JComponent.java:4859) at javax.swing.JComponent.paintImmediately(JComponent.java:4666) at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:451) at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(SystemEventQueueUtilities.java:114) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:461) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)