Hi Guys, We created a query in iReport designer which is working. The report should display the activities within a certain period. We would like to fill in this period ourselfes. In iReport designer it is working. On Jasper Server it wil ask for 2 dates but after that it sin't showing anythin at all. But in iReport designer it is showing the correct info. Does someone has an idea what goes wrong overhere? I attached the code we are using right now. Code:SELECT DateDiff(MINUTE,work_report.from_time,work_report.to_time) AS TotalMIN, work_report."service_req_id", company."company_name", service_req."request_user", service_req."problem_type" AS First_lvl_category, service_req."problem_sub_type" AS second_lvl_category, service_req."third_level_category", service_req."title" AS second_lvl_category, service_req."solution" AS second_lvl_category, work_report."from_time" AS second_lvl_category, work_report."to_time" AS second_lvl_category, work_report."description" AS Activity_descrFROM "work_report" work_report INNER JOIN "service_req" service_req ON work_report."service_req_id" = service_req."id" INNER JOIN "sysaid_user" sysaid_user ON service_req."request_user" = sysaid_user."user_name" INNER JOIN "company" company ON sysaid_user."company" = company."company_id"WHERE work_report.from_time BETWEEN $P{StartDate} AND $P{EndDate}
