Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsQuery Option not displayed in Edit-DataSet Option
https://www.eclipse.org/forums/index.php/mv/msg/457174/1014420/#msg_1014420
I am trying to create a sub-report using the Eclipse-BIRT, for that I have created a main report having a Pie-chart . After that I created one more report (with another Different 'Data Set') which I intend to open when a certain section of Pie-chart is clicked.
I am taking the Data from excel ( Customer.csv). It has three columns - Customer,Product , Quantity. The pie-chart of main report displays the Products and their quantity.Now on click of any section of this pie chart should open another pie chart of sub-report having names of the customers
I am not able to map these two reports one as the parent of another as - "QUERY" option is not displayed in the DataSet so I am not able to build SQL-Query to link them
Your help is much appreciated .]]>Brij Kumar2013-02-25T19:39:10-00:00Re: Query Option not displayed in Edit-DataSet Option
https://www.eclipse.org/forums/index.php/mv/msg/457174/1014644/#msg_1014644
Michael Williams2013-02-26T07:58:58-00:00Re: Query Option not displayed in Edit-DataSet Option
https://www.eclipse.org/forums/index.php/mv/msg/457174/1014983/#msg_1014983
My Questions are
1 - How to link these two pie chart ( Hyperlinking every section of piechart ?? if so how to do it)
2 - How to pass the value(name of particular Soap which is clicked in the pie-chart) from MainReport to another
So that i can build the query like
Select Customers from Sales where Product = someName ( that is passed from
MainReport)
Thanks in advance]]>Brij Kumar2013-02-27T06:56:01-00:00Re: Query Option not displayed in Edit-DataSet Option
https://www.eclipse.org/forums/index.php/mv/msg/457174/1015277/#msg_1015277
In your detail report, you need to make a report parameter to accept the value from the main report. Then, you'd make a query like: select customers from sales where product = ?
The '?' creates a dataSet parameter. In the dataSet editor, you'd go to the parameter section and double click on the automatically created parameter. In the link to drop down, select your already created report parameter.
Now, go back to your main report and go back into the drill down you created and pass the category value through the parameter to the detail report.
This should do it. Let me know if you have questions or if you get stuck because I missed a step.]]>Michael Williams2013-02-28T02:30:51-00:00Re: Query Option not displayed in Edit-DataSet Option
https://www.eclipse.org/forums/index.php/mv/msg/457174/1015296/#msg_1015296
Brij Kumar2013-02-28T06:27:03-00:00Re: Query Option not displayed in Edit-DataSet Option
https://www.eclipse.org/forums/index.php/mv/msg/457174/1015424/#msg_1015424
]]>Michael Williams2013-02-28T14:34:42-00:00Re: Query Option not displayed in Edit-DataSet Option
https://www.eclipse.org/forums/index.php/mv/msg/457174/1017230/#msg_1017230
For that I have created a dynamic web project and copied the webviewer folder from Birt Runtime to webapps of Tomcat(renamed to birt). I have added the jars from BirtRuntime ReportEngine to birt WEB-INF/lib. Its working fine if I start tomcat from tomcat/bin startup.bat and access h ttp://localhost:8080/birt
But if I try to access these reports using servlets from eclipse,I am getting Error :
Please tell me if I am wrong somewhere or missing some step or jar.
EVERE: A child container failed during start
java.util.concurrent.ExecutionException: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/BirtEEProj]]
at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
at java.util.concurrent.FutureTask.get(FutureTask.java:83)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1123)
at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:800)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/BirtEEProj]]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:154)
... 7 more
Caused by: java.lang.NoClassDefFoundError: org/eclipse/birt/report/engine/api/IRenderOption <=====================
at java.lang.Class.getDeclaredFields0(Native Method)
at java.lang.Class.privateGetDeclaredFields(Class.java:2291)
at java.lang.Class.getDeclaredFields(Class.java:1743)
at org.apache.catalina.util.Introspection.getDeclaredFields(Introspection.java:106)
at org.apache.catalina.startup.WebAnnotationSet.loadFieldsAnnotation(WebAnnotationSet.java:261)
at org.apache.catalina.startup.WebAnnotationSet.loadApplicationServletAnnotations(WebAnnotationSet.java:140)
at org.apache.catalina.startup.WebAnnotationSet.loadApplicationAnnotations(WebAnnotationSet.java:67)
at org.apache.catalina.startup.ContextConfig.applicationAnnotationsConfig(ContextConfig.java:405)
at org.apache.catalina.startup.ContextConfig.configureStart(ContextConfig.java:881)
at org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:369)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5179)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
... 7 more
Caused by: java.lang.ClassNotFoundException: org.eclipse.birt.report.engine.api.IRenderOption
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1713)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1558)
... 21 more
Mar 11, 2013 2:11:15 PM org.apache.catalina.core.ContainerBase startInternal
SEVERE: A child container failed during start
java.util.concurrent.ExecutionException: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost]]
at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
at java.util.concurrent.FutureTask.get(FutureTask.java:83)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1123)
at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:302)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.StandardService.startInternal(StandardService.java:443)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:732)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.startup.Catalina.start(Catalina.java:684)
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.catalina.startup.Bootstrap.start(Bootstrap.java:322)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:456)
Caused by: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost]]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:154)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.apache.catalina.LifecycleException: A child container failed during start
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1131)
at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:800)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
... 7 more
Mar 11, 2013 2:11:15 PM org.apache.catalina.startup.Catalina start
SEVERE: Catalina.start:
org.apache.catalina.LifecycleException: Failed to start component [StandardServer[8005]]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:154)
at org.apache.catalina.startup.Catalina.start(Catalina.java:684)
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.catalina.startup.Bootstrap.start(Bootstrap.java:322)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:456)
Caused by: org.apache.catalina.LifecycleException: Failed to start component [StandardService[Catalina]]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:154)
at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:732)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
... 7 more
Caused by: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina]]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:154)
at org.apache.catalina.core.StandardService.startInternal(StandardService.java:443)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
... 9 more
Caused by: org.apache.catalina.LifecycleException: A child container failed during start
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1131)
at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:302)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
... 11 more
Mar 11, 2013 2:11:15 PM org.apache.catalina.startup.Catalina start]]>Brij Kumar2013-03-11T09:12:54-00:00Re: Query Option not displayed in Edit-DataSet Option
https://www.eclipse.org/forums/index.php/mv/msg/457174/1017361/#msg_1017361
http://www.eclipse.org/forums/index.php/t/458069/]]>Michael Williams2013-03-11T16:58:27-00:00Re: Query Option not displayed in Edit-DataSet Option
https://www.eclipse.org/forums/index.php/mv/msg/457174/1463300/#msg_1463300
antim pareta2014-11-06T12:24:08-00:00Re: Query Option not displayed in Edit-DataSet Option
https://www.eclipse.org/forums/index.php/mv/msg/457174/1464000/#msg_1464000
Plz help me.]]>antim pareta2014-11-07T04:43:00-00:00