Error creating Dynamic table using the API

Getting the below error trying to add the dynamic table to the grid. other than the table values. all other elements are adding to the grid. the table columns are displaying. 
 
19:57:14,166 ERROR [STDERR] Oct 22, 2009 7:57:14 PM org.eclipse.birt.data.engine.impl.DataEngineImpl <init> 
INFO: Data Engine starts up 
19:57:15,072 ERROR [STDERR] Oct 22, 2009 7:57:15 PM org.eclipse.birt.report.engine.executor.ExecutionContext evaluate 
SEVERE: org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript expression. Script engine error: ReferenceError: "dataSetRow" is not defined. 
Script source: source, line: 0, text: 
dataSetRow["Week"] 
org.mozilla.javascript.EvaluatorException: org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript expression. Script engine error: ReferenceError: "dataSetRow" is not defined. 
******************************************* 
Report genaration class code: 
******************************************* 
import java.io.IOException; 
import java.io.PrintWriter; 
import java.util.HashMap; 
import java.util.logging.Level; 
import java.util.logging.Logger; 
import javax.servlet.ServletContext; 
import javax.servlet.ServletException; 
import javax.servlet.http.HttpServlet; 
import javax.servlet.http.HttpServletRequest; 
import javax.servlet.http.HttpServletResponse; 
import org.eclipse.birt.report.engine.api.HTMLRenderContext; 
import org.eclipse.birt.report.engine.api.HTMLRenderOption; 
import org.eclipse.birt.report.engine.api.IReportEngine; 
import org.eclipse.birt.report.engine.api.IReportRunnable; 
import org.eclipse.birt.report.engine.api.IRunAndRenderTask; 
import org.eclipse.birt.report.model.api.CellHandle; 
import org.eclipse.birt.report.model.api.DataItemHandle; 
import org.eclipse.birt.report.model.api.DesignElementHandle; 
import org.eclipse.birt.report.model.api.ElementFactory; 
import org.eclipse.birt.report.model.api.GridHandle; 
import org.eclipse.birt.report.model.api.ImageHandle; 
import org.eclipse.birt.report.model.api.LabelHandle; 
import org.eclipse.birt.report.model.api.ReportDesignHandle; 
import org.eclipse.birt.report.model.api.RowHandle; 
import org.eclipse.birt.report.model.api.StructureFactory; 
import org.eclipse.birt.report.model.api.TableHandle; 
import org.eclipse.birt.report.model.api.elements.structures.ComputedColumn; 
 
