BIRT Exchange Forum Feed

Problems with Birt Viewer

Wed, 22 May 2013 08:12:48 +0000

Hello,
i'm building a birt server with apache, I'm trying to launch reports uml and I returned the following error:

org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.
at org.eclipse.birt.report.engine.api.impl.EngineTask.handleFatalExceptions(EngineTask.java:2346)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:277)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:86)
at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)
at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:158)
at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
at org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler.__checkDocumentExists(BirtGetPageActionHandler.java:58)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:119)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:104)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(BirtDocumentProcessor.java:87)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
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:454)
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(BirtSoapMessageDispatcherServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:931)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:897)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:919)
at java.lang.Thread.run(Thread.java:738)
Caused by: java.lang.NoSuchMethodError: org/eclipse/datatools/connectivity/oda/consumer/helper/OdaDriver.(Lorg/eclipse/datatools/connectivity/oda/util/manifest/ExtensionManifest;Ljava/lang/Object;)V
at org.eclipse.birt.data.engine.odaconsumer.Driver.createNewDriverHelper(Driver.java:99)
at org.eclipse.birt.data.engine.odaconsumer.DriverManager.getDriverHelper(DriverManager.java:115)
at org.eclipse.birt.data.engine.odaconsumer.DriverManager.getNewDriverHelper(DriverManager.java:101)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:150)
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:435)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:322)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:153)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:634)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1941)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:249)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:269)
... 54 more
Showing page 1 of

Anyone can help me?

Controlling repeated table header

Wed, 22 May 2013 07:49:20 +0000

Hi,

I'm new to BIRT and I'm using standard BIRT report viewer deployed on a tomcat server. When I export the reports, I get different results regarding to the table header:

1. HTML view: repeated every page (40 rows)
2. XLS: not repeated
3. ODS: repeated every 40 rows

I want to enable repeated table header in the html view, and not in XLS and ODS exported report. I tried to add script to reports' beforeRender method to check output type and set the repeatHeader property accordingly but it's not working. I read the BIRT's table element reference and I found that repeatHeader property is not runtime settable.

What is the correct way to do this?

Birt Viewier inside (integration) Web Application

Wed, 22 May 2013 06:27:33 +0000

Hi ,

I have a requirement to integrate the birt-viewer with my web appication to view the reports.

I know that we can install the birt viewer application in server( as stand alone application ) and use that to view the report from our own web application.

i also know about how we can use birt ReportEngine in the application to view or generate the reports in any specific format(pdf,html.etc....) but that open in the broswer only( not in birt-viewer).

Is there any way to merge birt viewer application inside the our own appliation and use it to view the reports in birt viewer without deploying as other stand alone application. ?

Please guide me to work on that. !!

Chinese Characters missing from report

Wed, 22 May 2013 06:06:31 +0000

Hi All,

The report I am displaying have Chinese character data; I can see it completelty on HTML page.
When I try to export same report in to pdf file. Many characters are missing.

Is that BIRT report issue or PDF Viewer issue?

Thanks in Advance

Trouble with passing basic parameter from one file to another

Wed, 22 May 2013 05:17:45 +0000

Hello,

I am new to BIRT and using the sample database to try and pass a customer number as a parameter from one file to another. I was able to pass the product number through the same method in a different file, but I'm unsuccessful with the customer number.

The error I am getting is...
"+ An exception occurred during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: List
Cannot set the integer value (242) to parameter 1.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot set preparedStatement parameter int value.
SQL error #1:No input parameters.
;
java.sql.SQLException: No input parameters. "

I have checked the types in three locations, and they all seem to match the needed type (integer). I have included the two files I am trying to use.

Any help is appreciated, thanks.

hyperlinktest1.rptdesign (30.57K)
: 2
hyperlinktest2.rptdesign (27.82K)
: 1

Reports on JBoss 5.2 JNDI "env not bound" error

Wed, 22 May 2013 04:28:01 +0000

We have integrated our BIRT reports within our web application. The jndi name is configured, and the integration works fine on Tomcat and Websphere.
While deploying it on Jboss 5.2 we get the error "env not bound". We have given the jndi name as "jdbc/examplejndi".
The rptdesign reports have jndiparameter as "java:comp/env/jdbc/examplejndi" which throws error "env not bound".
The same application works on Jboss 6 and 7 and also on tomcat and websphere.

If I change the jndi configuration in the rptdesign to "java:jdbc/examplejndi", it works on jboss but fails on tomcat and websphere.

The "java:comp/env/jdbc/examplejndi" works on sevlets/jsps/code-base (even on Jboss 5.2), though it fails when we given this setting on rptdesign.

