Query2Report is a simple open source business intelligence platform that allows users to build report/dashboard for business analytics or enterprise reporting
Home Page: https://sourceforge.net/projects/query2report/
License: GNU General Public License v3.0
Support elements to have column span option so that the elements on a row need not be of same size.
Instead of creating different users with different roles and later access and create reports public or private per each user, the user lack of more functionality as admin as to create users, roles and assign reports to these.
When report modified to input refresh interval, the value is not persisted when the report is closed and reopened.
me and my team wanna try query2report , but we have trouble to make query2report with postgresql.
do you have docker version of query2report for testing ?
Hi
Today I tried the q2r tomcat7,
the interface starts but I do not see the administrator button or the "add driver" button you mention on the documentation.
I can log in and see the driver list bun nothing else.
When I try to change password for adminuser or try to create a new user, I receive this error:
Save of user 'undefined' Failed
Response = "Unable to save user 'admin'.". Status = 500
Best regards
Paolo
I got this error when deploying to 9.0.0.4
ErrorThe EAR file could be corrupt and/or incomplete. Make sure that the application is at a compatible Java(TM) Platform, Enterprise Edition (Java EE) level for the current version of WebSphere(R) Application Server.
org.eclipse.jst.j2ee.commonarchivecore.internal.exception.DeploymentDescriptorLoadException: WEB-INF/web.xml
Do you know why?
It would be good to have the possibility to adapt the interface when providing access to the tool to third parties, for example:
- remove links to documentation.
- Include logo.
Hi, I didn't found how to export in xlsx or CSV a report.
Is it possible ? Ex generate a table and have the possibilite to export all data table in a CVS file.
Thx for your answer.
Hi There,
I really love the way you built the tool, i just need one small modification if possible ..
i.e Lets say i want to pass a XYZ as a variable in the Get/Post url and the same needs to be passed as one of the Variable for the SQL by replacing the string ..
Eg., I say in the quer where ABC = @@xyz@@ and this XYZ will be passed as the URL get 123.com/q2r?XYZ=89898
By doing this i can filter i can use the tool in a different way ..
do let me know if this possible on an urgent basis .. please
Best Regards
Shekar
It would be great to have updated and more advanced widgets for data visualization.
Most of the widget only allow only the triplet {date - varchar - number;number;...} as input. An additional level would be great.
I just install a tomcat8/openjdk8 in Ubuntu 18.04 and deploy q2r
then I login using admin , create a jdbc postgresql driver , create a postgresql data source , and test connection works fine.
but when I try to create a report , no matter what sql statement I just type , everytime q2r return the same error
Response = "Unable to verify query for "Element title" "datasource name" with chart type cell". Error = . Status = 500
any suggestions ? something looks like goes wrong in log
2019-06-06 16:58:40,884 ERROR http-nio-8080-exec-1id com.lwr.software.reporter.restservices.ReportManagementService.executeQuery - Unable to verify select * from center_center; on default with chart type cell. Error java.sql.Date cannot be cast to java.sql.Timestamp
java.lang.ClassCastException: java.sql.Date cannot be cast to java.sql.Timestamp
at com.lwr.software.reporter.utils.DWHUtility.executeQuery(DWHUtility.java:177)
at com.lwr.software.reporter.reportmgmt.Element.init(Element.java:312)
at com.lwr.software.reporter.restservices.ReportManagementService.executeQuery(ReportManagementService.java:190)
at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.lwr.software.reporter.security.AuthenticationFilter.doFilter(AuthenticationFilter.java:83)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Hi,
We have a blocking issue saving reports that prevent us to use the q2r tool.
The .json for the report is saved correctly, it is possible to create a graph and this is created and visualized correctly but it fails when trying to save the report with the new content widget inside.
It was working ok until the last deployment of q2r.
Attached is the q2r.log file.
Any feedback will be welcome.
q2r.log
Thanks!
Would like an option to export to Excel and CSV
Might you please verify that a parameter can be used more than once in a query? Attached example bellow.
(select 'a) Total CDS new registered users: '||count(distinct(userid)) as users_info from users_cds where date_trunc('day',data_created) >= {date:date_from} and date_trunc('day',data_created) <= {date:date_to})
UNION
(select 'b) Total CDS active users: '||count(distinct(username)) as users_info from brokerrequest_his where date_trunc('day',receivedat) >= {date:date_from} and date_trunc('day',receivedat) <= {date:date_to});
Hello. I can not login admin admin. I install Tomcate and copy q2r.war in folder webapps.
Can we have a debug switch (true/false) option to show/hide the SQL Queries in our graph region? Currently it is showing the SQL queries as error message in case of an error.
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
Django
The Web framework for perfectionists with deadlines.
Laravel
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft
Open source projects and samples from Microsoft.
Google
Google ❤️ Open Source for everyone.
Alibaba
Alibaba Open Source for everyone
D3
Data-Driven Documents codes.
Tencent
China tencent open source team.