csplrj

I can't see the forum link. I can only see the topic heading" :In a HTML Exported Report Line not visible in" and not the details of the message http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=42837 Thanks in advance CSJakharia

Software -------------- JasperReport 3.1.0 IReport 3.1.1 MySQL 5.0 Problem -------------- My SQL Query is SELECT sum(quantity*rate) as itemAmount, `item`,`color`, `fabrication`, `finishedItem`, `image`, `overheads`, `print`, `style`,customer,costId FROM (transcostsheet join mastercustomer on transcostsheet.customer_id=mastercustomer.id) left join (transcostsheetItem join transcustomeritemrate on transcostsheetItem.item_itemId=transcustomeritemrate.item_itemId)on transcostsheet.costId=transcostsheetitem.transCostSheet_costId and transcostsheet.customer_id=transcustomeritemrate.customer_id group by color,fabrication,finishedItem,image,overheads,print,style,customer,item HAVING $X{IN, costId, costIds} but it says "Unknown column$X having clause" Thanks in advance CSJakharia

I have logged that bug CSJakharia

When you speak of latest version do you refer to 3.0 or previous one i.e. 2.0.5? As I am using 2.0.5 Thanks in advance CSJakharia

Can you please provide me the download link as i am not able to find the same at this page http://www.jasperforge.org/index.php?option=com_content&task=section&id=16&Itemid=277 Thanks in advance CSJakharia

Sorry actually it was wrong file The current file is attached over here [file name=jasperReport1.jrxml size=13218] Thanks in advance CSJakharia

I just now read about JasperReport 3.0 release but can't find the download link. Can you please provide us the link for the same? Thanks in advance CSJakharia

We are using latest one i.e. JasperReport 2.0.5 (jasperreports-2.0.5.jar) The Jasperreport jrxml is attached [file name=jasperReport.jrxml size=10410] Thanks in advance CSJakharia

I had exported a report page to HTML but the horizontal line drawn in the page can be displayed in Firefox 2.0 but not in IE 6.0 Please see the attached file for having a look Attached File: [file name=index.htm size=26076] Thanks in advance CSJakharia

Try the below post http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=8&id=31532#31532 Bye for now CSJakharia

Thanks My Problem has been solved I used Edit->Report properties as mentioned by my forum friends Thanks Again CSJakharia

Add Field in Report of type JRBeanCollectionDataSource and add in that Arraylist A, JRBeanCollectionDataSource of Object B and have datasource of subreport as $F{subReportList} Thus your problem should be solved Bye for now Chirag

Thanks for your reply that helped me as I also was facing the same problem. The demo folder is not included in IReport. I am using IReport right from 0.3.1 version till 2 But the demo folder is not included in that distribution.Can you please make appropriate changes in the distribution as this will reduce much of the queries in the forum for users of IReport Please point me if I am downloading the wrong distribution Anyway IReport and Jasperreport is great. Thanks for such a nice product Bye for now CSJakharia

I get this error when I try to open the Report from my Java Application. I know that I have to change the scriptletclass tag in jrxml file What My Query is Is there any method to do the same through IReport Interface? Thanks in advance CSJakharia

I have created 2 reports one is master report and other one is subreport. I am filling up both the reports with the JRDataSource. I have set the datasource expression of the subreport to Code:new JRBeanCollectionDataSource((java.util.List)$F{subReportHashMap}.get($P{Detail}.intValue()==1?"P":"A"«»)) But when I try to run the report it throws Code:[code]classcastException:net.sf.jasperreports.engine.data.JRBeanCollectionDataSource and after some errors Code:[code]net.sf.jasperreports.engine.fill.JRExpressionEvalException:Error Evaluating Expression: Thanks in advance CSJakharia

Make a new Parameter of type JRDataSource and change the datasource expression to that variable Pass the datasource of subreport to main report as parameter and your job is done Bye for now CSJakharia

I have created the master report with subreport inside it. I want the subreport connection/datasource expression to be dynamic i.e. I should be able to use the Connection or DataSource as per the Parameters value so that When i am working with Ireport then it wil use Connection and when i am coding it it will use DataSource So I wrote $P{RunMode}.intValue()==1?$P{REPORT_CONNECTION}:new JRBeanCollectionDataSource($P{subReportParam}) But it throws error saying Incompatible conditional operand Types during compiling I think the error is as we have o choose either datasourceexpression or connectionexpression I think we need some way to specify the expression which will convey whether to use datasourceexpression or connectionexpression Is there any way out Thanks in advance CSJakharia