We have copied the birt plugins into WEB-INF/lib, and web.xml defines default parameters for BIRT.

Exception traces gives NullPointerException, which I think ebcause of the default connection if jndi fails.

We have to support tomcat/websphere and jboss, and looking for a common solution. So the possibility of changing the jndi configuration for every deployment is not possible.

I have tried various things available on the web, though I couldnt find any successful solution. It seems the BIRT logs we are using BaseClassLoader, which doesnt specify the context of the application. In tomcat deployment we see BIRT logs showing WebAppClassLoader and displying the context of the application.

Any help will be highly appreciated.

Changing the height and width of the chart using java event handling

Wed, 22 May 2013 04:15:06 +0000

I have a chart.It can be any thing like bar chart,pie chart etc.I want to change the height and width of the chart according to my size before rendering it in the viewer.i want to use java event handling for this.

How to set MaxLength for a Report Parameter

Wed, 22 May 2013 03:40:18 +0000

I created one report parameter for entering "Year" value.I want to restrict 4 digits on that input field.How can i do that??User can only type four digit in that field.Is any configuration or script is available to achieve this??

Embedded Image not working in BIRT4.2.2

Wed, 22 May 2013 03:13:02 +0000

Embedded images in the rptdesign are not getting displayed after 4.2.2 upgrade from birt 3.7.0
Environment:

Windows XP
Weblogic 11g
Oracle 11g
Birt runtime - 4.2.2

Options that we tried :-

1.We have tried with setting URI to the image from javascript , this is working for PDF but not working for HTML

2.We have placed the image in webcontent but still not working

3.We have placed the image in defacult image dir ${birt_home}/report/image - still issue persist

Please suggest the way forward.

Parameter Issue from Report Administration

Wed, 22 May 2013 01:12:31 +0000

Hi,
I have having trouble in passing parameter from report administration in BIRT report. Suppose when i am passing from report administration it automatically get = sign like =2012 when i will pass this value into my report query it will bring nothing, but when i will remove = sign from report parameter like 2012 it will bring results. Any idea how i can remove this = while running parameter from report request page. I am using BIRT 2.3.2 with Maximo 7.5.0.3. Cheers

How to display dynamic text HTML with no formatting

Tue, 21 May 2013 22:48:18 +0000

I am printing some rich text from the database using HTML format dynamic text.

The text is displayed perfectly with color bolding, etc. However, the client wants the text displayed using the same font as the rest of the PO. (ie. no color, bolding, etc)

If I choose auto or somthing other than HTML then I see the formatting codes.

Is there any way the rich text can be displayed with a font of my choosing?

Thanks

Page not found when access https://localhost/birt/frameset?__report=test.rptdesign&sample=my+parameter

Tue, 21 May 2013 22:24:44 +0000

I'm very new to Birt. I tried the eclipse plug-in and played with it, it worked all well. Although I'm struggling with the deployment. I downloaded birt-runtime-2_6_1.zip, unzipped it, copied the WebViewerExample to my jboss deploy directly. I can access the index page, and it says BIRT viewer has been installed, but I cannot access "view Example" page. It gives 404, page not found error. At the same time, the index page doesn't load logo, images. It might be a sign that I didn't indicate the path correctly on some environment variable?

I can't figure out now. Can anybody help on this?

BTW. My jboss deploy directory is a little different from normal jboss/default/deploy. I have a deep path like
JBossATG_build\\dev\jboss_server\\deploy. Does this matter?

Thanks a lot!
Jane

Watermarks

Tue, 21 May 2013 22:03:56 +0000

I've tried a couple watermark addon's but haven't gotten them to work with our BIRT designer embedded in RSA.

Does anyone know how to create a watermark to use conditionally?

I need to have a watermark "Test Invoice" or similar text preferably going diagnolly across the page as a background watermark.

Fail with using JNDI connection

Tue, 21 May 2013 21:54:08 +0000

Hi,

I using a "file.xml" to set the connections attributes. If using all informations on "Data Souce" (driver, url, user, pw), the same of the "file.xml", it works, but the JNDI not work. I need help.

Informations of the tools:

JBOSS JBoss EAP 5.x Runtime Server
Birt Runtime_3.7.1
SGBD Oracle

        
            
                
                    metadataBidiFormatStr
                    ILYNN
                
                
                    disabledMetadataBidiFormatStr
                
                
                    contentBidiFormatStr
                    ILYNN
                
                
                    disabledContentBidiFormatStr
                
            
            java:jdbc/IQOracleDS

Error report:

