Does Table component work with non-SQL datasources?

1

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
deniska.info's picture
Joined: Oct 1 2014 - 3:10am
Last seen: 1 year 1 week ago

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

dusan.rybanjr - 2 years 4 months ago

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

devanshi.sharma - 1 year 6 months ago

0 Answers:

No answers yet
Feedback
randomness