You have to pass the parameters to the subreport Goto SubReport Properties window by right clicking subreport and then properties In Subreport(Other) Tab Add the Subreport Parameters Click Add Enter param in the SubReport Parameters Name Enter $P{param} in Default Value Expression TextBox Now you can recompile and get started Bye for now CSJakharia

Ireport 1.2.1 I have added java.util.List type of custom field. When i change the query the custom field gets removed and then i have to again add that field There is a checkbox in the report Query Window which blocks the evaluation of the query but i require to evaluate the query as well to maintain the custom fields Can anyone help me how to achieve the same I require this field for Subreport data Thanks in advance CSJakharia

I have my main report filled up with JRBeanCollectionDataSource and have also setted the subreport's DataSource to JRBeanCollectionDataSource that can be passed through parameters. The probs is how to enable the filtering of the data based on the data shown in the Master report. as through direct SQL Query we used to use either where or Having clause Thanks in advance CSJakharia

Thanks will try the same Bye for now CSJakharia

Yes You can definitely create it Open the jrxml file in notepad or any XML editor as it is a simple XML file. You can compile the Jasper through JasperReport APIs Bye for now CSJakharia

I have a querytype of Code:Select * from MasterCustomer Where CustomerTypeId In (5,6,7,8) How to have this parameters parameterized where the number of parameters can be variable Thanks in advance CSJakharia

After going through the code of JasperReport I got the info that we have to use Jakarta Commons BeanUtils. Below is the URL http://jakarta.apache.org/commons/beanutils/apidocs/org/apache/commons/beanutils/package-summary.html#package_description Bye for now CSJakharia

