2a832447-8f60-4f99-a9ee-1e9023bbc25b TaskName System.Int32 DateDue System.DateTime DateCompleted System.DateTime Note System.String ItineraryID System.Decimal CustomCode System.String ItineraryName System.String UserName System.String UserNameTask System.String ItineraryStatusName System.String AssignedTo System.String TaskAssignedTo System.String AssignedUserName System.String Font System.String PurchaseItemDetail ------------------- SELECT * From( Select T.TaskID, TaskName, DateDue, DateCompleted, Note, I.ItineraryID, I.CustomCode, I.ItineraryName, IST.ItineraryStatusName, DefaultColorSet.Font, I.AssignedTo ,ISNULL(T.AssignedTo,I.AssignedTo) as AssignedToTask ,U.UserName ,ISNULL(UR.UserName,U.UserName) as UserNameTask ,CASE WHEN U.IsRecordActive=1 THEN '' ELSE U.UserName END AssignedUserName ,I.ItineraryStatusID From Task T Left Join ItineraryTask IT on IT.TaskID = T.TaskID Left Join Itinerary I on I.ItineraryID = IT.ItineraryID left Join ItineraryStatus IST on IST.ItineraryStatusID=I.ItineraryStatusID Left Join [User] U on U.UserID = I.AssignedTo LEFT JOIN [User] UR on UR.UserID=T.AssignedTo OUTER APPLY ( Select Top(1) Note7 as HexColor, Note8 as Font from Agent A Left Join AgentContact AC on AC.AgentID = A.AgentID Left Join Contact C on C.ContactID = AC.ContactID Where AC.IsDefaultBilling = 1 )DefaultColorSet )tt Where DateCompleted is Null and DateDue >= @StartDate and DateDue < @EndDate AND (AssignedToTask IN @UserIDList) and (ItineraryStatusID IN @ItineraryStatusIDList) And ItineraryID > 0 AND ItineraryId IS NOT NULL Order By DateDue ------------------- true PurchaseItemDetail PurchaseItemDetail true true Outstanding Task List by Consultant =Format(Parameters!StartDate.Value, "dd MMMMM yyyy") & " to " & Format(Parameters!EndDate.Value, "dd MMMMM yyyy") 1.04104cm 19.9cm 0.68633in 0.98425in 0.5in 1.6in 0.7in 1.7in 1.66407in 0.20497in true true Date Due Textbox2 Black 1pt 2pt 2pt 2pt 2pt true true Itinerary Owner Black 1pt 2pt 2pt 2pt 2pt true true Itin ID Black 1pt 2pt 2pt 2pt 2pt true true Itinerary Name Black 1pt 2pt 2pt 2pt 2pt true true Status Black 1pt 2pt 2pt 2pt 2pt true true Task Name Black 1pt 2pt 2pt 2pt 2pt true true Notes Black 1pt 2pt 2pt 2pt 2pt 0.14247in true Textbox13 2pt 2pt 2pt 2pt 7 0.19455in true true =Fields!UserNameTask.Value UserNameTask Black 1pt 2pt 2pt 2pt 2pt 7 0.20497in true true =Fields!DateDue.Value DateDue LightGrey 2pt 2pt 2pt 2pt true true =Fields!AssignedUserName.Value AssignedUserName LightGrey 1pt 2pt 2pt 2pt 2pt true true =IIF(Len(Fields!ItineraryID.Value) > 0, Fields!ItineraryID.Value, Fields!CustomCode.Value) CustomCode LightGrey 1pt 2pt 2pt 2pt 2pt true true =Fields!ItineraryName.Value LightGrey 1pt 2pt 2pt 2pt 2pt true true =Fields!ItineraryStatusName.Value LightGrey 1pt 2pt 2pt 2pt 2pt true true =Fields!TaskName.Value LightGrey 1pt 2pt 2pt 2pt 2pt true true =Fields!Note.Value LightGrey 1pt 2pt 2pt 2pt 2pt =Fields!UserNameTask.Value =Fields!UserNameTask.Value After After =Fields!DateDue.Value PurchaseItemDetail 1.42028cm 1.89728cm 19.9cm 1 3.39695cm 0.25cm 0.5cm 19.9cm