org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report.
at org.eclipse.birt.report.service.ReportEngineService.throwDummyException(ReportEngineService.java:1106)
at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1326)
at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:158)
at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
at org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler.__checkDocumentExists(BirtGetPageActionHandler.java:58)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:119)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:104)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(BirtDocumentProcessor.java:87)
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:597)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
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:597)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
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:454)
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(BirtSoapMessageDispatcherServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:183)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:599)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:269)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:85)
at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1317)
... 56 more
Caused by: java.lang.NullPointerException
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCDriverManager.java:746)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.registerDriver(JDBCDriverManager.java:903)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:257)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:214)
at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:237)
at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:162)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:407)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:317)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:620)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:80)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1905)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:249)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:260)
... 58 more

Multiple Parameters not passed to sub report

Tue, 21 May 2013 20:38:17 +0000

Dear All,

I am new to birt and spagobi. I have create a birt report with 2 analytical parameter which will run a report that contains crosstab data and in that crosstab i have set a hyperlink to another report which will run the corresponding data for that column value.

Flow report content across multiple page columns

Tue, 21 May 2013 19:38:02 +0000

I'm working on a simple report that has multiple groupings and such. The data shown for each detail section is pretty small, so I'm looking for a way to make better use of a page. What I'd like to do is flow the data from column to column across the page. The details section fits very nicely in about 3in. of space, so taking a standard 8.5x11 sheet of paper, i can fit 2 columns in portrait or 3 columns landscape.

Group A Header   |  Group B Header
Group B Header   |  Details
Details          |  Group B Header
Group B Header   |  Details
Details          |  ....
   |

----page break

Group A Header
...and so on

Is there a way to layout the report in this fashion?

Log all sql queries while running birt in tomcat

Tue, 21 May 2013 18:13:52 +0000

Hi,

I have integrated Birt with my application and it now runs in tomcat.
I now wish to log all my sql queries(in my datasets) in Birt.
Please tell me how can I do this and in which file would Birt print these logs.

Thanks in advance

BIRT4.2.2 Viewer is not working on Linux (2.6)

Tue, 21 May 2013 16:38:17 +0000

We are in the process of upgrading from BIRT3.7.2 to BIRT4.2.2. BIRT Viewer is working fine on Windows application. But after we deploy our application on to Linux(2.6.18-308.8.2.el5) BIRT Viewer is not working. Here are the steps we followed upgrading to BIRT4.2.2:
1) Replaces all BIRT3.7.2 jar files with BIRT4.2.2
2) Replace webcontent/birt directory with BIRT4.2.2 webcontent/birt directory.
3) No Code changes – I believe reports that were developed with BIRT3.7.2 should work with BIRT4.2.2.

We used HTTP Watcher to monitor pocket stream. We see lot of “ERROR_INTERNET_CANNOT_CONNECT” errors.
Screen shot is attached here for your review. This is show stopper for us moving to BIRT4.2.2.

Our application is running on JBOSS7.1.1Final.

Any help is greatly appreciated.

Thanks
Krishna

report parameter not setting with 'setParameterValues'

Tue, 21 May 2013 16:17:43 +0000

I am trying to run a report in a servlet using IRunTask. I am setting the parameter of the report using setParameterValues(hashmap). My report has following types of parameters:

3 multiselect parameters and 3 simple parameters.

My hashmap is like this: HashMap paramValues; This is taking value from a json like below:
"paramvalues":{

"param1":[
"value1"
],
"param2":[
"value2"
],
"param3":[
"value1",
"value2"
]
}

This is giving me an error saying the parameter which are simple are expected to be of 'string' and not java.lang.String. This problem is because the simple parameter is expecting just a string and not an array of string.

The problem now is that i want to set the report parameters all at once using a hashmap. But because of the above error i cant seem to set them all with a single hashmap. The only solution i can think of, is parsing my hashmap in to separate strings for each parameter. Is there any other way where i can do it using a single hashmap or set all the parameters in one shot??

Avinash

Error in Connection Profile

Tue, 21 May 2013 15:54:26 +0000

Hi All,

Can anyone advice on attached error while publishing the BIRT in pdf.

Regards,
Satinder kumar

Dynamic Sorting

Tue, 21 May 2013 15:53:50 +0000

Hi,

One of my report's requirement is to sort some columns dynamically and I know how to do this in BIRT using the Sorting tab from the dataset. But, how can I sort two different columns in BIRT one in Ascending and the other in Descending at the same time ?

For example: if (params["SortBy"].value = "Both")

{
sort by date asc
sort by amount desc

}

Can we do this in BIRT? Would you please give me some insight?

PS: I know that we can do this through SQL but can this be accomplished inside BIRT?

Thanks,
Steve

Table footer

Tue, 21 May 2013 15:47:50 +0000

