Does Table component work with non-SQL datasources?

[deniska.info]

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

[dusan.rybanjr]

i am pretty pissed off. Spending hours with this bug. No help nowhere.

[devanshi.sharma]

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

[elliotmok]

3 years passed... nobody can help?  I met the same problem...