Passing Map Collection to scripted dataset

Sphatan · 2012-02-17T01:34:29+00:00

Hi I am new to Brrt Reports. I am using Birt 2.6 in eclipse Helios. I am trying to pass a Hasp Map to a scripted data set. MapDAo.java: package Test; public…

Sphatan

Hi I am new to Brrt Reports. 
 
I am using Birt 2.6 in eclipse Helios. 
I am trying to pass a Hasp Map to a scripted data set. 
 
MapDAo.java: 
 
package Test; 
 
public class MapDao { 
 
public MapReport getReportVO(String string) { 
MapReport map = new MapReport(); 
map.addMapReport("identity.FirstName", "Julie"); 
map.addMapReport("identity.LastName", "Chan"); 
 
return map; 
} 
} 
 
My Bean Class-MapReport .java 
 
package Test; 
 
import java.util.HashMap; 
import java.util.Map; 
 
public class MapReport { 
 
 
 
private Map<String, Object> mapReport = new HashMap<String, Object>(); 
 
public Map<String, Object> getMapReport() { 
return mapReport; 
} 
 
public void setMapReport(Map<String, Object> mapReport) { 
this.mapReport = mapReport; 
} 
 
public void addMapReport(String mapKey, Object value) { 
mapReport.put(mapKey, value); 
} 
 
public Object getMapReport(String mapKey) { 
System.out.println("mapReport.get(mapKey)"+mapReport.get(mapKey)); 
return mapReport.get(mapKey); 
} 
 
 
} 
 
in data Source Open function: 
 
util = new Packages.Test.MapDao(); 
 
reportVO=util.getReportVO("Julie"); 
currentrow = 0; 
totalrows=1; 
 
 
if(currentrow){ 
datasetRow["FirstName"] = reportVO.getMapReport("FirstName"); 
datasetRow["LastName"] = reportVO.getMapReport("LastName"); 
 
 
currentrow++; 
return true; 
} 
 
return false; 
 
 
With the above coding I am not able to get anything in my Preview Results. 
 
Thanks,

Find more posts tagged with

Comments

JasonW

What does your fetch method look like?
It should look something like:

if(currentrow < totalrows){
datasetRow["FirstName"] = reportVO.getMapReport("identity.FirstName");
datasetRow["LastName"] = reportVO.getMapReport("identity.LastName");

currentrow++;
return true;
}

return false;

Here are some links to some example scripted data sets:

http://www.eclipse.org/birt/phoenix/examples/scripting/scripteddatasource/
http://www.vogella.de/articles/EclipseBIRT/article.html

Jason

johnw

You need a fetch() method to go with the open() method. And it should go into the Data Set, not the Data Source.

Also, this is a strange issue, but if you do not surround the true and false with () in the fetch method, it will error out.

JasonW

John,

You should not have to surrond the true and false return statements with (). What version do you see that error happening in?

Jason

Sphatan

I placed the below code in the fetch method of the dataset,but still i am not able to see anything in the preview results!!!!!..

if(currentrow<totalrows){
datasetRow["FirstName"] = reportVO.getMapReport("identity.FirstName");
datasetRow["LastName"] = reportVO.getMapReport("identity.LastName");

currentrow++;
return true;
}

return false;

Sphatan

Please Help me out <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/public/style_emoticons/'>http://www.birt-exchange.org/org/forum/public/style_emoticons/</a><#EMO_DIR#>/confused.gif

JasonW

Can you modify the code to print some information like:

if(currentrow<totalrows){

importPackage( Packages.java.io );
out = new PrintWriter( new FileWriter( "c:/temp/fetchevents.txt", true ) );
out.println( "Mp Rep " + reportVO.getMapReport("identity.FirstName"));
out.close();

datasetRow["FirstName"] = reportVO.getMapReport("identity.FirstName");
datasetRow["LastName"] = reportVO.getMapReport("identity.LastName");

Jason

Kosaraju

When ever you try to use the scripted data sources, in the open() script function we import packages just as below

importPackage(Packages.com.myBirt.report);

Now ensure that the report and compiled class/jar file are in the same hierarchy. Report can pick the underlying class only if its in the same location.I have done the same thing and it fetches data appropriately.

Regards,
Naveen.