Bean DataSource - Pass Parameter

[arunmadhavan]

Dear All,

Is there any way to pass parameters (from the JSP for running Input Controls page) to Bean data source? I would like to generate data in bean depending on parameters, which is input by user and fill report. Hope any of you guys have faced similar kind of problem and found a solution for that. Appreciate your help in advance.

Regards,

Arun

[lucianc]

You can only do that if the parameters you want to pass to the bean data source are also defined in the report (JRXML). In this case, you can create input controls for the parameters in the report unit, and the user values will be present in the parameters map passed to your ReportDataSourceService.setReportParameterValues(Map parameterValues) implementation.

 

HTH,

Lucian

[arunmadhavan]

Thanks Lucian for the immediate response. Great, it works..

[kemalcakmak]

hi,

i was searching for a solution to a same problem.

 

But sorry, I could not understand your answer. Could you explain how I can use a parameter on my static factory bean?

 

thanks,kemal.

[martynhiemstra]

You nead to create a bean that contains a method. This method must return an instance of ReportDataSourceService.

 

Add this bean to your application-context.xml file.

 

Use this bean as datasource by creating a bean datasource in JasperIntelligence and set the bean name to the name given in your configuration and set the method name to the name given to the method that returns the ReportDataSourceService.

[kemalcakmak]

I dont use jasperIntelligence, the reporting is implemented into a swing gui.

 

On some cases my sql query is not effectual enough.

 

I created a factory class which returns a collection of rows. But the trick is the factory has to return parameter depended rows.

 

Factory code:

 

Code:

public class TPReportFactory {
    public static ArrayList<TPExercisesData> collection =
            new ArrayList<TPExercisesData>();   
    public static void populateCollection(/*String personnr*/){
        /**
         * do some initializations..
         */
    }    
    public static java.util.Collection generateCollection(){
        populateCollection(/*parameter*/);        
        return collection;
    }
}

 

how can i populate the collection with a parameter?

[kemalcakmak]

I dont use jasperIntelligence, the reporting is implemented into a swing gui.

 

On some cases my sql query is not effectual enough.

 

I created a factory class which returns a collection of rows. But the trick is the factory has to return parameter depended rows.

 

Factory code:

 

Code:

public class TPReportFactory {
    public static ArrayList<TPExercisesData> collection =
            new ArrayList<TPExercisesData>();   
    public static void populateCollection(/*String personnr*/){
        /**
         * do some initializations..
         */
    }    
    public static java.util.Collection generateCollection(){
        populateCollection(/*parameter*/);        
        return collection;
    }
}

 

how can i populate the collection with a parameter?

[kemalcakmak]

ok. I found a way to provide custom data source.

may someone is interested in it.

here a link to java sun forum:

 

http://forum.java.sun.com/thread.jspa?threadID=766161&messageID=4368330

[ict-programmer]

Given a class that implements JRDataSource, such as:

import java.util.List;import net.sf.jasperreports.engine.JRDataSource;import net.sf.jasperreports.engine.JRException;import net.sf.jasperreports.engine.JRField;import org.apache.logging.log4j.LogManager;import org.apache.logging.log4j.Logger;import org.joda.time.DateTime;public class TestDataSource implements JRDataSource {    private int index = -1;    private List<TestObject> data;    private Logger logger=LogManager.getLogger();       public EBDataSource(java.sql.Date param) {        logger.debug("Single date parameter submitted: "+param.toString());        data = TestDataConstructor.createBean(param);    }       @Override    public boolean next() throws JRException {    index++;        return (index < data.size());    }       @Override    public Object getFieldValue(JRField field) throws JRException {        Object value = null;        String fieldName = field.getName();        switch (fieldName) {            case "field1":                value = data.get(index).getField1();                break;            case "field2":                value = data.get(index).getField2();                break;        }        return value;    }}[/code]

Note that TestDataConstructor.createBean(param) is a static method to get whatever information you want.  The TestDataSource class above must be called from another class that implements ReportDataSourceService, such as:

import java.util.Map;import net.sf.jasperreports.engine.JRDataSource;import net.sf.jasperreports.engine.JRParameter;import com.jaspersoft.jasperserver.api.metadata.common.service.RepositoryService;import com.jaspersoft.jasperserver.api.metadata.jasperreports.service.ReportDataSourceService;import org.apache.logging.log4j.LogManager;import org.apache.logging.log4j.Logger;public class TestDataSourceService implements ReportDataSourceService {    JRDataSource jrds;    private RepositoryService repository;    private Map propertyMap;    private Logger logger=LogManager.getLogger();       public TestDataSourceService() {        //jrds = new TestDataSource();    }    public TestDataSourceService(JRDataSource ds) {        this.jrds = ds;    }       @Override    public void setReportParameterValues(Map parameterValues) {        for (Object obj : parameterValues.entrySet()) {            logger.debug("Parameter "+obj.toString());        }        jrds = new TestDataSource((java.sql.Date) parameterValues.get("PeriodEndDate"));        parameterValues.put(JRParameter.REPORT_DATA_SOURCE, jrds);    }       @Override    public void closeConnection() {        // Do nothing    }       public Map getPropertyMap() {        return propertyMap;    }    public void setPropertyMap(Map propertyMap) {        this.propertyMap = propertyMap;    }       public RepositoryService getRepository() {    return repository;    }    public void setRepository(RepositoryService repository) {    this.repository = repository;    }}[/code]

The key to passing parameters to a custom datasource is to create the data source after the parameter Map is passed in, and then use that parameter in your bean.

For the sake of completeness, you also need:

import com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.ReportDataSource;import com.jaspersoft.jasperserver.api.metadata.jasperreports.service.ReportDataSourceService;import com.jaspersoft.jasperserver.api.metadata.jasperreports.service.ReportDataSourceServiceFactory;public class TestDataSourceServiceFactory implements ReportDataSourceServiceFactory {       public TestDataSourceServiceFactory() { }       public TestDataSourceService createDataSourceService() {        return new TestDataSourceService();    }       @Override    public ReportDataSourceService createService(ReportDataSource dataSource) {        return new TestDataSourceService();    }}[/code]