rw-network

Since the forums for Jasper Studio are locked, I am going to post this shout out to Jasper 'employees' here. What do I have to do to be able to enter issues for Jasper Studio? When I go to Tracker for that project, I do not have the option to add Issues. And yes, I am logged in. As a related side question, Why are the forums locked? Thanks, Scott

Go to this site and read thru the blog post. Matthew talks about an issue with Japanese characters not coming out correctly. It MAY help you solve your issue. http://mdahlman.wordpress.com/2010/05/28/jaspersoft-v3-7-font-extensions/ Also check out the older blog posts on Fonts. Post Edited by scottj314 at 11/17/2010 14:39

I think there is some confusion happening over the terms. iReport is built on top of Netbeans. Jaspersoft Studio is built on top of Eclipse. Therefore it "IS" the plug-in for Eclipse. For the most part what you can do in the iReport can be done in Jaspersoft Studio. There are still some things missing in Studio, but it is coming. You just need to understand how to translate from the Netbeans way to Eclipse way. Since it sounds like you have experience in Eclipse and some experience in iReport, it should not be too difficult. This page gives a quick overview of Studio: http://jasperforge.org/website/ireportwebsite/JSS%20Website/0.0.1.html?header=project&target=jaspersoftstudio

It is in the works! I was WAY surprised when I stumbled across this. It is still in its early stages, but is making great progress. So, you will have to wait a while if you want to use this for Production purposes. For playing around it is ok. http://jasperforge.org/projects/jaspersoftstudio I am so glad to see the change over to Eclipse. Most of the other software I run is based on Eclipse.

THANKS for that find. He has some good stuff on that blog.

Anyone find a solution to this? I am on 3.7.5 on iReport and when I do a preview in there, the labels do not show in the resulting PDF. BUT when I take that same .jasper report and run it thru JasperReports, the labels show up. Seems to be that charts in 3.7.+ are just down right buggy.

These Input Controls are already in the Repository. Unless I am missing a feature some place, you still have to manually link each Parameter on the report to an Input Control in the Repository. Which brings up another good Feature Request: The ability to drag/drop and/or copy/paste Input Controls from the Repository into the Reporting Unit.

lucianc Wrote: Scott, please log a tracker item for this so we keep it on our radar. Ok, it has been logged: http://jasperforge.org/projects/jasperreports/tracker/view.php?id=4782

lucianc Wrote: The text measurer has been written by someone working on JasperServer. We've been considering moving it into JR. Adding it to JR has our vote. We had a Jasper consultant come in and tell us about it. So, we use it on some reports that are located on JasperServer. The pain is when we need to change these reports. They don't work when ran from iReport because the class is not found. We also run reports on a IBM i5 using JasperReports, so it would be nice to have this performance tweak available for those reports too. Thanks, Scott

"The JasperServer codebase contains a faster text measurer implementation that can be used for non-stretching text elements." Why is this not in JasperReports for use there?

bukkwheat Wrote: Could you post some tips for making this happen in HQL? This is where Google is your friend. I don't know Oracle syntax, but to get it figured out for MS SQL, I just googled for the "terms" in slow's sql statement that did not make sense to me. Then thru trial and error and more googling, I came up with a MS SQL solution. You will most likely have to do the same for HQL.

Get the blow NullPointerException when trying to open the Query window under iReport 3.7.3, This does not seem to happen on all JRXMLs. Seems to be a hit miss thing with no real pattern. Is anyone else getting this? Do you have a work around. Issue Submitted: http://jasperforge.org/projects/ireport/tracker/view.php?id=4757 Code:java.lang.NullPointerException at com.jaspersoft.ireport.designer.data.ReportQueryDialog.jComboBoxQueryTypeActionPerformed(ReportQueryDialog.java:1535) at com.jaspersoft.ireport.designer.data.ReportQueryDialog.access$1100(ReportQueryDialog.java:97) at com.jaspersoft.ireport.designer.data.ReportQueryDialog$7.actionPerformed(ReportQueryDialog.java:996) at javax.swing.JComboBox.fireActionEvent(JComboBox.java:1242) at javax.swing.JComboBox.contentsChanged(JComboBox.java:1313) at javax.swing.AbstractListModel.fireContentsChanged(AbstractListModel.java:100) at javax.swing.DefaultComboBoxModel.setSelectedItem(DefaultComboBoxModel.java:88) at javax.swing.DefaultComboBoxModel.addElement(DefaultComboBoxModel.java:126) at javax.swing.JComboBox.addItem(JComboBox.java:698) at com.jaspersoft.ireport.designer.data.ReportQueryDialog.initAll(ReportQueryDialog.java:186) at com.jaspersoft.ireport.designer.data.ReportQueryDialog.<init>(ReportQueryDialog.java:145) at com.jaspersoft.ireport.designer.menu.EditQueryAction.performAction(EditQueryAction.java:58) at org.openide.util.actions.NodeAction$DelegateAction$1.run(NodeAction.java:581) at org.netbeans.modules.openide.util.ActionsBridge.doPerformAction(ActionsBridge.java:77) at org.openide.util.actions.NodeAction$DelegateAction.actionPerformed(NodeAction.java:577) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.AbstractButton.doClick(AbstractButton.java:357) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1170) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1211) at java.awt.Component.processMouseEvent(Component.java:6038) at javax.swing.JComponent.processMouseEvent(JComponent.java:3260) at java.awt.Component.processEvent(Component.java:5803) at java.awt.Container.processEvent(Container.java:2058) at java.awt.Component.dispatchEventImpl(Component.java:4410) at java.awt.Container.dispatchEventImpl(Container.java:2116) at java.awt.Component.dispatchEvent(Component.java:4240) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916) at java.awt.Container.dispatchEventImpl(Container.java:2102) at java.awt.Window.dispatchEventImpl(Window.java:2429) at java.awt.Component.dispatchEvent(Component.java:4240)[catch] at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160) at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)

