Jump to content
Changes to the Jaspersoft community edition download ×

Problems with MSSQL (Unknown column name)


Recommended Posts


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?




Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...