[Sort and group records by field and print section]

Hi there,

I need to do this in the next 48 hours and it just won't work. somebody please help me out.

I am writing an application for a fishing harbour

I need to create a quarterly and yearly report from a database such that I'll sort and group records by the date of arrival of the

vessel and print the section for every month as attached to the letter. Please help me out because  I really don't know how to go about it

 

[sum Variable shows value of last row in the report]

I have tried that but it still will not work.. it continues to show the value of the last row as the total

[sum Variable shows value of last row in the report]

I created a sum variable to calculate the total of of every column at the end of the page. The variable only shows the value of the final value in the result set. when I try to set the Expression class to java.lang.Double, the compiler throws the error:

Cannot cast String to Double. Attached is a code and a copy of the file..... Somebody  please help me out.......

[Problem calling report in java application]

This is my first time of using this site, how do I read the views and replies. please help me out

[Problem calling report in java application]

I'm trying to call a jasper report in a java application but it gives me the following error.I am using netbeans ide 6.9
and ireport 3.7.3

Below are the errors that I get when I run the code
[EL Info]: 2010-08-12 09:06:49.707--ServerSession(12759798)--EclipseLink, version: Eclipse Persistence Services - 2.0.2.v20100323-r6872
[EL Info]: 2010-08-12 09:06:51.111--ServerSession(12759798)--file:/C:/Users/masterelose/Desktop/current/FHMS/src/_FHMSPU login successful
Data source : net.sf.jasperreports.engine.data.JRBeanCollectionDataSource@b05236
net.sf.jasperreports.engine.JRException: Error retrieving field value from bean : squid_quantity
        at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:123)
        at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getFieldValue(JRAbstractBeanDataSource.java:96)
        at net.sf.jasperreports.engine.data.JRBeanCollectionDataSource.getFieldValue(JRBeanCollectionDataSource.java:100)
        at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:823)
        at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:787)
        at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1478)
        at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:125)
        at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:942)
        at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:860)
        at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:84)
        at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:624)
        at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:605)
        at com.fhms.reporting.ReportManager.showReport(ReportManager.java:25)
        at com.fhms.ui.FHMSMainWindow.reportViewerLinkActionPerformed(FHMSMainWindow.java:355)
        at com.fhms.ui.FHMSMainWindow.access$400(FHMSMainWindow.java:22)
        at com.fhms.ui.FHMSMainWindow$5.actionPerformed(FHMSMainWindow.java:197)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
        at org.jdesktop.swingx.JXHyperlink.fireActionPerformed(JXHyperlink.java:244)
        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.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
        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)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
        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)
Caused by: java.lang.NoSuchMethodException: Unknown property 'squid_quantity' on class 'class com.fhms.details.DailyReturnsDetails'
        at org.apache.commons.beanutils.PropertyUtilsBean.getSimpleProperty(PropertyUtilsBean.java:1313)
        at org.apache.commons.beanutils.PropertyUtilsBean.getNestedProperty(PropertyUtilsBean.java:762)
        at org.apache.commons.beanutils.PropertyUtilsBean.getProperty(PropertyUtilsBean.java:837)
        at org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:426)
        at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:111)
        ... 41 more
BUILD SUCCESSFUL (total time: 1 minute 23 seconds)
 

Code:

Below is the code of the Report managerpackage com.fhms.reporting;import com.fhms.details.DailyReturnsDetails;import java.io.InputStream;import java.util.Collection;import java.util.Map;import net.sf.jasperreports.engine.JRDataSource;import net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperPrint;import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource;import net.sf.jasperreports.view.JasperViewer;public class ReportManager {    private InputStream reportInputStream;    private JasperPrint jasperPrint = new JasperPrint();    private JRDataSource reportDataSource;    private JasperViewer jasperViewer;    public void showReport(Map reportParams, Collection<DailyReturnsDetails> entityJavaBeans, String reportFileName) {        try {            this.reportInputStream = ReportManager.class.getResourceAsStream(reportFileName);            this.reportDataSource = new JRBeanCollectionDataSource(entityJavaBeans);            System.out.println("Data source : " + reportDataSource);        jasperPrint = JasperFillManager.fillReport(reportInputStream, reportParams, reportDataSource);            this.jasperViewer = new JasperViewer(jasperPrint,false);            this.jasperViewer.setVisible(true);        } catch (Exception e) {            e.printStackTrace();        }    }}Below is the code that converts the details of the reportpackage com.fhms.reporting;import com.fhms.details.DailyReturnsDetails;import com.fhms.entities.DailyReturns;import java.util.ArrayList;import java.util.List;public class DailyReturnsConverter{    public static List<DailyReturnsDetails> convertToDetails(List<DailyReturns> listOfDailyReturns)    {        List<DailyReturnsDetails> listOfDailyReturnsDetails = new ArrayList<DailyReturnsDetails>();        for(DailyReturns dailyReturns : listOfDailyReturns)        {            DailyReturnsDetails dailyReturnsDetails = new DailyReturnsDetails();                        dailyReturnsDetails.setDateOfArrival(String.valueOf(dailyReturns.getDateOfArrival()));            dailyReturnsDetails.setVessel(dailyReturns.getVessel());            dailyReturnsDetails.setRedfishQuantity(String.valueOf(dailyReturns.getRedfishQuantity()));            dailyReturnsDetails.setSquidQuantity(String.valueOf(dailyReturns.getSquidQuantity()));            dailyReturnsDetails.setOtherFishesQuantity(String.valueOf(dailyReturns.getOtherFishesQuantity()));            dailyReturnsDetails.setNumberOfCrates(String.valueOf(dailyReturns.getNumberOfCrates()));            dailyReturnsDetails.setNumberOfKilos(String.valueOf(dailyReturns.getNumberOfKilos()));            dailyReturnsDetails.setMetricTonnes(String.valueOf(dailyReturns.getMetricTonnes()));            listOfDailyReturnsDetails.add(dailyReturnsDetails);        }        return listOfDailyReturnsDetails;    }}Below is how I call it behind a hyperlink Map parameters = new HashMap();        ReportManager reportManager = new ReportManager();        List<DailyReturns> listOfDailyReturns = FHMSDatastore.getFHMSDatastore().getAllDailyReturns();        List<DailyReturnsDetails> listOfDailyReturnDetails = DailyReturnsConverter.convertToDetails(listOfDailyReturns);        reportManager.showReport(parameters, listOfDailyReturnDetails,"/com/fhms/reportfiles/DailyReturnsReports_1.jasper");