Get the blow NullPointerException when trying to open the Query window under iReport 3.7.3, This does not seem to happen on all JRXMLs. Seems to be a hit miss thing with no real pattern. Is anyone else getting this? Do you have a work around. Issue Submitted #4757 Code:java.lang.NullPointerException at com.jaspersoft.ireport.designer.data.ReportQueryDialog.jComboBoxQueryTypeActionPerformed(ReportQueryDialog.java:1535) at com.jaspersoft.ireport.designer.data.ReportQueryDialog.access$1100(ReportQueryDialog.java:97) at com.jaspersoft.ireport.designer.data.ReportQueryDialog$7.actionPerformed(ReportQueryDialog.java:996) at javax.swing.JComboBox.fireActionEvent(JComboBox.java:1242) at javax.swing.JComboBox.contentsChanged(JComboBox.java:1313) at javax.swing.AbstractListModel.fireContentsChanged(AbstractListModel.java:100) at javax.swing.DefaultComboBoxModel.setSelectedItem(DefaultComboBoxModel.java:88) at javax.swing.DefaultComboBoxModel.addElement(DefaultComboBoxModel.java:126) at javax.swing.JComboBox.addItem(JComboBox.java:698) at com.jaspersoft.ireport.designer.data.ReportQueryDialog.initAll(ReportQueryDialog.java:186) at com.jaspersoft.ireport.designer.data.ReportQueryDialog.(ReportQueryDialog.java:145) at com.jaspersoft.ireport.designer.menu.EditQueryAction.performAction(EditQueryAction.java:58) at org.openide.util.actions.NodeAction$DelegateAction$1.run(NodeAction.java:581) at org.netbeans.modules.openide.util.ActionsBridge.doPerformAction(ActionsBridge.java:77) at org.openide.util.actions.NodeAction$DelegateAction.actionPerformed(NodeAction.java:577) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.AbstractButton.doClick(AbstractButton.java:357) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1170) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1211) at java.awt.Component.processMouseEvent(Component.java:6038) at javax.swing.JComponent.processMouseEvent(JComponent.java:3260) at java.awt.Component.processEvent(Component.java:5803) at java.awt.Container.processEvent(Container.java:2058) at java.awt.Component.dispatchEventImpl(Component.java:4410) at java.awt.Container.dispatchEventImpl(Container.java:2116) at java.awt.Component.dispatchEvent(Component.java:4240) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916) at java.awt.Container.dispatchEventImpl(Container.java:2102) at java.awt.Window.dispatchEventImpl(Window.java:2429) at java.awt.Component.dispatchEvent(Component.java:4240)[catch] at java.awt.EventQueue.dispatchEvent(EventQueue.java:599) at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160) at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)[/code]

For the MS SQL people out there. Give this a shot. Create the function found on this website: http://snipplr.com/view/16196/ms-sql-generate-all-date-and-times-between-2-dates/ Then use this query in your jrxml: Code:SELECTstart_date As DATES,DateName(day,start_date) As NUMERIC_DAY,DateName(mm,start_date) As NUMERIC_MONTH,DateName(yyyy,start_date) As NUMERIC_YEAR,DateName(month,start_date) As STRING_MONTH,DateName(weekday,start_date) As STRING_DAY,Case When DateName(weekday,start_date) = 'Sunday' Then 1 Else 0 End as SUNDAYFROM dbo.generateDateTable($P{startdate}, $P{enddate}, 'day', 1) Post Edited by scottj314 at 06/18/2010 16:13

I really like what you have done with your calendar examples. Can you please upload the jrxml files for the last two versions. THANKS!! Post Edited by scottj314 at 06/18/2010 16:08

