Am new to JasperReports. As part of creating a query in report, am facing an issue.
I have a sql query similar to below one : am trying to convert a date value to different date using a user defined SQL Function.
Select * from Person where (CreatedDate < dbo.ConvertLocalDateToUTC($P{dsRegistration_attemptEndDt_pDate_MinRange} + ' 00:00:00',$P{UserTimeZoneFK}))[/code]
How can i write the same Where clause in JasperReports using $X{} as the where clause contains a user defined function?
I tried to write as below, but it is not working.
Select * from Person where $X{LESS, CreatedDate, dbo.ConvertLocalDateToUTC($P{dsRegistration_attemptEndDt_pDte_MinRange} + ' 00:00:00',$P{UserTimeZoneFK}) }[/code]
Can any one please let me know, how can i use the Sql user-defined functions in sql queries ofJasperReports. Am working on this from 2 days, but still i couldn't get anything.