Report select
Hi All,
I'm having some major problem with reports.
Just wondering if what I'm expecting is correct. If a person hasn't had their department set at the time they rasie a request are Report dymanic enough to update this information on the fly.
Eg A user of our has just had his department changed to Accounts. This is reflected nicely with in the request itself. However when I run the Requests by Status reports, and set the X axis to group by department this call appears in the unassigned bar. I would expect the report to pick up the change in department, but iseems they are not.
Just for Laughts I have included the query.
SELECT dpt.DEPTNAME 'Department',wo.WORKORDERID 'Request ID',dpt.DEPTNAME 'Department',std.STATUSNAME 'Request Status',wo.CREATEDTIME 'Created Time',wo.TITLE 'Subject' FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (((wo.CREATEDTIME >= $P{fromdate}) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= $P{todate}) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)))) AND wot.THD_WOID=wot.WORKORDERID ORDER BY 1
Regards
John
I'm having some major problem with reports.
Just wondering if what I'm expecting is correct. If a person hasn't had their department set at the time they rasie a request are Report dymanic enough to update this information on the fly.
Eg A user of our has just had his department changed to Accounts. This is reflected nicely with in the request itself. However when I run the Requests by Status reports, and set the X axis to group by department this call appears in the unassigned bar. I would expect the report to pick up the change in department, but iseems they are not.
Just for Laughts I have included the query.
SELECT dpt.DEPTNAME 'Department',wo.WORKORDERID 'Request ID',dpt.DEPTNAME 'Department',std.STATUSNAME 'Request Status',wo.CREATEDTIME 'Created Time',wo.TITLE 'Subject' FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (((wo.CREATEDTIME >= $P{fromdate}) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= $P{todate}) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)))) AND wot.THD_WOID=wot.WORKORDERID ORDER BY 1
Regards
John