taivan.dagva

what's problam ireport

Error filling print... Byte data not found at : Window.UsedBynet.sf.jasperreports.engine.JRException: Byte data not found at : Window.UsedBy at net.sf.jasperreports.repo.RepositoryUtil.getBytesFromLocation(RepositoryUtil.java:324) at net.sf.jasperreports.engine.RenderableUtil.getRenderable(RenderableUtil.java:121) at net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillImage.java:536) at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.java:472) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:259) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:456) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:457) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:421) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:282) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:151) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:939) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:852) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87) 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)Print not filled. Try to use an EmptyDataSource...[/code]

xls

taivan.dagva posted a topic in Products

<img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/comp1_mini.jpg"> Compiling to file... D:New foldershop_pos(2.30.5)reportscomopenbravoreportsinventory.jasper Compilation running time: 218!<hr> <img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/rundb1_mini.jpg"> Filling report... <img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/world.png"> Locale: English (United States) <img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/timezone.png"> Time zone: Default Report fill running time: 16! (pages generated: 0)<hr> <img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/printer_mini.png"> Exporting Excel (using POI) to file... D:New foldershop_pos(2.30.5)reportscomopenbravoreportsinventory.xls! Setting detect cell type to:true Setting detect cell type to (net.sf.jasperreports.export.xls.detect.cell.type):true Export running time: 0!<hr> Executing: rundll32 SHELL32.DLL,ShellExec_RunDLL "D:New foldershop_pos(2.30.5)reportscomopenbravoreportsinventory.xls"

mysql

taivan.dagva posted a topic in Products

<img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/comp1_mini.jpg"> Compiling to file... D:New foldershop_pos(2.30.5)reportscomopenbravoreportsinventory.jasper Compilation running time: 218!<hr> <img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/comp1_mini.jpg"> Compiling to file... D:New foldershop_pos(2.30.5)reportscomopenbravoreportsinventory.jasper Compilation running time: 234!<hr> <img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/rundb1_mini.jpg"> Filling report... <img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/world.png"> Locale: English (United States) <img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/timezone.png"> Time zone: Default Error filling print... Error executing SQL statement for : inventory net.sf.jasperreports.engine.JRException: Error executing SQL statement for : inventory at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1114) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1288) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:907) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:852) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87) 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: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'STOCKCURRENT.STOCKSECURITY' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) ... 12 more Print not filled. Try to use an EmptyDataSource... <img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/comp1_mini.jpg"> Compiling to file... D:New foldershop_pos(2.30.5)reportscomopenbravoreportsinventory.jasper Compilation running time: 218!<hr> <img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/rundb1_mini.jpg"> Filling report... <img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/world.png"> Locale: English (United States) <img align="right" src="jar:file:/C:/Program%20Files/Jaspersoft/iReport-5.5.1/ireport/modules/com-jaspersoft-ireport.jar!/com/jaspersoft/ireport/designer/compiler/timezone.png"> Time zone: Default Error filling print... Error executing SQL statement for : inventory net.sf.jasperreports.engine.JRException: Error executing SQL statement for : inventory at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1114) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1288) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:907) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:852) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87) 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: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'STOCKCURRENT.STOCKSECURITY' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) ... 12 more Print not filled. Try to use an EmptyDataSource...

Sign In

Posts

Joined

Last visited

taivan.dagva's Achievements

Rookie (2/14)

Recent Badges

Reputation

what's problam ireport

xls

mysql

Activity

Products

Explore