For those of you have and continue to have this issue, I've found the perfect solution:
Original Selection :r.insert_time between ? and ?
Replacement :r.insert_time between ? and ? ((r.insert_time between ? and ?) or r.insert_time >'1/1/1900')
I too had tried removing the parameters, etc. but that proved to be a headache. So instead of making the selection of insert date active, I made it passive.
Of course, in the jrxml file, I also removed the dates from printing. Elementary my dear Watson.
Now, you can report on any service request that has any status using the following:
sqlStat = "select r.id id_zzz_SR,r.problem_type problem_type_zzz_SR,r.problem_sub_type problem_sub_type_zzz_SR,r.third_level_category third_level_category_zzz_SR,r.description description_zzz_SR,r.notes notes_zzz_SR,r.id activities_zzz_SR,r.request_user request_user_zzz_SR,r.insert_time insert_time_zzz_SR,r.due_date due_date_zzz_SR ,r.responsibility responsibility_zzz_SR,a.id activity_id_zzz_ASR ,a.from_time from_time_zzz_ASR, a.to_time to_time_zzz_ASR from service_req r INNER JOIN work_report a ON ( a.account_id = r.account_id and a.service_req_id = r.id ) "+ moreJoin + " where r.account_id = ? and ((r.insert_time between ? and ?) or r.insert_time > '1/1/1900') and ( not ( problem_type=N'External Projects' ) and not ( problem_type=N'IT Internal' ) and not ( problem_type=N'Programming Help Desk' ) and not ( problem_type=N'Projects' ) and not ( problem_type=N'Special Project' ) and not ( problem_type=N'Special Project' ) and not ( problem_type=N'Telephone' ) and (r.status <> 3 or r.status is null)) " + moreWhere + sqlWizardFilters;
This message was edited 2 times. Last update was at 13/07/2012 20:12:04