>>This does raise the question, is there really any need for me to use a prior version for the report jrxmls? Only if I use certain features of 3.7.2? Which ones? Keeping in mind that our purchased software is running 2.0.5... That is the million dollar question. I have used what I thought was 'new' stuff only to find out that it would work in a older version of JasperReports. So, it is very difficult to know what will and will not work. That is why I rely on the Compatibility setting. I expect it to tell me that I am using something that is not supported in a older version, but right now it is totally broken. I resorted to downloading and installing 3.7.0 to get to some sort of stable release.

I am also having an issue with the cell height vs content in excel output. POI may not have the ability to auto adjust the cell height based on content, but why is JasperReports not figuring out the correct cell height before it gets to POI? If Jasper can tell that a given field is going to wrap and isStretchWithOverflow="true" and output is xls, double the cell height passed to POI. Or some complicated formula along those lines. :) Thanks, Scott

Upgraded to iReport 3.7.2. When I try to save to a prior version, I get a "Error saving the JRXML: null" error. I can only save to the latest version. I think no biggie, I will just open the file under the iReport 3.5.3 that is still installed on my PC. The JRXML does not open and there is no error shown. So, I am pretty much dead in the water! I need to back save to 3.5.3 because that is the version of JasperReports we are running right now. I never had a problem back saving before from a new version of iReport. Does anyone have any workarounds or something I can try to get iReport working again back to 3.5.3? Thanks,

I get this same type of error when I trying to save a report to an earlier version of JasperReports for compatibility reasons.

Copying in the updated poi did not work for me either. That is why I asked for clarification on what was done to 'fix' this bug.

I am getting this same error. If you have Excel export working under iReport 3.7.1, can you please better explain what you did to get it working? Thanks Post Edited by scottj314 at 04/09/2010 11:45

Using JasperReport / iReport 3.7.0. I too am seeing an issue with a blank page coming out when using the 'Run to bottom' property on the subreport. When the 'Run to bottom' is true, the footer in the subreport comes out at the bottom of the page, but a blank page comes out after it. When the 'Run to bottom' is false, the footer in the subreport is not at the bottom of the page, but no blank page. Seems to be a bug in using the 'Run to bottom' property. It seems the Footer Position property also causes this 'bug'.

I created a Scriptlet using the code from the sample stuff. The methods do not fire in the order I would expect them to. The Group ones all happen in the beginning. The afterReportInit fires in the beginning too. Is what I am seeing the way it is suppose to be? My issue is that around Page 5 the Group Footers are coming out. I was hoping to set a variable with the name of the group to be used in an expression, but this is a no go. Code:call beforeReportInit call   beforePageInit : PAGE_NUMBER = null call     beforeColumnInit call     beforeGroupInit - Grp_Acct call     beforeGroupInit - Market 3 call     beforeGroupInit - Market 2 call     beforeGroupInit - Market 1 call     afterGroupInit - Market 1 call     afterGroupInit - Market 2 call     afterGroupInit - Market 3 call     afterGroupInit - Grp_Acct call     afterColumnInit call   afterPageInit  : PAGE_NUMBER = 1 call afterReportInit         beforeDetailEval         afterDetailEval         beforeDetailEval         afterDetailEval         beforeDetailEval         afterDetailEval call   beforePageInit : PAGE_NUMBER = 1 call     beforeColumnInit call     afterColumnInit call   afterPageInit  : PAGE_NUMBER = 1         beforeDetailEval         afterDetailEval         beforeDetailEval         afterDetailEval call   beforePageInit : PAGE_NUMBER = 2 call     beforeColumnInit call     afterColumnInit call   afterPageInit  : PAGE_NUMBER = 2 call   beforePageInit : PAGE_NUMBER = 3 call     beforeColumnInit call     afterColumnInit call   afterPageInit  : PAGE_NUMBER = 3 call   beforePageInit : PAGE_NUMBER = 4 call     beforeColumnInit call     afterColumnInit call   afterPageInit  : PAGE_NUMBER = 4 call   beforePageInit : PAGE_NUMBER = 5 call     beforeColumnInit call     afterColumnInit call   afterPageInit  : PAGE_NUMBER = 5 call   beforePageInit : PAGE_NUMBER = 6 call     beforeColumnInit call     afterColumnInit call   afterPageInit  : PAGE_NUMBER = 6 call   beforePageInit : PAGE_NUMBER = 7 call     beforeColumnInit call     afterColumnInit call   afterPageInit  : PAGE_NUMBER = 7Â

Since I run our reports on two different OSs, I was able to use a Java property as a variable to check against. In my case it is iReprot vs JasperReports. I would think that the same concept would work with JasperServer. Code:( System.getProperty("os.name").equals("OS/400") ? "/reports/templates/images/RWLogo1_noTag.png" : "H:\\Jasper\\Logos\\RWLogo1_noTag.png" )

Is this a supported course of action? We have JasperServer Community Edition 3.5 installed. When it first came out, we upgraded the server to use JasperReports to 3.5.3 to get the features in it. Later when a Jasper consultant was on-site, we were told that this was not supported. And we would have to down grade back to the 3.5.1 version of JasperReports in order for him to continue working. -- Scott J.