Task ROWID,System.Int64 ID,System.Guid Description,System.String Type,.Models.IRTPicklistItem TaskStatus,.Models.IRTPicklistItem Name,System.String CommitmentCategory,System.String DateExplanation,System.String DueDate,System.DateTime DueDateType,.Models.IRTPicklistItem Correspondence_Name,System.String Submission_Application_Name,System.String Correspondence_Submissions_Application_Name,System.String Submission_Application_Country_Name,System.String Correspondence_Submissions_Application_Country_Name,System.String Submission_Application_RegProducts_Product_Name,System.String Correspondence_Submissions_Application_RegProducts_Product_Name,System.String Task DataSet.Task Task_AssignedContacts ROWID,System.Int64 Task_ROWID,System.Int64 ID,System.Guid Name,System.String Task_AssignedContacts DataSet.Task_AssignedContacts Task_AssignedGroups ROWID,System.Int64 Task_ROWID,System.Int64 ID,System.Guid Name,System.String Task_AssignedGroups DataSet.Task_AssignedGroups Task_AssignedUsers ROWID,System.Int64 Task_ROWID,System.Int64 ID,System.Guid Name,System.String Column1,System.Object Task_AssignedUsers DataSet.Task_AssignedUsers Submission Product,System.String Application,System.String Country,System.String CommitmentCategory,System.String Name,System.String Description,System.String DueDate,System.DateTime DueDateType,System.String Status,System.String TaskID,System.Guid Correspondence_Submissions_Application_Name,EqualTo,,,String Submission Task Submission_Application_RegProducts_Product_Name Product Submission_Application_Name Application Submission_Application_Country_Name Country CommitmentCategory CommitmentCategory Name Name Description Description DueDate DueDate DueDateType DueDateType TaskStatus Status ID TaskID Correspondence Product,System.String Application,System.String Country,System.String CommitmentCategory,System.String Name,System.String Description,System.String DueDate,System.DateTime DueDateType,System.String Status,System.String TaskID,System.Guid Correspondence_Submissions_Application_Name,NotEqualTo,,,String Correspondence Task Correspondence_Submissions_Application_RegProducts_Product_Name Product Correspondence_Submissions_Application_Name Application Correspondence_Submissions_Application_Country_Name Country CommitmentCategory CommitmentCategory Name Name Description Description DueDate DueDate DueDateType DueDateType TaskStatus Status ID TaskID Task Task_ROWID Task Relation1 ROWID Task Task_ROWID Task Relation2 ROWID Task Task_ROWID Task Relation3 ROWID ,varBaseURL,varBaseURL,System.String,http:_x002F__x002F_localhost:48323_x002F_,False,False ,varLocalTimeZone,varLocalTimeZone,System.String,China_x0020_Standard_x0020_Time,False,False ,StartDate,Start_x0020_Date,Start_x0020_Date,System.DateTime,TimeZoneInfo.ConvertTime_x0028_DateTime.UtcNow_x002C_TimeZoneInfo.FindSystemTimeZoneById_x0028_varLocalTimeZone_x0029__x0029_,False,True,False EngineV2 DataTable tblSubmission = this.DataSources["Submission"].DataTable; DataTable tblCorrespondence = this.DataSources["Correspondence"].DataTable; tblSubmission.Merge(tblCorrespondence); None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,10.22,0.5 True Transparent 0,0,0.7,0.5 Left iVBORw0KGgoAAAANSUhEUgAAAFkAAAA2CAYAAACsqTUgAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAAlwSFlzAAAOpgAADqYBh9ypbwAADORJREFUeF7tW/uPVdUV7p/QtFFgoDhMYUrpQAmlVA1toUWlVKtVxBdNY5tapaVWKkg0klAJpfhIk9oftFSRGAWDGGxr7MOoaTUxaih9kBbEhApU5z7nzp079869d1bXt/bj7HPOPvcF5Yfe+8OXc+acvdde+9vfXnvtfe58aHJyknr436JH8jlAj+RzgA5JrtHEcwdobPt2Gtt5P43d/4C6Ru+7Cej3jp0KDz5Ik/m85asjkku7d1N6cC6lz59C6b4ZjD7PtbswbK7nT6V0/wDV3jtp+WqbZBCcmTuP0jP7KT2XiQZAeA8KA7MpM7SA6qdOW87aIrn02GOK1H6HYJdkc+++6xZYkgeY5CGqnW6X5FpNETyPFQyCo6S6iDbeDbB9H6T0bKXkartKBsESIjjWwFhmkO+NYTHu3HchMoODGsyLhIshqp88ZflrSvL47scViZZgHq0uJ7UhNMkthgsdIlCxf6aaCj1ym6MdkkMhggmWe5/RHsJIJrlmH8gityscg62Ce0pujuZK1iFCYrDKIlIMd6Ez9xKb9bMeHDQkWadpSsH9YWLxzFUx4rO5d5CZzc+5EZkB2Ky4wDM4wGVaHSApxylRzJ7YYiBd6mCwrV3YgJhCthlnYLthuAgUzMk0CMa9gWtEExwomq8gFkk4O5VZuJBGVq+m4qZNATZupJE1ayi3eInuHGDSnnhH1GAN0DAc/vRCyl+zmgpsBxjdtJny37yZcsu+rMrDFnxGHWND++zahlDkbz1AmXlDlFu5korrv0/FzZuVbVzXraPcihVqT2Bso16UhyTAZx/J9WyWG1xFwx9TWQSISzJs3tkOYPSZOJBYOvAs1f59gurpNNVLpTC4DeznK88/TyNrv6FmB9c17Rh7QhY/zy79PI3v3EG1o/+K2cPhCzpRee11Gr1vG2W/sEzIGJ7FBMIn+O3ONvwthCm7xS1baOLtt6k+/AFNFkcDu+VxuVY/eJ8qb75Fxa1bKb90qdQTccBPM1jatnsvSCQ5naL8JZfICBsHUdmoFXFZnvM1RDIPSn75cirt3qOc1EabolKh8r59lLv0UkpZotkmCGayRm5aSxN//4e/rgcYvMK991L+M5+lzBzdWeMzAPXy34X166l67F2vjSTAj+Jt64QbDKKIw7Vv7g2SSU5T7rKvWGcMybaiYyxl7png3NeupOqhv4ScUnCylQaASqFq2y5f81dcQbWT73nLN0Np316lOIYs2CAEtpmgsYd+JoMblIePrp/JPkNApUceoeyixUJiILiIioEkkidTTDLHJ8RAKeiQalWr75Uy+kX5E4f/GnKmNYQ7N77rVypMaecrv/m1fdeo4wrB+3phRNQsJOs+mDhdeugBD8HmPgnhMrXjx2XWQlyGm1BIMkhWMoeLlaxkhAunggkXwd9slI2k5i+k8gsvhpyIAvEOU23iyN8k7vnKlF/4LWUv5pgHgrltzKZ6oeApW6Pa4cOiVMRhGi+H3oPg4sZNQgCINVMa07tw660RgiPgd/Vj74hgsJ74ylSPHqXc9deJj0p0YV5Y5rUnmAlq1Bla9jNQn5lFqxnQq3HFHojIw4lAUFpjsRRcpfGmFfDFwOwGCM0sutMoQQjhmxgjh1LK4Y4dkJqn58ymzeLH4WvzJTyWsYEFFxiF2MFjGZyYku2CBLHAhexoIAZVn91P+yq8HfrLPCF/ll14iqqo+SUhbc73MNpkZ4CLKj/N3CySHlQyEjMAAp2jl3//OGnABNeQvW6k6LDkn2wPkvp8Kl6+SDowfPGgJtva53Ni2+5jUCW1PDxyTjkEd/uh5lJrSZ21nLuD4zSFLYjqng0YgVmXcXvGuzV4Vg+DRu+9W5bRvAtwDnL5BFBNvvEH5G25Q7UXJTEI7JEtGwQgZ7+uTUYV6lIFAwQgPcCg1rS+oo2eA2JsDIni6DS2QTgTxf1C9Y5KRp/pIqb57nEa3/lhUhw4I2fjcI+odkPqun7jHzKi88rJjJ/C1jD0Bx+7MrDm2jvJF9xdxHb4uXKRIczOWZuiEZAnuJr3iTiEUmMoKynn57ocR90wpl2y8z875uLp3YhtIyV99VcNUEOEGs2jsFw9LaMFsGJ4+QxGiSRab6Ci/w1RXdR0xsEAkXYVyddtS1/XZIdvYbRntkGxgieDKUEzp4Z/byhY8xbFrSp83JVY/CqSAXsfRIQ5FlVdfjdv3AAskwlOZUyvZ/bkDzGJAGJHNRqQewhViu6+vApdsBy2T3ZGSDVCZt7jl/QdCTgMwKKEC8SxaD4DjBs6zzKBZqII4KuTkM7E2FAJFuqieOCFxWwbKzLjv3uaEtQDjTz0lJCSqVPzCYKl350jJqhHEUKzW2Kmpys4UfP8/lLuRFwjESFM3Sqr7XN9HO6Di9iAVbv5WYlag2o2TDWWP3v5DUTQyAUndnN8+GJSffFKdSyDuRvwI+eP67+tHEjohGQ1AaVAInEA8NJUtkAEgT50yVTkqdfwO4zmAmRJaXBH39Tv8dgP5M1I3CR+8WYq1GYIiHeljbsnnJE7jEMkbLjimy+LLZFj/tA/StvNMEO1L0jODM1GygBVS3LLVcTpQlJzimbho6ukpFwIUxO0Yu6ocX52DF7ki9GDQeIVHCMGCi6leO5J8poFFs/iD2+0ggfRYGQ4huWW8c3NDmyzu5l79LT6ADzMYLrG6rP3bRdskS4PqXgwihbtpbZAB1B3nkcKtvoYyU6fZ+lCqzAKuq9I0HgRsJjiL8MVFM2OkY2gXV5DBpGWmTpGBwCKHzAI5rGnbBWaahC1uK2kRRQqHbMa0Y9cEAzxn35CFYIOC9DJEqOZE3TvPgbZJBlyD3FieU6Pyn/8UctooGh3H7k7SKt1RdEbOJniAoK7xZ/ZTNZNR4QVpFDYSbBudsIvW9xSJIFPaZZKH+y+Q9sX2hz8iB0lhHxQwo9Ae2sWRJnaM0TKieGRD3F/xje0KdDzHYBY3bBDhYKCEaDyHjzLjeFB8sxRoh+RQduESzY1hY+DbNADVw4eEHJzx5i+8mLBdxcGKqO+tN4OyvChJRgCV6BAD2yO3fCeIpdzG+N6nZQMkHeUFS9YGznLG7rknsOUAKaYMMHcWgzpx5J/eciAaqs+vulx8RF6NNjAbsTi6/au8/Io6Y9Ehxqg6NgOAM1WyGIXzyDISttYGOByCCgAcwPjKgGhsb8VpbhtfJXyLFTqMbAMHRPjIi1zXN8jIMJCZQMVikwdw9Ed3Olv1OEStr70ufkIESZshlJEvJuynKJohQnQFCHREsgttEFMKCsB21xjqFCAO+XX+i8sTT8EaIwgHtUOHRAA2PeMOywaKQ0i8fDyMxBGUAflyjoFZYrjwhYxOSQ6mh2MURF+7hqrvHLPGmiPcMTnq5KkqCyLv9pC5wBe3TIDGpEDFCDWyoME/kzHwACJDwWA2UnQj1E+fUtt4hCoT2qIwitYkx37V2bKSHaAxUTSvwCDLfw7sRz2TlXgoBzBQBhyE+nh6Z6+6Wtsb8db1AarBQgX/JYsRlWk/WRhCPMdzfLNzFdYUHJIQJvAhV3azTKAl0wfdDyyOsd/CdUKyBTIEviIWIlYiN7WEmxSPFYQ2cGCDbfnIdddaUlFXxTYV52QhZCflXPfpveownYmJxkoMFBa10p49lFv1VVXPpzJDCgjiMiiLT0lYMxCPzbmx8RXtyAdfJrd410YJPzhWtSEoAeI72uqfKZ+psAs2vnZMsvnWB+OiaqiFOwE7mFqj27dTcdt2Gtu2TRSEQTA5J9qRqRddnWET01wPAGZKdtEiiYXFDXfKv08Ym4Vv36JWfMwEEBiyoezYjju+itoRQjhfh09jW9k/bRP28QEAs0lswXYTckPAQM8botKju0IL85krWQOEyYEPSIRz+Gk/I9XHmxOc/cp086hNE5Af/GTsmUAIZ1Kms81p+hwZ/zIh5Gp/DaGmjgOV0/J17hx1b95xfo5BhI/mXxHEZ9hFeyICv00v0G8OSUKwJveskuw605ZjDJkRUG/0nftMyuh7D5IJ5ucJ9dQ7VS82ozxo1C9JGaFgDkPB5idYqDsn2SEh5EADMgT6PeqYeuaMObEjzWxqhA+c+N5pq1W/XNifPwBJ9aF6ziZKux717i6BsxYuuhIDs0TB5V/GQ4SLHsltQM0IPds0wfjdSJTUKHoktwgTynCVGDz0KUVwQog4OzG5WyExeIGcofgWueC+R3L7wMIHgr0hAoT6iFbokdwqbBbhHjZF4ZIdEB2QjF/+IKFmg2786Ua4HCiCmRdsNEIEh9XaCIpk3sPLdy/eUclBCICdD2D+7gb4+sy7QNlodEgwoEgulajy3EEaf3yP/BKo/MQTFjiA6RbE+r2bwZuMiT/8sUEW0RxCcg/tIh53G6FH8jlAA5I7nx7/fwAXPj5a4WiS/gtTS5gZ9+6YVwAAAABJRU5ErkJggg== Image1 True Transparent 0.7,0,6.3,0.5 Left Arial,12,Bold 5,0,0,0 Text1 04 - Commitments - Due {StartDate.ToString("dd-MMM-yyyy")} through {TimeZoneInfo.ConvertTime(DateTime.UtcNow,TimeZoneInfo.FindSystemTimeZoneById(varLocalTimeZone)).AddDays(90).ToString("dd-MMM-yyyy")} Black Expression Transparent 7.02,0,3.2,0.5 Right Arial,10 Right 0,0,0,0 Text2 {.Models.util.ReportHelper.GetReportHeader(varLocalTimeZone)} Black Expression PageHeaderBand1 Transparent 0,7.42,10.22,0.3 Transparent 0,0,10.22,0.3 Fill Arial,10 Right 0,0,0,0 Text3 {PageNofM} Black Bottom PageFooterBand1 Transparent 0,1.1,10.22,0.3 Bottom;Black;1;Solid;False;4;Black Transparent 0,0.1,10.2,0.2 Arial,10,Bold 0,0,0,0 Text4 Product: {IIF(string.IsNullOrEmpty(Submission.Product),"None",Submission.Product)} Black Expression {Submission.Product} GroupHeaderBand1 Transparent 0,1.8,10.22,0.6 Transparent 0,0.1,10.2,0.2 Arial,10 0,0,0,0 Text5 Application: {IIF(string.IsNullOrEmpty(Submission.Application),"None",Submission.Application)} Black Expression All;Black;1;Solid;False;4;Black [184:184:184] 0,0.3,0.9,0.3 Arial,9,Bold 3,0,0,0 Text6 Country Black Center All;Black;1;Solid;False;4;Black [184:184:184] 0.9,0.3,1.3,0.3 Arial,9,Bold 3,0,0,0 Text8 Commitment Type Black Center All;Black;1;Solid;False;4;Black [184:184:184] 2.2,0.3,1.6,0.3 Arial,9,Bold 3,0,0,0 Text10 Commitment Name Black Center All;Black;1;Solid;False;4;Black [184:184:184] 3.8,0.3,2.1,0.3 Arial,9,Bold 3,0,0,0 Text12 Commitment Description Black Center All;Black;1;Solid;False;4;Black [184:184:184] 5.9,0.3,0.9,0.3 Arial,9,Bold 3,0,0,0 Text14 Due Date Black Center All;Black;1;Solid;False;4;Black [184:184:184] 6.8,0.3,1,0.3 Arial,9,Bold 3,0,0,0 Text16 Due Date Type Black Center All;Black;1;Solid;False;4;Black [184:184:184] 8.65,0.3,1.55,0.3 Arial,9,Bold 3,0,0,0 Text20 Responsible Person(s) Black Center All;Black;1;Solid;False;4;Black [184:184:184] 7.8,0.3,0.85,0.3 Arial,9,Bold 3,0,0,0 Text22 Status Black Center {Submission.Application} GroupHeaderBand2 True Transparent 0,2.8,10.22,0.1 All;Black;1;Solid;False;4;Black Transparent True 0,0,0.9,0.3 Arial,9 True 0,0,0,0 Text18 {Submission.Country} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Typographic DataColumn All;Black;1;Solid;False;4;Black Transparent True 0.9,0,1.3,0.3 Arial,9 True 0,0,0,0 Text19 {Submission.CommitmentCategory} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Typographic All;Black;1;Solid;False;4;Black Transparent True 2.2,0,1.6,0.3 Arial,9 e.Value = varBaseURL+"TasksDetails.aspx?ItemId="+Submission.TaskID +"&EntityName="+Task; True 0,0,0,0 Text24 {Submission.Name} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Typographic All;Black;1;Solid;False;4;Black Transparent True 3.8,0,2.1,0.3 Arial,9 True 0,0,0,0 Text25 {Submission.Description} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Typographic All;Black;1;Solid;False;4;Black Transparent True 5.9,0,0.9,0.3 Arial,9 True Center 0,0,0,0 Text26 {TimeZoneInfo.ConvertTime(DateTime.SpecifyKind(Submission.DueDate,DateTimeKind.Utc),TimeZoneInfo.FindSystemTimeZoneById(varLocalTimeZone)).ToString("dd-MMM-yyyy")} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Typographic Expression All;Black;1;Solid;False;4;Black Transparent True 6.8,0,1,0.3 Arial,9 True 0,0,0,0 Text27 {Submission.DueDateType} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Typographic All;Black;1;Solid;False;4;Black Transparent True 7.8,0,0.85,0.3 Arial,9 True 0,0,0,0 Text29 {Submission.Status} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Typographic All;Black;1;Solid;False;4;Black Transparent True 8.65,0,1.55,0.3 Transparent 0,0,1.55,0.3 SubReport1 3b2090eeea88c19068998eaeaa1261ff True Panel1 Submission DataBand2 DESC DueDate 742be95415ba484db0b0bc1dc28fef9f 0.39,0.39,0.39,0.39 Page1 Landscape 8.5 11 Letter Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent True 0,0.2,1.55,0.2 Transparent True True 0,0,1.5,0.2 Arial,9 0,0,0,0 Text13 {Task_AssignedContacts.Name} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Typographic Relation1 Task_AssignedContacts _x007B_Task_AssignedContacts.Task.ID_x0020__x003D__x003D__x0020_Submission.TaskID_x007D_ DataBand1 Transparent True 0,0.8,1.55,0.2 Transparent True True 0,0,1.5,0.2 Arial,9 0,0,0,0 Text7 {Task_AssignedGroups.Name} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Typographic Relation2 Task_AssignedGroups _x007B_Task_AssignedGroups.Task.ID_x0020__x003D__x003D__x0020_Submission.TaskID_x007D_ DataBand3 Transparent True 0,1.4,1.55,0.2 Transparent True True 0,0,1.5,0.2 Arial,9 0,0,0,0 Text9 {Task_AssignedUsers.Name} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Typographic Relation3 Task_AssignedUsers _x007B_Task_AssignedUsers.Task.ID_x0020__x003D__x003D__x0020_Submission.TaskID_x007D_ DataBand4 3b2090eeea88c19068998eaeaa1261ff 0.39,0.39,0.39,0.39 Page_SubReport1 11.69 2.33 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll System.Core.dll .Web.dll .Models.dll .ModelImpl.dll Report 1/27/2014 3:51:49 PM 3/19/2013 9:26:42 AM Report.mrt b5999f6505fb22f8cd86d2e5c28219db Report Inches 2014.1.1805 CSharp