I am designing a Purchase Order report that has a po and a poline table. If the po has a dozens of lines then the po will require multiple pages. I use a table footer to display the grand total price on the last page.

However, how do I display a different table footer at the bottom of the poline table for the other pages. For example, if I wanted to add a piece of text that says "continued" and a line where the client can add initials, etc. I don't want to use a regular page footer because I don't want it on the "fine print" terms and conditions pages that come at the end of the po.

I am using BIRT 3.7.1

Thanks
Tim

Custom sort: Data Cube

Tue, 21 May 2013 15:13:51 +0000

Hello,

I'm trying to custom an attribute in a date cube, but don't allow me, just sort by default ASC, so, I would like to know if this could be possible ? with some script?.
I mean
by default I got the follow sort
A
B
C
D

But I would like sort like

B
D
C

(No logical sequence.. just custom sequence).
Actually I sorted in my original query but when I use a cube don't keep the original sort.

Thank you!

Need help passing parameters to report from maximo.

Tue, 21 May 2013 15:10:41 +0000

Hello,

I need to know how to create a birt report such that when the user clicks on the direct print icon in maximo, that the list of work orders belonging to the current data set is passed to the birt report and then each work order page is created for printing...

How is it different than writing a report where you specify the input parameter that get passed to the sql?

Thanks!

How do I override a style I'm using from a library?

Tue, 21 May 2013 14:55:20 +0000

I have a library with the default "table-detail-cell" style in it. I am using the library in my report. I am using it in my report because I want all my table cells to have borders. However, there are a couple table detail cells that I do not want a border. How would I override the "table-detail-cell" style for those specific cells? I tried applying another style to override it, but that didn't work.

Values not displayed in detail row?

Tue, 21 May 2013 13:51:04 +0000

Greetings BIRT Experts!

I have a couple of columns in a report where decimal values should be displayed but the rows are blank. Another table is joined off of this table and the correct text values are rendered.

I have double-checked the Information Object and all appears to be correct.

Can you provide some direction regarding the best way to debug this situation?

Thanks!
Andrew

Bar/Area Chart - Pattern Fill - Higher DPI Scaling

Tue, 21 May 2013 13:26:57 +0000

Hi,
I have a BIRT chart with a bar graph which is filled with a pattern.
The default Image DPI of 96 provides me with the correct size and scale for the pattern, but this dpi is not enough for printing needs. The moment I increase the Image dpi (Chart / Advanced properties )to 300, the pattern becomes smaller and virtually indistinguishable.

Is there a way we can provide a better pattern of higher scale(instead of 8x8 that designer provides). I am assuming the Bitmap tag represents this pattern and maybe there is a way to provide it.

If not, is there any other workaround to make the predefined pattern scale. In designer it looks good, but in the webviewer, it changes. See Attached image comparing results with designer mode.
Below is the palette definition is have.

-1085102596360827121

100
0
0
255

100
153
204
255

Regards
Joseph

query called multiple times

Tue, 21 May 2013 12:54:22 +0000

Hi all,

I have suddenly noticed that when I have a query that contains an error in runs 46 times.
and each time it returns with the same error message.

The reason that I noticed it is that in some cases that cause the connection to my DB to drop and therefor I can't display any part of my report.

I'm using birt 4.2.1 and Postgresql 9.1

When I'm running the report I see this error message in the Postgresql log file:

2013-03-24 17:01:48 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT:  select age1 from test1
2013-03-24 17:01:48 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT:  select age1 from test1
2013-03-24 17:01:48 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT:  select age1 from test1
2013-03-24 17:01:48 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT:  select age1 from test1
2013-03-24 17:01:48 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT:  select age1 from test1
2013-03-24 17:01:48 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT:  select age1 from test1
2013-03-24 17:01:48 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT:  select age1 from test1
2013-03-24 17:01:48 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT:  select age1 from test1
2013-03-24 17:01:48 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT:  select age1 from test1
2013-03-24 17:01:48 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT:  select age1 from test1
2013-03-24 17:01:48 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT:  select age1 from test1
2013-03-24 17:01:48 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT:  select age1 from test1
2013-03-24 17:01:48 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT:  select age1 from test1
2013-03-24 17:01:48 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT:  select age1 from test1
2013-03-24 17:01:48 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT:  select age1 from test1
2013-03-24 17:01:48 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:06 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:06 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:06 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:06 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:06 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:06 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:06 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:06 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:06 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:06 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:06 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:06 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:06 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:06 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:06 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:06 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:08 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:08 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:08 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:08 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:08 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:08 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:34 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:34 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:34 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:34 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:34 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:34 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:34 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:34 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:34 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:34 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:35 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:35 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:35 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:35 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:35 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:35 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:37 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:37 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:37 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:37 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:37 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:37 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:38 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:38 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:38 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:38 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:38 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:38 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:46 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:46 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:46 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:46 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:46 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:46 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:46 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:46 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:46 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:46 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:46 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:46 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:47 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:47 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:47 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:47 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:47 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT:  select age1 from test1
2013-03-24 17:02:47 IST ERROR:  column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT:  select age1 from test1

