Jasper Report Designer Query Based Report - Unable to have Date in result

Products

• Clarity PPM On Premise

Issue/Introduction

Jasper Report Designer using a Query to provide results shows Dates as "String". Unable to get Dates to show as a "Date".

How do you get Dates to show as "java.util.Date" or "java.sql.Date" instead of "java.lang.String"?

Or....How do you convert an auto defined "java.lang.String" into a "java.sql.Date"?

Environment

Release : 16.0.2

Component : CLARITY

Resolution

You can change the field from the "java.lang.String" into a "java.sql.Date" by changing the class Type on each individual field.