Reports Blank
We recently upgraded to version 7002 and now both a newly created report and a saved report come up as blank when they are run directly from the reports menu. The other reports we have display correcty, but I cannot get this report to work correctly. I have tried deleting and recreating it with no help. It is a Matrix stye report based on requests.
Additionally, if you edit the report and change a parameter they run correctly one time. However if you save the report, and try to run it from the reports menu, it shows as blank until you go into edit mode and run it again. Below is the report query that shows when you click on the Show Query button. Any insight to this issue would be appreciated.
SELECT queue.QUEUENAME "Group",wo.WORKORDERID "Request ID",longtodate(wo.CREATEDTIME) "Created Time" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN WorkOrder_Queue wo_queue ON wo.WORKORDERID=wo_queue.WORKORDERID LEFT JOIN QueueDefinition queue ON wo_queue.QUEUEID=queue.QUEUEID WHERE (((longtodate(wo.CREATEDTIME) >= <from_thismonth>) AND ((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL))) AND ((longtodate(wo.CREATEDTIME) <= <to_thismonth>) AND ((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL)))) AND wot.THD_WOID=wot.WORKORDERID ORDER BY 3
Additionally, if you edit the report and change a parameter they run correctly one time. However if you save the report, and try to run it from the reports menu, it shows as blank until you go into edit mode and run it again. Below is the report query that shows when you click on the Show Query button. Any insight to this issue would be appreciated.
SELECT queue.QUEUENAME "Group",wo.WORKORDERID "Request ID",longtodate(wo.CREATEDTIME) "Created Time" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN WorkOrder_Queue wo_queue ON wo.WORKORDERID=wo_queue.WORKORDERID LEFT JOIN QueueDefinition queue ON wo_queue.QUEUEID=queue.QUEUEID WHERE (((longtodate(wo.CREATEDTIME) >= <from_thismonth>) AND ((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL))) AND ((longtodate(wo.CREATEDTIME) <= <to_thismonth>) AND ((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL)))) AND wot.THD_WOID=wot.WORKORDERID ORDER BY 3