Hi
I was try to creating reporting in cuba reporting page and reporting structure everything is creating and at the same time i would be passing some parameter I should be followed in this link procedure.I’m getting a report structure only…and i was passing parameter alias means it not supporting… I has got a this doc (Report for entity Samplerep.docx (5.6 KB)…so where i will be give template code and how to create complete report generation Etc…give some suggestions or give me some another procedures.
thank you.
Hi Olga,
Thank you for your replying. Actually I am try to saying i was creating a report and i got report structure and i would be using new wizard Report for entity Contact (1).docx (5.6 KB).
And i was followed go through that CUBA documentation further where i will giving template and how to do that complete report generation in cuba.
Thanks
Unfortunately, I still haven’t got your question. To see a complete example of a report, you can import the sample-library application (it is also available on the Samples tab in Studio), activate the Reporting add-on in it, and then import Reports.zip from the project source folder on the Reports page in the app.
Hi Olga,
Thanks for your replying.
How to create a report in cuba .If u have with example in screen shot also. I was followed cuba documentation but i didn’t get a clear idea.
thank you.
Hi Olga,
I following Report wizards,i have a one doudt
in that pic step3 : input parameter and run report it’s showing path location and adding a some file (what my doudt is that file which one.where is it should take and uploaded).otherwise we’ve creating a xls file?.
Hi Olga,
I was tried Reports Wizard.And i got a Single entity report Report for entity Publication.docx (9.9 KB)
and in this report how to do give that Template.and all…
Thank you
Hi Olga,
actually I’m trying to create report and gave as a one YARG file and got a error for
<==== PSQLException: ERROR: column "pubbkname" does not exist
Position: 53 ===>
<===
com.haulmont.cuba.core.global.RemoteException:
---
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.2.cuba23): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: column "pubbkname" does not exist
Position: 53
Error Code: 0
Call: SELECT ID AS a1, DELETE_TS AS a2, DELETED_BY AS a3, PUBBKNAME AS a4, PUBCITY AS a5, PUBNAME AS a6, PUBYEAR AS a7, VERSION AS a8 FROM COMPANYDATA_COMPANY WHERE (DELETE_TS IS NULL) LIMIT ? OFFSET ?
bind => [100, 0]
Query: ReadAllQuery(referenceClass=Company sql="SELECT ID AS a1, DELETE_TS AS a2, DELETED_BY AS a3, PUBBKNAME AS a4, PUBCITY AS a5, PUBNAME AS a6, PUBYEAR AS a7, VERSION AS a8 FROM COMPANYDATA_COMPANY WHERE (DELETE_TS IS NULL) LIMIT ? OFFSET ?")
FetchGroup(){deleteTs, pubname, pubyear, id, pubcity, version, deletedBy, pubbkname}
---
org.eclipse.persistence.exceptions.DatabaseException:
Internal Exception: org.postgresql.util.PSQLException: ERROR: column "pubbkname" does not exist
Position: 53
Error Code: 0
Call: SELECT ID AS a1, DELETE_TS AS a2, DELETED_BY AS a3, PUBBKNAME AS a4, PUBCITY AS a5, PUBNAME AS a6, PUBYEAR AS a7, VERSION AS a8 FROM COMPANYDATA_COMPANY WHERE (DELETE_TS IS NULL) LIMIT ? OFFSET ?
bind => [100, 0]
Query: ReadAllQuery(referenceClass=Company sql="SELECT ID AS a1, DELETE_TS AS a2, DELETED_BY AS a3, PUBBKNAME AS a4, PUBCITY AS a5, PUBNAME AS a6, PUBYEAR AS a7, VERSION AS a8 FROM COMPANYDATA_COMPANY WHERE (DELETE_TS IS NULL) LIMIT ? OFFSET ?")
FetchGroup(){deleteTs, pubname, pubyear, id, pubcity, version, deletedBy, pubbkname}
---
org.postgresql.util.PSQLException: ERROR: column "pubbkname" does not exist
Position: 53
at com.haulmont.cuba.core.sys.ServiceInterceptor.aroundInvoke(ServiceInterceptor.java:129)
at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy215.loadList(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.haulmont.cuba.core.sys.remoting.LocalServiceInvokerImpl.invoke(LocalServiceInvokerImpl.java:94)
at com.haulmont.cuba.web.sys.remoting.LocalServiceProxy$LocalServiceInvocationHandler.invoke(LocalServiceProxy.java:154)
at com.sun.proxy.$Proxy29.loadList(Unknown Source)
at com.haulmont.cuba.client.sys.DataManagerClientImpl.loadList(DataManagerClientImpl.java:53)
at com.haulmont.cuba.gui.data.impl.GenericDataSupplier.loadList(GenericDataSupplier.java:102)
at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.loadData(CollectionDatasourceImpl.java:613)
at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.refresh(CollectionDatasourceImpl.java:161)
at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.refreshIfNotSuspended(CollectionDatasourceImpl.java:112)
at com.haulmont.cuba.gui.components.filter.FilterDelegateImpl.refreshDatasource(FilterDelegateImpl.java:1643)
at com.haulmont.cuba.gui.components.filter.FilterDelegateImpl.apply(FilterDelegateImpl.java:1487)
at com.haulmont.cuba.web.gui.components.WebFilter.apply(WebFilter.java:81)
at com.haulmont.cuba.gui.commonlookup.CommonLookupController.initFilter(CommonLookupController.java:99)
at com.haulmont.cuba.gui.commonlookup.CommonLookupController.init(CommonLookupController.java:69)
at com.haulmont.cuba.gui.WindowManager.init(WindowManager.java:1247)
at com.haulmont.cuba.gui.WindowManager.initWrapperFrame(WindowManager.java:1236)
at com.haulmont.cuba.gui.WindowManager.createWindow(WindowManager.java:581)
at com.haulmont.cuba.gui.WindowManager.openLookup(WindowManager.java:920)
at com.haulmont.cuba.web.WebWindowManager.openLookup(WebWindowManager.java:167)
at com.haulmont.cuba.gui.components.PickerField$LookupAction.actionPerform(PickerField.java:336)
at com.haulmont.cuba.web.gui.components.WebButton.performAction(WebButton.java:45)
at com.haulmont.cuba.web.gui.components.WebButton.lambda$new$61446b05$1(WebButton.java:37)
at sun.reflect.GeneratedMethodAccessor194.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510)
at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:200)
at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:163)
at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:1037)
at com.vaadin.ui.Button.fireClick(Button.java:377)
at com.haulmont.cuba.web.toolkit.ui.CubaButton.fireClick(CubaButton.java:54)
at com.vaadin.ui.Button$1.click(Button.java:54)
at sun.reflect.GeneratedMethodAccessor193.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:158)
at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:119)
at com.vaadin.server.communication.ServerRpcHandler.handleInvocation(ServerRpcHandler.java:444)
at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:409)
at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:274)
at com.vaadin.server.communication.UidlRequestHandler.synchronizedHandleRequest(UidlRequestHandler.java:90)
at com.vaadin.server.SynchronizedRequestHandler.handleRequest(SynchronizedRequestHandler.java:41)
at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1435)
at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:361)
at com.haulmont.cuba.web.sys.CubaApplicationServlet.serviceAppRequest(CubaApplicationServlet.java:312)
at com.haulmont.cuba.web.sys.CubaApplicationServlet.service(CubaApplicationServlet.java:203)
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 org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:107)
at org.springframework.web.filter.CompositeFilter.doFilter(CompositeFilter.java:73)
at com.haulmont.cuba.web.sys.CubaHttpFilter.doFilter(CubaHttpFilter.java:107)
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:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
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, could you please use triple back quotes for code blocks.
It is extremely hard to read your posts without proper formatting.