Problems with MSSQL (Unknown column name)

[Oliver_Kersten]

Hi,

i am using JasperReport 1.3.3 with iReport 1.3.3. and MaxDB (SapDB) as database. Everything works fine with MaxDB but with MS SQLServer 2005 I get the following Exception:

 

net.sf.jasperreports.engine.JRException: Unknown column name : EXPRESSION1

 

This is my Query (ppr_min is an integer, search_date a Date):

select sum(ppr_min) from caregrade where search_date >= $P{begin} and search_date<= $P{end}

 

There is one Field for the Query: EXPRESSION1 java.lang.String

 

There is something strange in the "Report query" Window of iReport. "Read Fields" with MaxDB works fine. With MS SQL, iReport find the field but can't find the fieldname.

 

Can anyone help me with my problem?

 

ciao

Oliver.