Table component works fine with SQL datasets, so in general the question is - does it work with non-SQL datasets?
In Jaspersoft studio I tried to make report with XLSX data adapter.
I also put a Table component, connected to the XLSX dataset.
After pressing Preview I got the following error:
net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: java.lang.NoSuchMethodException: net.sf.jasperreports.engine.data.ExcelDataSource.<init>()
at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:530)
at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:505)
at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:386)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: java.lang.NoSuchMethodException: net.sf.jasperreports.engine.data.ExcelDataSource.<init>()
at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:886)
at net.sf.jasperreports.components.table.fill.FillTableSubreport.prepareSubreport(FillTableSubreport.java:172)
at net.sf.jasperreports.components.table.fill.FillTable.prepare(FillTable.java:419)
at net.sf.jasperreports.engine.fill.JRFillComponentElement.prepare(JRFillComponentElement.java:150)
at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:352)
at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:421)
at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:396)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:317)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:251)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:119)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:558)
at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)
at java.lang.Thread.run(Thread.java:745)
Caused by: net.sf.jasperreports.engine.JRException: java.lang.NoSuchMethodException: net.sf.jasperreports.engine.data.ExcelDataSource.<init>()
at net.sf.jasperreports.engine.query.ExcelQueryExecuter.createDatasource(ExcelQueryExecuter.java:241)
at net.sf.jasperreports.engine.query.ExcelQueryExecuter.createDatasource(ExcelQueryExecuter.java:202)
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)
at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:437)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:526)
at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:396)
at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:742)
at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:58)
at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:216)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
... 1 more
Caused by: java.lang.NoSuchMethodException: net.sf.jasperreports.engine.data.ExcelDataSource.<init>()
at java.lang.Class.getConstructor0(Class.java:3082)
at java.lang.Class.getConstructor(Class.java:1825)
at net.sf.jasperreports.engine.query.ExcelQueryExecuter.createDatasource(ExcelQueryExecuter.java:224)
... 12 more
0 Answers:
No answers yet
i am pretty pissed off. Spending hours with this bug. No help nowhere.
Hi There,
I am also facing the same issue. Want to use Excel datasource in Table/Chart Components but no luck.. Any help/tips appreciated.
Thanks
3 years passed... nobody can help? I met the same problem...