This is the message that I got when the connection to the DB was drooped.

IST FATAL:  sorry, too many clients already

And finally this is the query that I used (I know that it's incorrect, but I'm using it to show that birt tries to call it many time and gets the same error message).
Query:

select age1 from test1

Please help me to figer out how can I fix this issue so that I will not have issue with drooping the connection to the DB when I have an error in one of my SQL queries.

Thanks, Shlomi

Expression Builder on computed columns

Tue, 21 May 2013 11:42:24 +0000

Is there any limitation to use multiple conditions in Expression Builder for computed columns?
I am trying to create a computed column as

row["cts3TestLifecycle"] == "To Be Started" && row["cts3RiskFailedTest"] == "High"

But I do not obtain any result.

Thanks.

Export to pdf from webviewer

Tue, 21 May 2013 09:03:33 +0000

Hi All,

Need help to export to pdf format from currenlty displayed report.

I am using eclipse view to display the browser control.I have configured "run" servlet.

My requirement is to export the currently displayed report.

I have the idea about frameset servlet but i need to use run servlet to display the report.

As a workaround i have created a toolbar action for the view and clicking the icon i am creating runandrendertask to render the output to pdf. But this was export has to do the business logic processing to generate the report.

Is there any way to export from the currently displayed report using run servlet only.

Thanks,
Sridhar

JVM crashes when generating PDF file

Tue, 21 May 2013 08:54:01 +0000

Helo all...

I'm getting an error when generating a PDG using BIRT Framework.

The error happens in Java JVM. The log I'm getting:

 #
    # A fatal error has been detected by the Java Runtime Environment:
    #
    #  EXCEPTION_IN_PAGE_ERROR (0xc0000006) at pc=0x0190f0be, pid=5848, tid=2392
    #
    # JRE version: 7.0_09-b05
    # Java VM: Java HotSpot(TM) Client VM (23.5-b02 mixed mode, sharing windows-x86 )
    **# Problematic frame:
    # J  java.nio.MappedByteBuffer.load()Ljava/nio/MappedByteBuffer;**
    #
    # Failed to write core dump. Minidumps are not enabled by default on client versions of Windows
    #
    # An error report file with more information is saved as:
    # C:\Users\luis\Desktop\teste\birt\hs_err_pid5848.log
    #
    # If you would like to submit a bug report, please visit:
    #   http://bugreport.sun.com/bugreport/crash.jsp
    #

The code I'm using to generate the PDF is as follows:

EngineConfig config = new EngineConfig();
   config.setEngineHome("C:\\BIRT\\birt-runtime-4_2_2\\ReportEngine");
   config.setLogConfig("C:/BIRT/logs", Level.FINE);

   Platform.startup(config);
   final IReportEngineFactory FACTORY = (IReportEngineFactory) Platform.createFactoryObject(IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY); 
   IReportEngine engine = FACTORY.createReportEngine(config);
   engine.changeLogLevel(Level.WARNING);

    // Open the report design
    final IReportRunnable DESIGN = engine.openReportDesign("C:\\birt\\src\\report.rptdesign"); 
    final IRunAndRenderTask TASK = engine.createRunAndRenderTask(DESIGN); 
    TASK.setParameterValues(PARAMETERS);
    TASK.validateParameters();

    final PDFRenderOption HTML_OPTIONS = new PDFRenderOption();
    HTML_OPTIONS.setOutputFileName("C:/birt/output.pdf");
    HTML_OPTIONS.setOutputFormat("pdf");

    TASK.setRenderOption(HTML_OPTIONS);
    TASK.run();
    TASK.close();
    engine.shutdown();
    Platform.shutdown();

Thank you all. Regards

Center body between header&footer of mp

Tue, 21 May 2013 08:25:06 +0000

Hi,

I'm using Birt 2.6.2 with Javascript.

I've a report with fixed layout, using a masterpage with header and footer,
I try to center the content of the body (a grid) between header and footer.

But in the pdf the grid of the body is always close under the header and leaves much empty space to the footer.

Like this example left. The example right is what I need :

###############            ###############
HEADER                     HEADER
###############            ###############
-------------
a grid with 
rows and cells
-------------                             
                           -------------
                     >>    a grid with
                     >>    rows and cells
                           -------------




