100分求助iReport报表高手，在线等！ 小弟我现在用iReport做个报表，有些东西不懂，想找个懂iReport的高手，小弟不胜感激！我qq 148165986 在线等！ 解决方案 » 免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货 没人啊，自己顶！ 顺便问下， 在iReport工具下我定义了一个参数，为name，类型是string 我在写sql的时候是这样写的 select * from employee where lname like '%$P{name}%'编译的时候，我用的是数据库连接，但是出现编译错误，如果不用数据库编译就能正确运行！错误代码Filling report... Error filling print... java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s). at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.validateParameterIndex(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setObjectInternal(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setString(Unknown Source) at net.sf.jasperreports.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:288) at net.sf.jasperreports.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:98) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:762) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:163) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:625) at java.lang.Thread.run(Thread.java:534) NESTED BY : java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s). at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.validateParameterIndex(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setObjectInternal(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setString(Unknown Source) at net.sf.jasperreports.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:288) at net.sf.jasperreports.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:98) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:762) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:163) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:625) at java.lang.Thread.run(Thread.java:534) NESTED BY : net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query : select * from employee where lname like '%?%' at net.sf.jasperreports.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:333) at net.sf.jasperreports.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:98) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:762) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:163) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:625) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s). at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.validateParameterIndex(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setObjectInternal(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setString(Unknown Source) at net.sf.jasperreports.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:288) ... 7 more Print not filled. Try to use an EmptyDataSource...! 有问题去我们那里交流http://forum.brainysoft.net select name from employee where lname like %dd%定义一个字段 jquery，二维数组取值。 jQuery append动态添加的页面对象如何避免刷新掉 现在用Java的CMS系统是不是很少？ 高分跪求调查问卷页面！！！(在线等，一经使用，马上结帖) JSP两种开发模式究竟誰更好？ ********在JSP中如何删除指定目录下的所有文件******** 为什么我在FrontPage做的jsp网页(中文)在JBuilder9中中文显示乱码 j8编译Hello时出现问题？ 怎样extends同一个包下面类？ join on相关问题 jasperreports报表输出为html形式时，打印时线条不能打印出来。 100分求解报表问题，报表精英请进
顺便问下， 在iReport工具下我定义了一个参数，为name，类型是string
我在写sql的时候是这样写的 select * from employee where lname like '%$P{name}%'编译的时候，我用的是数据库连接，但是出现编译错误，如果不用数据库编译就能正确运行！
错误代码Filling report... Error filling print... java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s). at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.validateParameterIndex(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setObjectInternal(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setString(Unknown Source) at net.sf.jasperreports.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:288) at net.sf.jasperreports.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:98) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:762) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:163) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:625) at java.lang.Thread.run(Thread.java:534) NESTED BY : java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s). at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.validateParameterIndex(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setObjectInternal(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setString(Unknown Source) at net.sf.jasperreports.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:288) at net.sf.jasperreports.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:98) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:762) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:163) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:625) at java.lang.Thread.run(Thread.java:534) NESTED BY : net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query : select * from employee where lname like '%?%' at net.sf.jasperreports.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:333) at net.sf.jasperreports.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:98) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:762) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:163) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:625) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s). at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.validateParameterIndex(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setObjectInternal(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.setString(Unknown Source) at net.sf.jasperreports.engine.util.JRQueryExecuter.getStatement(JRQueryExecuter.java:288) ... 7 more Print not filled. Try to use an EmptyDataSource...!