Dynamic Content Creation in BIRT

I hope the author gets this comment.

I found this example fits precisely what I need for a major project I have assigned.  The only drawback I have so far is that I don't know how to format the table it generates (right justified, number format, etc.).  

If you have a moment, I could really use your help.

thanks,

Skip Strickland

sstrickland@costco.com

Hi Skip,

The name of the class you are looking for is the StyleHandle class. You can get that class from the DataHandle and LabelHandle classes from this example by using the getPrivateStyle() method. In the example below, the first column will be centered, formatted with 2 decimal places and a colored background.

Hi i am getting the bellow error when try to run this report Exception Close Show Exception Stack Trace Hide Exception Stack Trace Stack Trace: Parameter Close Parameters marked with * are required. Please enter comma delimired lists of columns: Input text Null Value Null Value Please enter comma delimted list of headers: Input text Null Value Null Value Processing, please wait ... Jun 2, 2008 11:50 AM -------------------------------------------------------------------------------- The following items have errors: ReportDesign (id = 1): - There are errors evaluating script "importPackage( Packages.org.eclipse.birt.report.model.api ); reportDesignHandle = reportContext.getReportRunnable().designHandle.getDesignHandle(); elementFactory = reportDesignHandle.getElementFactory() table = elementFactory.newTableItem( null, 3, 1, 1, 1 ); table.setWidth( "80%" ); table.setProperty( "dataSet", "Data Set" );//$NON-NLS-1$ // Header columnHeaderArray = params["columnHeaderList"].value.split(","); header = table.getHeader( ).get( 0 ); for (i = 0; i < columnHeaderArray.length; i++) { tcell = header.getCells( ).get( i ); label = elementFactory.newLabel( null ); label.setText( columnHeaderArray[i]);//$NON-NLS-1$ tcell.getContent( ).add( label ); } //Detail columnNameArray = params["columnNameList"].value.split(","); computedSet = table.getColumnBindings( ); detail = table.getDetail( ).get( 0 ); for (i = 0; i < columnNameArray.length; i++) { cs1 = StructureFactory.createComputedColumn( ); cs1.setName("\"" + columnNameArray[i] + "\""); cs1.setExpression( "dataSetRow[\"" + columnNameArray[i] + "\"]"); computedSet.addItem( cs1 ); tcell = detail.getCells( ).get( i ); data = elementFactory.newDataItem( null ); data.setResultSetColumn("\"" + columnNameArray[i] + "\""); tcell.getContent( ).add( data ); } reportDesignHandle.getBody( ).add( table );":{1}. Error.ScriptEvaluationError ( 1 time(s) ) detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "importPackage( Packages.org.eclipse.birt.report.model.api ); reportDesignHandle = reportContext.getReportRunnable().designHandle.getDesignHandle(); elementFactory = reportDesignHandle.getElementFactory() table = elementFactory.newTableItem( null, 3, 1, 1, 1 ); table.setWidth( "80%" ); table.setProperty( "dataSet", "Data Set" );//$NON-NLS-1$ // Header columnHeaderArray = params["columnHeaderList"].value.split(","); header = table.getHeader( ).get( 0 ); for (i = 0; i < columnHeaderArray.length; i++) { tcell = header.getCells( ).get( i ); label = elementFactory.newLabel( null ); label.setText( columnHeaderArray[i]);//$NON-NLS-1$ tcell.getContent( ).add( label ); } //Detail columnNameArray = params["columnNameList"].value.split(","); computedSet = table.getColumnBindings( ); detail = table.getDetail( ).get( 0 ); for (i = 0; i < columnNameArray.length; i++) { cs1 = StructureFactory.createComputedColumn( ); cs1.setName("\"" + columnNameArray[i] + "\""); cs1.setExpression( "dataSetRow[\"" + columnNameArray[i] + "\"]"); computedSet.addItem( cs1 ); tcell = detail.getCells( ).get( i ); data = elementFactory.newDataItem( null ); data.setResultSetColumn("\"" + columnNameArray[i] + "\""); tcell.getContent( ).add( data ); } reportDesignHandle.getBody( ).add( table );":{1}. at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:584) at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:557) at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleJSInternal(ScriptExecutor.java:61) at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleJS(ScriptExecutor.java:45) at org.eclipse.birt.report.engine.script.internal.ReportScriptExecutor.handleBeforeFactory(ReportScriptExecutor.java:49) at org.eclipse.birt.report.engine.api.impl.EngineTask.startFactory(EngineTask.java:1210) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:84) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:68) at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(Unknown Source) at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(Unknown Source) at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(Unknown Source) at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(Unknown Source) at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(Unknown Source) at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:388) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:283) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.eclipse.birt.report.filter.ViewerFilter.doFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(EclipseErrorReportValve.java:153) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:595)Caused by: org.mozilla.javascript.EvaluatorException: Java class "org.eclipse.birt.report.model.simpleapi.ReportDesign" has no public instance field or method named "table". (#6) at org.mozilla.javascript.DefaultErrorReporter.runtimeError(DefaultErrorReporter.java:109) at org.mozilla.javascript.Context.reportRuntimeError(Context.java:1030) at org.mozilla.javascript.Context.reportRuntimeError(Context.java:1086) at org.mozilla.javascript.Context.reportRuntimeError2(Context.java:1056) at org.mozilla.javascript.JavaMembers.reportMemberNotFound(JavaMembers.java:791) at org.mozilla.javascript.JavaMembers.put(JavaMembers.java:152) at org.mozilla.javascript.NativeJavaObject.put(NativeJavaObject.java:125) at org.mozilla.javascript.ScriptableObject.putProperty(ScriptableObject.java:1656) at org.mozilla.javascript.ScriptRuntime.setName(ScriptRuntime.java:1783) at org.mozilla.javascript.gen.c19._c0(:6) at org.mozilla.javascript.gen.c19.call() at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393) at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834) at org.mozilla.javascript.gen.c19.call() at org.mozilla.javascript.gen.c19.exec() at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:223) at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:578) ... 72 more