java.sql.SQLException: Failed to calculate index value ...

Classic Servoy
1

I use the HXTT DBF driver in iReport. I get the following exception in iReport if I use a subdataset for a list element. I have done, what you can see in the Video "iReport List Component ". Now, I’m unsure if it is a bug in the HXTT DBF JDBC driver.

Is it a bug?

Error filling print... net.sf.jasperreports.engine.JRException: Error executing SQL statement for : foreignCurrency2
Setting up the file resolver... 
net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : foreignCurrency2 
    at net.sf.jasperreports.components.list.VerticalFillList.prepare(VerticalFillList.java:139) 
    at net.sf.jasperreports.engine.fill.JRFillComponentElement.prepare(JRFillComponentElement.java:129) 
    at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:328) 
    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:377) 
    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:351) 
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2039) 
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:771) 
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:281) 
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:144) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:909) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822) 
    at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61) 
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) 
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276) 
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745) 
    at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) 
    at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) 
    at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) 
Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : foreignCurrency2 
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:246) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1086) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:667) 
    at net.sf.jasperreports.components.list.FillDatasetRun.start(FillDatasetRun.java:157) 
    at net.sf.jasperreports.components.list.VerticalFillList.prepare(VerticalFillList.java:93) 
    ... 17 more 
Caused by: java.sql.SQLException: Failed to calculate index value for index expression datum 
    at com.hxtt.global.SQLState.SQLException(Unknown Source) 
    at com.hxtt.sql.dbf.w.a(Unknown Source) 
    at com.hxtt.sql.dbf.j.a(Unknown Source) 
    at com.hxtt.sql.a1.a(Unknown Source) 
    at com.hxtt.sql.cm.a(Unknown Source) 
    at com.hxtt.sql.az.a(Unknown Source) 
    at com.hxtt.sql.dl.a(Unknown Source) 
    at com.hxtt.sql.dl.a(Unknown Source) 
    at com.hxtt.sql.c3.g(Unknown Source) 
    at com.hxtt.sql.dl.a(Unknown Source) 
    at com.hxtt.sql.br.a(Unknown Source) 
    at com.hxtt.sql.ai.a(Unknown Source) 
    at com.hxtt.sql.dn.executeQuery(Unknown Source) 
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:239) 
    ... 21 more 
Print not filled. Try to use an EmptyDataSource...