AnsweredAssumed Answered

Jasper Studio, filtering on a date range

Question asked by jan.pokorny on Apr 13, 2017
Latest reply on Apr 20, 2017 by jan.pokorny

Hi,
can you help me to create the date range (start_date, end_Date) in report over ODBC drivers?

1) I create new report wiht query
SELECT casd.cr.open_date,
casd.cr.id,
casd.cr.assignee_combo_name
FROM casd.cr

2) Then I create two parameters "start_date", "end_date"

3) And I add a condition "Where
casd.cr.open_date >= $P{start_date} and cr.open_date <= $P{end_date}"

But the result is "Document is empty"
----------------------------
- I tried to change class (casd.cr.open_date, parameters; Timestamp, sql.Date)
- I tried "Where casd.cr.open_date = '2002-09-13 01:00:00.0'", Error executing SQL statement for: data.

 

Thank you for your help

Jan

Outcomes