public class DynamicReport1 extends HttpServlet 
{ 
private static final long serialVersionUID = 1L; 
private IReportEngine birtReportEngine = null; 
protected static Logger logger = Logger.getLogger("org.eclipse.birt"); 
 
public void destroy() 
{ 
super.destroy(); 
BirtEngine.destroyBirtEngine(); 
} 
 
public void doGet(HttpServletRequest req, HttpServletResponse resp) 
throws ServletException, IOException 
{ 
IReportRunnable design; 
resp.setContentType("text/html"); 
 
String reportName = req.getParameter("ReportName"); 
//String[] cols = (String[])req.getParameterMap().get("dyna1"); 
String[] cols = {"Week","Sam","Demo"}; 
 
ServletContext sc = req.getSession().getServletContext(); 
this.birtReportEngine = BirtEngine.getBirtEngine(sc); 
 
HTMLRenderContext renderContext = new HTMLRenderContext(); 
renderContext.setBaseImageURL(req.getContextPath() + "/images"); 
renderContext.setImageDirectory(sc.getRealPath("/images")); 
 
logger.log(Level.FINE, "image directory " + sc.getRealPath("/images")); 
System.out.println("stdout image directory " + sc.getRealPath("/images")); 
 
HashMap contextMap = new HashMap(); 
contextMap.put("HTML_RENDER_CONTEXT", renderContext); 
try 
{ 
design = this.birtReportEngine.openReportDesign(sc.getRealPath("/Reports") + "/" + reportName); 
ReportDesignHandle report = (ReportDesignHandle)design.getDesignHandle(); 
buildReport(cols, report); 
 
IRunAndRenderTask task = this.birtReportEngine.createRunAndRenderTask(design); 
task.setAppContext(contextMap); 
 
HTMLRenderOption options = new HTMLRenderOption(); 
options.setOutputFormat("html"); 
 
options.setOutputStream(resp.getOutputStream()); 
task.setRenderOption(options); 
 
task.run(); 
task.close(); 
} 
catch (Exception e) { 
e.printStackTrace(); 
throw new ServletException(e); 
} 
} 
 
public void buildReport(String[] cols, ReportDesignHandle designHandle) 
{ 
ElementFactory designFactory; 
try { 
CellHandle cell; 
designFactory = designHandle.getElementFactory(); 
 
DesignElementHandle element = designFactory.newSimpleMasterPage( "Page Master" ); //$NON-NLS-1$ 
designHandle.getMasterPages( ).add( element ); 
 
GridHandle grid = designFactory.newGridItem( null, 2 /* cols */, 2 /* row */ ); 
designHandle.getBody( ).add( grid ); 
grid.setWidth( "100%" ); //$NON-NLS-1$ 
 
RowHandle row = (RowHandle) grid.getRows( ).get( 0 ); 
 
ImageHandle image = designFactory.newImage( null ); 
cell = (CellHandle) row.getCells( ).get( 0 ); 
cell.getContent( ).add( image ); 
image.setURL( ""http://www.eclipse.org/birt/phoenix/tutorial/basic/multichip-4.jpg"" ); 
 
LabelHandle label = designFactory.newLabel( null ); 
cell = (CellHandle) row.getCells( ).get( 1 ); 
cell.getContent( ).add( label ); 
label.setText( "Hello, world!" ); //$NON-NLS-1$ 
 
row = (RowHandle) grid.getRows( ).get( 1 ); 
TableHandle table = designFactory.newTableItem("table", 4, 4, 2, 0); 
table.setWidth("50%"); 
 
ComputedColumn cs1; 
for (int i = 0; i < cols.length; i++) { 
cs1 = StructureFactory.createComputedColumn( ); 
cs1.setName(cols); 
cs1.setExpression( "dataSetRow[""+cols[i]+""]" ); 
table.addColumnBinding( cs1, false ); 
} 
 
RowHandle tableheader = (RowHandle)table.getHeader().get(0); 
for (int i = 0; i < cols.length; i++) { 
LabelHandle label1 = designFactory.newLabel(cols); 
label1.setText(cols); 
cell = (CellHandle)tableheader.getCells().get(i); 
cell.getContent().add(label1); 
} 
RowHandle tabledetail = (RowHandle)table.getDetail().get(0); 
for (int i = 0; i < cols.length; i++) { 
cell = (CellHandle)tabledetail.getCells().get(i); 
DataItemHandle data = designFactory.newDataItem("data_" + cols); 
data.setResultSetColumn(cols); 
cell.getContent().add(data); 
} 
cell = (CellHandle) row.getCells( ).get( 0 ); 
cell.getContent( ).add( table ); 
} catch (Exception e) { 
e.printStackTrace(); 
} 
} 
 
public void doPost(HttpServletRequest request, HttpServletResponse response) 
throws ServletException, IOException 
{ 
response.setContentType("text/html"); 
PrintWriter out = response.getWriter(); 
out.println("<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">"); 
out.println("<HTML>"); 
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>"); 
out.println(" <BODY>"); 
out.println(" Post Not Supported"); 
out.println(" </BODY>"); 
out.println("</HTML>"); 
out.flush(); 
out.close(); 
} 
 
public void init() 
throws ServletException 
{ 
BirtEngine.initBirtConfig(); 
} 
}

Find more posts tagged with

Comments

mwilliams

Hi raj_span,

Are you binding the table to the dataSet? One thing you may try is using "row" rather than "dataSetRow". I don't think that'll make a difference because if you have the table bound to the dataSet and the table bindings are named the same as the dataSet field names, you should have access to both calls, but it's worth a shot.