I have a DATETIME field with a date and time: 2015-08-06 08:50:28 . I'm trying to generate a report by passing two parameters, Data_Inicial and Data_Final so I can get all the bank dates that are in that period.
The condition is this way in IReport :
WHERE
tbl_suspensao.'status' = 'Finalizado'
AND tbl_suspensao.'data_inicio' BETWEEN $P{Data_Inicio} AND $P{Data_Fim}
These two parameters are of type: Date/Time of java.sql.Time . But when I enter the parameters and give a preview the message "The document does not have pages" appears. Can anyone help?
