I' ve implemented the interface JRDATASOURCE in this way (the Vector
resultset is te result of my query and the columns[] is an array whit the
names of columns):
import net.sf.jasperreports.engine.JRDataSource;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JRField;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import java.util.Iterator;
import java.util.Vector;
class JrVectorDataSource implements JRDataSource {
static Log log = LogFactory.getLog(JrVectorDataSource.class);
private Vector resultset = null;
private Iterator iterator = null;
private Object[] row = null;
private String[] columns = null;
protected JrVectorDataSource(Query_Contenitore contenitore) {
this.resultset = contenitore.getVector();
this.iterator = this.resultset.iterator();
this.columns = contenitore.getColumns_Label();
}
public Object getFieldValue(JRField jrField) throws JRException {
String name = jrField.getName();
int column = getColumn(name);
return row[column];
}
public boolean next() throws JRException {
if (iterator.hasNext()) {
row = (Object[]) iterator.next();
//log.warn("row:"+row[0]);
return true;
}
return false;
}
private int getColumn(String name) {
//log.error("row0:"+row[0]+" column name "+name);
int idx = -1;
for (int i = 0; i < columns.length; i++) {
if (columns.equalsIgnoreCase(name)) {
idx = i;
break;
}
}
if (idx < 0) {
log.error("column name " + name + " not found.");
throw new RuntimeException("column name " + name + " not found.");
}
return idx;
}
}
--------------------------------------------------------------------------------------------------
NOW MY PROBLEM IS......That in the method
JAsperFillManager.fillReport(JasperReport istance_jasperreport,HashMap
istance_hashmap,JRDataSource istance_jrdatasource) I can only pass an
istance of JRDataSource an so only one query.
some suggestion ?
I had thought to extend the JAsperFillManager class or to merge the Vectors
that are the results of mine queries
--
View this message in context:
http://www.nabble.com/JasperReports---More--of-one-query-tf2397118.html#a6684372
Sent from the jasperreports-questions mailing list archive at Nabble.com.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