###############            ###############
FOORTER                    FOORTER
###############            ###############

How can i reach that the empty space between header/grid & grid/footer is the same?

regards
germobirt

Remove Title "BIRT Report Viewer"

Tue, 21 May 2013 06:36:01 +0000

Hi I am trying to remove the header "BIRT report viewer" and the footer.
I am deploying BIRT to Eclipse Rich Client Platform. You can see the Attachment it is a scan of the print out.

This is the java code

public void createPartControl(Composite parent) {
Composite container = toolkit.createComposite(parent, SWT.NONE);
toolkit.paintBordersFor(container);
container.setLayout(new FillLayout(SWT.HORIZONTAL));

try {
Bundle bundle = Platform.getBundle("com.hourglass.erp.reports");
URL url = FileLocator.find(bundle, new Path(
"reports/saleOrder.rptdesign"), null);
path = FileLocator.toFileURL(url).getPath();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.print(path.toString());

Browser browser = new Browser(container, SWT.NONE);
toolkit.adapt(browser);
toolkit.paintBordersFor(browser);
browser.addOpenWindowListener(new OpenWindowListener()
{
public void open(WindowEvent event)
{
new EmbeddedBrowser(event,
Display.getCurrent().getActiveShell());
}
});
// Use the filename of your report
WebViewer.display(path, WebViewer.HTML, browser, "frameset");

createActions();
initializeToolBar();
initializeMenu();
}

I have read other posts but i am not using jsp pages.. how can I change the URL parameter __title=.??
Please Help.

Redirect the output from Javascript to display Graph

Tue, 21 May 2013 06:10:55 +0000

Hi,

I have written a function in afterFactory event to fetch the data and do some calculations based on the creation date. After I finish all my calculations, I set the values to globalvariable...

reportContext.setPersistentGlobalVariable("Jan_Count", jan_count) ;
reportContext.setPersistentGlobalVariable("Feb_Count", feb_Count) ;
reportContext.setPersistentGlobalVariable("Mar_Count", mar_Count) ;
reportContext.setPersistentGlobalVariable("Apr_Count", apr_Count) ;
reportContext.setPersistentGlobalVariable("May_Count", may_count) ;
...
...
...

Now... I want to display the bar graph using the data...
Is there any method where i can get the persistent global variable data and create a chart...

Please give me some suggestion or point me to some documentation where I can take forward...

Thanks In advance...
Trilok

Column binding, display multiple records

Tue, 21 May 2013 06:03:39 +0000

Hi,

I am trying to display multiple records in a table column.

I have two tables X and Y. X table has hasMany relationship with Y table.

X table has below attributes:
1.Status
2.Type
3.CompletionTime

Y table has below attributes:
1.Y-Type
2.CreatedCount
3.UpdatedCount

I want to display all the records(Y) that are associated for each X record in same row.
Result table column names are 'Status','Type','CompletionTime','Y-data'. In 'Y-data' column I want to display records from Y table like below:

Y-Type:STS
CreatedCount:2
UpdatedCount:1
Y-Type:TST
CreatedCount:4
UpdatedCount:3

I have added column binding to Y-data column, and bind a data set which is returning multiple records(from Y table) based on X id, but report is displaying only one record

Please suggest me on this.

This is my first post and I am very new to birt report, please let me know if I miss any thing

Thanks

how to compare a month by html button

Tue, 21 May 2013 04:34:46 +0000

hi...

my question is how to compare a this month and last month and then this year and last year ....
in html button

first of all how to get date field for this month and last month and then how can i able compare

by click of html button

can u able to create sampledb for this..

kindly help me...

thank in advance

Performance issue with XML data source as input stream during report generation

Tue, 21 May 2013 04:17:09 +0000

Hi,

i am facing performance issue with BIRT report generation. i have given input as InputStream object and this stream is referred to XML content which is nested in DB as CLOB object.

For report generation, it is taking around 5 minutes of time to process where i have 5000 records information in XML content. However i may need to process 50k records of XML content which will go beyond the accepted time.

Can some one tell me how to achieve it. Is there any alternative way to provide input data smoothly without causing any performance implications.

What are the steps to run Birt latest in Eclipse Juno

Tue, 21 May 2013 04:15:15 +0000

Hi,

I am try to run my birt report in Birt 4.2.0 runtime environment. But I have run birt in Eclipse Galileo with JSF 1.2. But how can i run the same report in the new birt environment. I am very confused. So please let me know what are the necessary configurations should be done when run the Birt 4.2.0 with Eclipse Juno and Jboss 6.1.0 final. My birt supporting libraries are placed in the lib folder under Jboss 6.1.0 final server. When i need to change that location or any other configuration should be done to run that Report. I don't know whether i need to use Viewer to see report. In my old version i am using tag to show the report in the JSF page. Then here i don't know how to show that report in the JSF page. Can you help me to trigger out this issue. I am very suffered due to this issue. Thanks in advance. And one more doubt In my older version i am passing parameter through tag to birt report. But now i can't. Instead of passing parameter i will pass that parameter into the map and i will pass that map to the report. And one more thing through java code only we need to initialize Birt Engine and passing parameters. Is any other easy way to show using JSF page itself like older version? Let me know about this Birt 4.2.0 latest version. I have attached my method which is used to Intialize or create this birt right. I am passed 4 parameters in this method. One is Map which is used to passes parameter using map. Second one is Path of the report design page. Third one is format which is used to create that report like pdf, html, xls. Fourth one is filename which is used to create attachment with that filename.

java code for Birt report.txt (3.02K)
: 2

Displays HTML entities

Tue, 21 May 2013 04:10:14 +0000

I'm using below Java code to display Birt HTML format report in the App., but I see HTML entities also getting displayed:

Note: In the Birt design file, table is generated dynamically from the event handler (Java file).

Please check the attachment for the ERROR.
Let me know what more information you require for the resolution.

design = mspReportEngine.openReportDesign(getServletContext().getRealPath("/WEB-INF/") + File.separator + "reports" + File.separator + ReportUtils.getReportDesignFile(parameters, report));

IRunAndRenderTask task = mspReportEngine.createRunAndRenderTask(design);

task.getAppContext().put(EngineConstants.APPCONTEXT_CLASSLOADER_KEY, ReportController.class.getClassLoader());

if (AuthenticationContext.hasPermission("TICKETS_MANAGE")) {
parameters.put("canCreateTickets", "true");
}

parameters.put("varLogo", varLogo);

if (media.equalsIgnoreCase("pdf") || media.equalsIgnoreCase("ppt") ) {
parameters.put("logoData", getImageInBytes(varLogo, msp));
} else {
parameters.put("logoData", "no-logo".getBytes());
}

String completeFilename=downloadName.trim()+"_"+clientId+"_"+".html";
String completeRptDocumentFilename=downloadName.trim()+"_"+clientId+"_"+".rptdocument";

String fileAbsolutePath="/tmp/"+completeFilename;
String rptDocumentAbsolutePath="/tmp/"+completeRptDocumentFilename;

Enumeration keys = parameters.keys();
while (keys.hasMoreElements()) {
String key = keys.nextElement().toString();
task.setParameterValue(key, parameters.get(key));
}
task.setParameterValue("reportType", reportName);
task.setParameterValue("media", media);

HTMLRenderOption options = new HTMLRenderOption();
options.setOutputFormat("html");
options.setImageHandler(new HTMLServerImageHandler());
options.setSupportedImageFormats("JPG;PNG;BMP;SVG;GIF");
out = response.getOutputStream();
options.setOutputStream(out);
((HTMLRenderOption) options).setBaseImageURL(request.getContextPath() + "/Images");
((HTMLRenderOption) options).setImageDirectory(sc.getRealPath("/Images"));
task.setRenderOption(options);
task.run();
task.close();

Table rendering, setting border-collapse

Tue, 21 May 2013 02:35:14 +0000

Is there a way to specify border-collapse in the Designer or the *.rptdesign document for tables?

The table is always rendered as border-collapse:collapse.
I didn't find any way to set it to separate or leave it empty.

Bernd

Problem, skipping header on 1st page still uses header space

Tue, 21 May 2013 01:28:20 +0000

I'm able to not display a report header on the first page by simply not selecting the "Show header on first" option; however, the first page is shifted down by the amount of header on the rest of the pages in the report.

Does anyone know how to prevent the first page from beginning below the space the header consumes. For example, I have a header with height of .9 inches. It contains a Grid of .9 inches. The header is not displayed on the first page; however, the first page contents begins .9 inches down from the margin.

Many thanks for the answer.

Exception: Cannot fetch the next data row

Tue, 21 May 2013 01:26:28 +0000

Hi,

Am using BIRT 3.7.0

I have a JDBC DataSet. If the SQL query in the dataset returns 0 rows BIRT throws the following exception. Logically this is not an exception condition. If the query returns 0 rows my report should shown an empty table rather than throwing an exception.

Is there a way to suppress this exception?

org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot fetch the next data row.
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot move down to next row in the result set.
SQL error #1:[jcc][t4][10120][10898][3.58.82] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null ;
    com.ibm.db2.jcc.am.SqlException: [jcc][t4][10120][10898][3.58.82] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null
	at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:52)
	at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:108)
	at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:84)
	at org.eclipse.birt.data.engine.odaconsumer.ResultSet.fetch(ResultSet.java:143)
	at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:214)
	at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:105)
	at org.eclipse.birt.data.engine.executor.cache.RowResultSet.getNext(RowResultSet.java:192)
	at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.initialize(SimpleResultSet.java:133)
	at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.(SimpleResultSet.java:108)
	at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:1009)
	at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:441)
	at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1495)
	at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:232)
	at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:173)
	at org.eclipse.birt.report.engine.api.impl.ExtractionResults.nextResultIterator(ExtractionResults.java:74)
	at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:70)
	at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:337)
	at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot move down to next row in the result set.
SQL error #1:[jcc][t4][10120][10898][3.58.82] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null ;
    com.ibm.db2.jcc.am.SqlException: [jcc][t4][10120][10898][3.58.82] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null
	at org.eclipse.birt.report.data.oda.jdbc.ResultSet.next(ResultSet.java:196)
	at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaResultSet.next(OdaResultSet.java:180)
	at org.eclipse.birt.data.engine.odaconsumer.ResultSet.fetch(ResultSet.java:138)
	... 14 more
Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][t4][10120][10898][3.58.82] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null
	at com.ibm.db2.jcc.am.ed.a(ed.java:660)
	at com.ibm.db2.jcc.am.ed.a(ed.java:60)
	at com.ibm.db2.jcc.am.ed.a(ed.java:103)
	at com.ibm.db2.jcc.am.hm.Db(hm.java:4352)
	at com.ibm.db2.jcc.am.hm.c(hm.java:325)
	at com.ibm.db2.jcc.am.hm.next(hm.java:304)
	at org.eclipse.birt.report.data.oda.jdbc.ResultSet.next(ResultSet.java:187)
	... 16 more

Dual group in the same axis for 3D Charts.

Mon, 20 May 2013 23:32:14 +0000

Hello,
I was wondering if with some java script I could add double group in the same axis, See attach image,
Thank you
I appreciate your help.

Custom sort: Data Cube

Mon, 20 May 2013 23:28:56 +0000

Custom sort: Data Cube

Mon, 20 May 2013 23:28:42 +0000

Scripted Marker Line - How to set Font Size for Caption

Mon, 20 May 2013 20:44:29 +0000

Hi all,

I have a scripted marker line in one of my charts, which is dynamically set at run time.
The marker also has a caption that needs to be set. I am able to setup the caption using getLabel().getCaption.setValue() but unable to control its font. Any suggestions!!

inside beforeGeneration function.....

center_ml = MarkerLineImpl.create(yAxis, NumberDataElementImpl.create(targetCenter));
center_ml.getLabel().getCaption().setValue("Target Center at " + targetCenter);

center_ml.getLineAttributes().getColor().set(76,107,16);
center_ml.getLineAttributes().setStyle(LineStyle.SOLID_LITERAL);
center_ml.getLineAttributes().setThickness(2);

Thanks and Regards
Joseph

Dual group in the same axis for Charts 3D

Mon, 20 May 2013 20:37:31 +0000

Hello,
I was wondering if with some java script I could add double group in the same axis, See attach image,
Thank you
I appreciate your help.

Colored vertical bar on one side of the report

Mon, 20 May 2013 20:26:08 +0000

So I made a report with a vertical yellow bar running down the left side of the report like this:

I did this by inserting a grid and having all my report elements like inside this grid. The I made the grid have a yellow border only on the left. Is there any other way to have a vertical bar on the left side of the report? I feel like the way I'm doing it is a little hacky.

Need help with passing parameters to BIRT

Mon, 20 May 2013 20:10:40 +0000

Hello,

I have created several BIRT reports that prompt the user for parameters and then pass them to the sql (using ? placed within the sql). I did this all using the BIRT IDE.

BUT, now I need to pass in a parameter in that contains sql, such as myID='1234' and have that placed into the BIRT report sql, and then have the BIRT report run using the sql passed in.

How do you do this? I think I have to use java script, but how can I implement this? Can someone provide an example????

passing report parmeter

Mon, 20 May 2013 18:29:02 +0000

using ibm clear quest report designer
i want to link report paramter (data type string) with data set parameter
the following error occur

The following items have errors:
ReportDesign (id = 1):
- Cannot set the string value (1) to parameter 1
Error setting value for SQL parameter #1
Cannot set the string value (1) to parameter 1
Error setting value for SQL parameter #1 ( 1 time(s) )
detail : org.eclipse.birt.report.data.adapter.api.AdapterException: Cannot set the string value (1) to parameter 1
Error setting value for SQL parameter #1

can any one help me