Jump to content
Changes to the Jaspersoft community edition download ×

subdataset / SQL query


Recommended Posts



I want to build a crosstable with a subdataset but I've a problem with the sql query :


SELECT VED_complet,YEAR(VED_crea_date) as VED_annee
FROM VED_vedette


The problem comes from YEAR(VED_crea_date) as VED_annee


When I execute the report, I have the following error :


[code]org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@141e072 targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@1f680ea, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Unknown column name : VED_annee


I think that Jasper doesn't support the keyword "AS" but I don't know to do without


Can anyone help me ?



Link to comment
Share on other sites

  • Replies 3
  • 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...