prefixDirTemplate = (String)getEnv().get("prefixName");
logger.debug("prefixDirTemplate:"+prefixDirTemplate);
InputStream is = template.open( getCacheDir(prefixDirTemplate) );
logger.debug("Getting Jasper Design from template file ...");
JasperDesign jasperDesign = JRXmlLoader.load(is);
// get datasets
List<JRDesignDataset> datasets = jasperDesign.getDatasetsList();
for (int h =0; h< datasets.size(); h++){
JRDesignDataset designDataset = datasets.get(h);
String datasetName = designDataset.getName();
//get document's dataset
IDataSet dataset = this.dsProxy.getDataSetByLabel(datasetName);
if (dataset != null) {
logger.debug("Found SpagoBI dataset "+datasetName);
//get parameter of type JRDataSource
for(int y=0; y< jasperDesign.getParametersList().size(); y++){
JRParameter parameter = (JRParameter)jasperDesign.getParametersList().get(y);
String paramName = parameter.getName();
if(parameter.getValueClassName().equals("net.sf.jasperreports.engine.JRDataSource")&& paramName.equals(datasetName)){//&& parameter.getName().equals(dataset.getLabel()
//set dataset query value
dataset.loadData();
IDataStore dstore = dataset.getDataStore();