lxpelevin

I've created a report which uses excel template for export to xls. It' works well in JasperStudio. But I got a trouble when tried to publish it to jasperserver. I got an error file not found for my template. Excel template was loaded to the same directory as content resource. So the question is: Is it possible to use excel templates in jasperserver for export? what type should have the templates? How i can fix this problem? SecureExceptionHandlerImpl,pool-9-thread-2:125 - There was an error on the server. Try again or contact site administrators. (Error UID: ff3f0426-9b24-4339-916a-221f7f0c0699) com.jaspersoft.jasperserver.remote.exception.ExportExecutionRejectedException: net.sf.jasperreports.engine.JRException: Input stream not found at: chart.xls.jasper-jasperreports-1 | at com.jaspersoft.jasperserver.remote.services.impl.ReportExecutorImpl.exportReport(ReportExecutorImpl.java:210)jasper-jasperreports-1 | at com.jaspersoft.jasperserver.remote.services.impl.RunReportServiceImpl.generateReportOutput(RunReportServiceImpl.java:1170)jasper-jasperreports-1 | at com.jaspersoft.jasperserver.remote.services.impl.RunReportServiceImpl.executeExport(RunReportServiceImpl.java:617)jasper-jasperreports-1 | at com.jaspersoft.jasperserver.remote.services.impl.RunReportServiceImpl$2.run(RunReportServiceImpl.java:509)jasper-jasperreports-1 | at com.jaspersoft.jasperserver.api.logging.util.LoggableExecutorService$1.run(LoggableExecutorService.java:84)jasper-jasperreports-1 | at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)jasper-jasperreports-1 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)jasper-jasperreports-1 | at java.lang.Thread.run(Thread.java:750)[/code]

I have an Excel file with diagram, and I need to export data from the report to this file to make diagram calculated. I've tried: to use template with data sheet that diagram references, but got an error Workbook already contains sheet.to use template without data sheet that diagram references, but diagram not generating and shows error on reference.Any ideas how to create report with Excel diagram. Jasper diagrams doesn't fit requrements, i need excel diagram.

Thanks for yor video. In case you have demonstrated, the query "select * from orders" will execute 2 times. So you will have two independent instances of dataset for each table. I can tell you more, there is an ability to use different input parameters for query for each table. Eg. first table can contain orders from US and the second from UK if use parameter country as input on sql level. "select * from orders where country = P{country}". In my case i have heavy query with heavy logic, so for my case not impressible to have 4x database overhead. In my case i need to execute query for report only one time.

No, i haven' tried "share". How i can do this? If pagination is diabled page-break element doesn't works.

I have one complex data set. The need is to put 4 tables in report based on this dataset. So the qutsions is: How to use data from dataset for 4 tables without executing query 4 times (without database overhead)? And the next question how to put each table on seperate page? without other pagination?

i' ve found workaround. Diasble weld subsystem. add to jboss-deployment-structure.xml Not tested all features yet, but in first look it seems to be working. My configuration: Jasperserver-CE Wildfly 8.1 Oracle 12c (for repository)

i've got the same error under wildfly. Then i tryed to add hibernate-validator.jar to /web-inf/lib. Then got the next error: {"JBAS014671: Failed services" => {"jboss.deployment.unit."jasperserver.war".WeldStartService" => "org.jboss.msc.service.StartException in service jboss.deployment.unit."jasperserver.war".WeldStartService: Failed to start service Caused by: org.jboss.weld.exceptions.DeploymentException: WELD-001408: Unsatisfied dependencies for type Set<Service> with qualifiers @Default at injection point [backedAnnotatedParameter] Parameter 1 of [backedAnnotatedConstructor] @Inject com.google.common.util.concurrent.ServiceManager(Set<Service>) at com.google.common.util.concurrent.ServiceManager.<init>(ServiceManager.java:0) Have you solved all errors and deployed jasper to wildfly?