I have used JRBeanCollectionDataSource but the following exception arrives. Code:java.lang.NoSuchMethodException: Unknown property 'PurchasePackingId' at org.apache.commons.beanutils.PropertyUtils.getSimpleProperty(PropertyUtils.java:1157) at org.apache.commons.beanutils.PropertyUtils.getNestedProperty(PropertyUtils.java:754) at org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:783) at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:104) at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getFieldValue(JRAbstractBeanDataSource.java:93) at net.sf.jasperreports.engine.data.JRBeanCollectionDataSource.getFieldValue(JRBeanCollectionDataSource.java:104) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:727) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:980) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:126) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:747) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:663) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) at net.sf.jasperreports.engine.JasperManager.fillReport(JasperManager.java:836) at com.inventory.ReportPurchase.showReportVer6(ReportPurchase.java:142) at com.inventory.ReportPurchase.print(ReportPurchase.java:124) at com.utility.view.ui.mdiMenu.jbutPrintActionPerformed(mdiMenu.java:882) at com.utility.view.ui.mdiMenu.access$1400(mdiMenu.java:19) at com.utility.view.ui.mdiMenu$15.actionPerformed(mdiMenu.java:682) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234) at java.awt.Component.processMouseEvent(Component.java:5488) at javax.swing.JComponent.processMouseEvent(JComponent.java:3126) at java.awt.Component.processEvent(Component.java:5253) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3955) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3803) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1774) at java.awt.Component.dispatchEvent(Component.java:3803) at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) 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) NESTED BY : java.lang.NoSuchMethodException: Unknown property 'PurchasePackingId' at org.apache.commons.beanutils.PropertyUtils.getSimpleProperty(PropertyUtils.java:1157) at org.apache.commons.beanutils.PropertyUtils.getNestedProperty(PropertyUtils.java:754) at org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:783) at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:104) at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getFieldValue(JRAbstractBeanDataSource.java:93) at net.sf.jasperreports.engine.data.JRBeanCollectionDataSource.getFieldValue(JRBeanCollectionDataSource.java:104) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:727) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:980) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:126) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:747) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:663) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) at net.sf.jasperreports.engine.JasperManager.fillReport(JasperManager.java:836) at com.inventory.ReportPurchase.showReportVer6(ReportPurchase.java:142) at com.inventory.ReportPurchase.print(ReportPurchase.java:124) at com.utility.view.ui.mdiMenu.jbutPrintActionPerformed(mdiMenu.java:882) at com.utility.view.ui.mdiMenu.access$1400(mdiMenu.java:19) at com.utility.view.ui.mdiMenu$15.actionPerformed(mdiMenu.java:682) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234) at java.awt.Component.processMouseEvent(Component.java:5488) at javax.swing.JComponent.processMouseEvent(JComponent.java:3126) at java.awt.Component.processEvent(Component.java:5253) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3955) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3803) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1774) at java.awt.Component.dispatchEvent(Component.java:3803) at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) 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) NESTED BY : net.sf.jasperreports.engine.JRException: Error retrieving field value from bean : PurchasePackingId at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:116) at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getFieldValue(JRAbstractBeanDataSource.java:93) at net.sf.jasperreports.engine.data.JRBeanCollectionDataSource.getFieldValue(JRBeanCollectionDataSource.java:104) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:727) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:980) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:126) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:747) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:663) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) at net.sf.jasperreports.engine.JasperManager.fillReport(JasperManager.java:836) at com.inventory.ReportPurchase.showReportVer6(ReportPurchase.java:142) at com.inventory.ReportPurchase.print(ReportPurchase.java:124) at com.utility.view.ui.mdiMenu.jbutPrintActionPerformed(mdiMenu.java:882) at com.utility.view.ui.mdiMenu.access$1400(mdiMenu.java:19) at com.utility.view.ui.mdiMenu$15.actionPerformed(mdiMenu.java:682) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234) at java.awt.Component.processMouseEvent(Component.java:5488) at javax.swing.JComponent.processMouseEvent(JComponent.java:3126) at java.awt.Component.processEvent(Component.java:5253) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3955) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3803) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1774) at java.awt.Component.dispatchEvent(Component.java:3803) at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) 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) Caused by: java.lang.NoSuchMethodException: Unknown property 'PurchasePackingId' at org.apache.commons.beanutils.PropertyUtils.getSimpleProperty(PropertyUtils.java:1157) at org.apache.commons.beanutils.PropertyUtils.getNestedProperty(PropertyUtils.java:754) at org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:783) at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:104) ... 39 more Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException at java.awt.Container.addImpl(Container.java:1015) at java.awt.Container.add(Container.java:351) at com.inventory.ReportPurchase.showReportVer6(ReportPurchase.java:154) at com.inventory.ReportPurchase.print(ReportPurchase.java:124) at com.utility.view.ui.mdiMenu.jbutPrintActionPerformed(mdiMenu.java:882) at com.utility.view.ui.mdiMenu.access$1400(mdiMenu.java:19) at com.utility.view.ui.mdiMenu$15.actionPerformed(mdiMenu.java:682) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234) at java.awt.Component.processMouseEvent(Component.java:5488) at javax.swing.JComponent.processMouseEvent(JComponent.java:3126) at java.awt.Component.processEvent(Component.java:5253) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3955) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3803) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1774) at java.awt.Component.dispatchEvent(Component.java:3803) at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) 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) The bean used is Code:[code]public class ReportPurchaseObject { private int purchasePackingId; private java.sql.Date transDate; private int supplierId; private int productId; private String supplier; private String product; private Double sumOfQuantity; ReportPurchaseObject(int purchasePackingId,java.sql.Date transDate,int supplierId,int productId,String supplier,String product,Double sumOfQuantity) { this.setPurchasePackingId(purchasePackingId); this.setTransDate(transDate); this.setSupplierId(supplierId); this.setProductId(productId); this.setSupplier(supplier); this.setProduct(product); this.setSumOfQuantity(sumOfQuantity); } public int getPurchasePackingId() { return purchasePackingId; } public java.sql.Date getTransDate() { return transDate; } public int getSupplierId() { return supplierId; } public int getProductId() { return productId; } public String getSupplier() { return supplier; } public String getProduct() { return product; } public Double getSumOfQuantity() { return sumOfQuantity; } public void setPurchasePackingId(int purchasePackingId) { this.purchasePackingId = purchasePackingId; } public void setTransDate(java.sql.Date transDate) { this.transDate = transDate; } public void setSupplierId(int supplierId) { this.supplierId = supplierId; } public void setProductId(int productId) { this.productId = productId; } public void setSupplier(String supplier) { this.supplier = supplier; } public void setProduct(String product) { this.product = product; } public void setSumOfQuantity(Double sumOfQuantity) { this.sumOfQuantity = sumOfQuantity; } } Please help me Thanks in advance Bye for now CSJakharia