Jump to content
We've recently updated our Privacy Statement, available here ×

csplrj

Members
 View Profile  See their activity

  • Posts

    26

  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by csplrj

    Collection paramater for IN not working

    in Products

    Posted

    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

    HTML image display (nullpx) still a problem

    in Products

    Posted

    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

    Error loading scriptlet class

    in Products

    Posted

    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

    Error Evaluating Expression:

    in Products

    Posted

    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

    Subreport data to be either Connection or DataSour

    in Products

    Posted

    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

    subreport parameters

    in Products

    Posted

    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

    Adding custom field java.util.List is removed

    in Products

    Posted

    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

    Passing Parameters to subreport custom datasource

    in Products

    Posted

    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

    java.lang.NoSuchMethodException: Unknown property

    in Products

    Posted

    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

×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore