Calling BIRT reports with JSP

Hi,

Can any one help me with calling BIRT reports with JSPs and using JSP I have to use all the functionalities like filtering the reports by a search text box, or by select dropdown box some things like that.

To do all these what all are required for my eclipse BIRT Web project like (jars, tlds, and etc) please help me with all these stuff..

Thanks in advance....

Find more posts tagged with

Comments

mwilliams

You can use the tag library to call BIRT reports using JSP pages. Take a look at the following devShare link:

http://www.birt-exchange.org/org/devshare/deploying-birt-reports/298-2.2-birt-tag-library/

Eswar B

Thanks for reply Michael,

I have used test code from the web project and included my design instead of test but after running that through Tomcat it is giving me errors

org.eclipse.birt.report.engine.api.EngineException: The design file file:/C:/Users/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/abc.rptdesign has error and can not be run.
at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReportDesign(ReportEngineHelper.java:248)
at org.eclipse.birt.report.engine.api.impl.ReportEngine.openReportDesign(ReportEngine.java:484)
at org.eclipse.birt.report.service.ReportEngineService.openReportDesign(Unknown Source)
at org.eclipse.birt.report.utility.BirtUtility.getRunnableFromDesignFile(Unknown Source)
at org.eclipse.birt.report.context.ViewerAttributeBean.getDesignHandle(Unknown Source)
at org.eclipse.birt.report.context.ViewerAttributeBean.__init(Unknown Source)
at org.eclipse.birt.report.context.BaseAttributeBean.init(Unknown Source)
at org.eclipse.birt.report.context.ViewerAttributeBean.<init>(Unknown Source)
at org.eclipse.birt.report.context.BirtContext.__init(Unknown Source)
at org.eclipse.birt.report.context.BaseContext.<init>(Unknown Source)
at org.eclipse.birt.report.context.BirtContext.<init>(Unknown Source)
at org.eclipse.birt.report.servlet.ViewerServlet.__getContext(Unknown Source)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
Caused by: Error.DesignFileException.INVALID_XML - 1 errors found!
1.) ( line = 0, tag = null) org.eclipse.birt.report.model.parser.DesignParserException (code = Error.DesignParserException.UNSUPPORTED_VERSION, message : The report file of version "3.2.15" is not supported.)

at org.eclipse.birt.report.model.parser.ModuleReader.readModule(ModuleReader.java:117)
at org.eclipse.birt.report.model.parser.DesignReader.read(DesignReader.java:90)
at org.eclipse.birt.report.model.core.DesignSession.openDesign(DesignSession.java:314)
at org.eclipse.birt.report.model.api.SessionHandle.openDesign(SessionHandle.java:292)
at org.eclipse.birt.report.engine.parser.ReportParser.getDesignHandle(ReportParser.java:157)
at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReportDesign(ReportEngineHelper.java:243)
... 27 more

what can I do with this type of errors.

Iam using:
eclipse-reporting-helios-SR2-win32
and birt-wtp-integration-sdk-2_2_0 for getting web project option in BIRT

Does these versions work or suggest me any other versions Iam new to BIRT and Iam facing problem with initial installing of all softwares. please help me.

Thanks in advance

mwilliams

It looks like the error you're getting is because you're trying to run a report created in a newer version than the version you have deployed. If you're designing with a Helios version and using the 2.2.0 deployment, this is definitely the case. You'll either need to design your reports in the same version you have deployed or download a new version of the runtime (the same as your designer) and deploy it.

Eswar B

Thanks Michael,

I have started using Birt 2.2.1 and it is working fine and I have generated all the reports well but the problem is the eclipse is shutting down always saying "an error has occurred see the log file" can you please help me with that.

How can I filter the Birt reports using a search functionality like by creating a text box and allowing the user to search from the report dynamically using JSP.

Please help me with it.

Thanks for your reply.

mwilliams

Have you checked the log files to see the error?

Can you explain more about what you're wanting to do for the filter/search?

Eswar B

Thanks Michael,

Whenever I run birt report it is displaying all the contents in the database related to that database table. What I want is I have give an option for user in front end to select an option from dropdown and then after selection that related content should be displayed.And I need a search box where user can search for a particular data in the report. How can I make that possible using JSP.

Please help me.