IReports Error

[A.Arun Kumar]

Hi All,
I am using IReports.I am having a table called emp where there are three fields
1.)Empname varchar
2.)Empsal integer
3.)Empdate timestamp..
I am grouping by two fields Empsal,Empdate..It is showing inconvertible types for Empsal,Empdate....But if if give Empsal and Empdate as String it is compiling perfectly..Why this error is coming..can't we group the fields other than String datatype..The error is given below..Please reply as early
as possible..


Compiling to file... .\group7.jasper -> .\classic.java Errors compiling .\group7.jasper! 3705313�[Thread-84]�WARN�design.JRVerifier��-�Warning�:�Element�bottom�reaches�outside�band�area�:�y=0�height=1�band-height=0 net.sf.jasperreports.engine.JRException:�Errors�were�encountered�when�compiling�report�expressions�class�file: D:\Arun\iReport-0.4.0\classic.java:109:�inconvertible�types found���:�java.sql.Timestamp required:�java.lang.String ����������������value�=�(java.lang.String)(((java.sql.Timestamp)field_empdate.getValue())); ������������������������������������������^ D:\Arun\iReport-0.4.0\classic.java:174:�inconvertible�types found���:�java.lang.Integer required:�java.lang.String ����������������value�=�(java.lang.String)(((java.lang.Integer)field_empsal.getValue())); ������������������������������������������^ D:\Arun\iReport-0.4.0\classic.java:237:�inconvertible�types found���:�java.sql.Timestamp required:�java.lang.String ����������������value�=�(java.lang.String)(((java.sql.Timestamp)field_empdate.getOldValue())); ������������������������������������������^ D:\Arun\iReport-0.4.0\classic.java:302:�inconvertible�types found���:�java.lang.Integer required:�java.lang.String ����������������value�=�(java.lang.String)(((java.lang.Integer)field_empsal.getOldValue())); ������������������������������������������^ D:\Arun\iReport-0.4.0\classic.java:365:�inconvertible�types found���:�java.sql.Timestamp required:�java.lang.String ����������������value�=�(java.lang.String)(((java.sql.Timestamp)field_empdate.getValue())); ������������������������������������������^ D:\Arun\iReport-0.4.0\classic.java:430:�inconvertible�types found���:�java.lang.Integer required:�java.lang.String ����������������value�=�(java.lang.String)(((java.lang.Integer)field_empsal.getValue())); ������������������������������������������^ 6�errors ����at�net.sf.jasperreports.engine.design.JRAbstractJavaCompiler.compileReport(JRAbstractJavaCompiler.java:155) ����at�net.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:137) ����at�net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:142) ����at�net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:130) ����at�it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:336) ����at�java.lang.Thread.run(Thread.java:536) Compilation running time : 1000

Thanks and regards
arun kumar..

[Mark Spritzler]

Well, this isn't really a Servlets question.

I am going to move this to the IDE's and other tools forum.

Meanwhile check out the IReports Forums at sourceforge.

Mark