SELECT wo.WORKORDERID "Request ID",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.DUEBYTIME) "DueBy Time",std.STATUSNAME "Request Status",pd.PRIORITYNAME "Priority",qd.QUEUENAME "Group",ti.FIRST_NAME "Technician",rtdef.NAME "Request Type",cd.CATEGORYNAME "Category",scd.NAME "Subcategory",icd.NAME "Item",aau.FIRST_NAME "Requester",wo.TITLE "Subject",wotodesc.FULLDESCRIPTION "Description",wof.UDF_CHAR1 "Reason for Hold" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID LEFT JOIN ItemDefinition icd ON wos.ITEMID=icd.ITEMID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN RequestTypeDefinition rtdef ON wos.REQUESTTYPEID=rtdef.REQUESTTYPEID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID LEFT JOIN WorkOrder_Fields wof ON wo.WORKORDERID=wof.WORKORDERID INNER JOIN AccountSiteMapping ON wo.SITEID=AccountSiteMapping.SITEID WHERE  ((AccountSiteMapping.ACCOUNTID = 3) AND ((((((std.STATUSNAME != N'Closed' COLLATE SQL_Latin1_General_CP1_CS_AS) AND (std.STATUSNAME != N'Resolved' COLLATE SQL_Latin1_General_CP1_CS_AS)) OR (std.STATUSNAME IS NULL)) AND ((rtdef.NAME = N'Alert' COLLATE SQL_Latin1_General_CP1_CI_AS) OR (rtdef.NAME = N'Incident' COLLATE SQL_Latin1_General_CP1_CI_AS))) AND (((longtodate(wo.CREATEDTIME) >= datetolong('1354305600000') AND ((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL))) AND ((longtodate(wo.CREATEDTIME) <= datetolong('1388519999000') AND (((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL)) AND (longtodate(wo.CREATEDTIME) != -1))))) AND (wo.SITEID IN (1202,4,6,1501,2))))  AND wo.ISPARENT=1

Report 2

SELECT wo.WORKORDERID "Request ID",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.DUEBYTIME) "DueBy Time",std.STATUSNAME "Request Status",pd.PRIORITYNAME "Priority",qd.QUEUENAME "Group",ti.FIRST_NAME "Technician",rtdef.NAME "Request Type",cd.CATEGORYNAME "Category",scd.NAME "Subcategory",icd.NAME "Item",aau.FIRST_NAME "Requester",wo.TITLE "Subject",wotodesc.FULLDESCRIPTION "Description",wof.UDF_CHAR1 "Reason for Hold" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID LEFT JOIN ItemDefinition icd ON wos.ITEMID=icd.ITEMID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN RequestTypeDefinition rtdef ON wos.REQUESTTYPEID=rtdef.REQUESTTYPEID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID LEFT JOIN WorkOrder_Fields wof ON wo.WORKORDERID=wof.WORKORDERID INNER JOIN AccountSiteMapping ON wo.SITEID=AccountSiteMapping.SITEID WHERE  ((AccountSiteMapping.ACCOUNTID = 3) AND ((((((std.STATUSNAME != N'Closed' COLLATE SQL_Latin1_General_CP1_CS_AS) AND (std.STATUSNAME != N'Resolved' COLLATE SQL_Latin1_General_CP1_CS_AS)) OR (std.STATUSNAME IS NULL)) AND (((((rtdef.NAME = N'Preventive Maintenance' COLLATE SQL_Latin1_General_CP1_CI_AS) OR (rtdef.NAME = N'Request For Information' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (rtdef.NAME = N'Service Request' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (rtdef.NAME = N'Vendor Request' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (rtdef.NAME IS NULL))) AND (((longtodate(wo.CREATEDTIME) >= datetolong('1354305600000') AND ((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL))) AND ((longtodate(wo.CREATEDTIME) <= datetolong('1388519999000') AND (((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL)) AND (longtodate(wo.CREATEDTIME) != -1))))) AND (wo.SITEID IN (1202,4,6,1501,2))))  AND wo.ISPARENT=1

If there are multiple notes in same request is it possible to show it as one entry in the report?

Thanks,

Raghesh