Hi, is there any way i can produce a report with a parameter query. I have produced this report from the time spent module and would like to let the user select a time period i.e. date from - to

 

SELECT ti.FIRST_NAME "Assigned Technician",wo.WORKORDERID "Request ID",qd.QUEUENAME "Group",ti.FIRST_NAME "Assigned Technician",cd.CATEGORYNAME "Category",scd.NAME "Sub Category",aau.FIRST_NAME "Requester",dpt.DEPTNAME "Department",pd.PRIORITYNAME "Priority",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.RESPONDEDTIME) "Responded Date",longtodate(wo.COMPLETEDTIME) "Completed Time",wo.TIMESPENTONREQ "Time Spent" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID INNER JOIN RequestCharges rc ON wo.WORKORDERID=rc.WORKORDERID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID WHERE  (((rc.EXECUTEDTIME >= datetolong('1262304000000') AND ((rc.EXECUTEDTIME != 0) AND (rc.EXECUTEDTIME IS NOT NULL))) AND ((rc.EXECUTEDTIME <= datetolong('1268870399000') AND (((rc.EXECUTEDTIME != 0) AND (rc.EXECUTEDTIME IS NOT NULL)) AND (rc.EXECUTEDTIME != -1))))  AND wot.THD_WOID=wot.WORKORDERID  ORDER BY 1, 9, 5