SQLServer Integrated Security=False;Data Source=(local)\SQLServer;User ID=sa;Initial Catalog=ExamSys;Password=leafcon;Persist Security Info=True SQLServer Std ClsCode,System.Byte Cls,System.String ClsRank,System.Int16 StdCode,System.Int32 ERN,System.Int16 Name,System.String PDate,System.DateTime WeekDay,System.String UWeekDay,System.String SubCode,System.Int16 Sub,System.String SubRank,System.Int32 Syllabus,System.String STime,System.String ETime,System.String 30 Std SQLServer Select Cls.ClsCode,Cls.Name As Cls,Cls.[Rank] As ClsRank, Std.StdCode,Std.ERN,Std.Name, DateSh.PDate,DATENAME(WEEKDAY,DateSh.PDate) As [WeekDay],[WeekDay].Name As UWeekDay, DateSh.SubCode,Sub.Name As Sub,CPSub.[Rank] As SubRank,DateSh.Syllabus, CAST(DATEPART(HOUR,Exam.STime) As VarChar)+':' +CASE WHEN (DATEPART(MINUTE,Exam.STime)<10) THEN '0'+CAST(DATEPART(MINUTE,Exam.STime) As VarChar) ELSE CAST(DATEPART(MINUTE,Exam.STime) As VarChar) END +' '+CASE WHEN (DATEPART(HOUR,Exam.STime)<12) THEN 'AM' ELSE 'PM' END As STime, CAST(DATEPART(HOUR,Exam.ETime) As VarChar)+':' +CASE WHEN (DATEPART(MINUTE,Exam.ETime)<10) THEN '0'+CAST(DATEPART(MINUTE,Exam.ETime) As VarChar) ELSE CAST(DATEPART(MINUTE,Exam.ETime) As VarChar) END +' '+CASE WHEN (DATEPART(HOUR,Exam.ETime)<12) THEN 'AM' ELSE 'PM' END As ETime From DateSh Inner Join Exam On DateSh.ExamCode=Exam.ExamCode Inner Join ClsProg On DateSh.CPCode=ClsProg.CPCode Inner Join Cls On ClsProg.ClsCode=Cls.ClsCode Inner Join Std On ClsProg.CPCode=Std.CPCode Inner Join Sub On DateSh.SubCode=Sub.SubCode Inner Join CPSub On DateSh.CPCode=CPSub.CPCode And DateSh.SubCode=CPSub.SubCode Left Outer Join [WeekDay] On DATEPART(WEEKDAY,DateSh.PDate)=[WeekDay].WeekDayCode Where DateSh.ExamCode={ExamCode} And Std.BranchCode={BranchCode} And Std.LevDate Is Null And DateSh.Syllabus Is Null ,ExamCode,ExamCode,System.String,_x0027_1-2_x0027_,False,False ,BranchCode,BranchCode,System.Int16,_x0031_,False,False ,WhereClause,WhereClause,System.String,_x0020_,False,False ,Logo,Logo,System.Drawing.Image,,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0,7.07,5.25 {Std.Cls} Transparent 0,0.15,7.07,0 {Std.ClsRank} ghbCls {Std.ERN} - {Std.Name} Transparent 0,0.45,7.07,1.6 Transparent 0.7,1.3,3.2,0.2 Arial,11,Bold True 0,0,0,0 Text1 {Std.Name} Black DataColumn Transparent 0,1,0.6,0.2 Arial,11,Bold 79abfa0096334cfdb40df3b3fd849c8b True 0,0,0,0 Text2 Roll No Black Expression Transparent 0.7,1,0.9,0.2 Arial,11,Bold 33b62ba0e2ca4ecea3d99dd33cb7f495 True 0,0,0,0 Text3 {Std.ERN} Black DataColumn Transparent 0,1.3,0.6,0.2 Arial,11,Bold 90e394ad63104a1da7c2cace92d62ffb True 0,0,0,0 Text4 Name Black Expression Transparent 5.7,1.3,0.47,0.2 Arial,11,Bold be90fb273456453ca32741affbdb89d3 True 0,0,0,0 Text5 Class Black Expression Transparent 6.27,1.3,0.8,0.2 Arial,11,Bold 210284fee06b476fa7f38412bdff5531 0,0,0,0 Text6 {Std.Cls} Black DataColumn Transparent 0.6,1,0.1,0.2 Arial,11,Bold Center 0,0,0,0 Text13 : Black Expression Center Transparent 0.6,1.3,0.1,0.2 Arial,11,Bold 162b037e3f46471eae7218faf5a3394d Center 0,0,0,0 Text14 : Black Expression Center Transparent 6.17,1.3,0.1,0.2 Arial,11,Bold 26533c51554242ee8a41f1b2d1b31e13 Center 0,0,0,0 Text15 : Black Expression Center Transparent 0.01,0,7.06,0.7 {Logo} Image1 True Transparent 0,0.7,7.07,0.3 Bernard MT Condensed,16,Bold 159e7f159c7c44c5a3fd3ad707f5bcc2 Center 0,0,0,0 Text16 ROLL NO. SLIP Black Expression Center 0,1.2,7.07,0.01 Black Black True HorizontalLinePrimitive1 Black 0,1.5,7.07,0.01 Black Black af1a32d5a492437eac774eb4819300af True HorizontalLinePrimitive2 Black {Std.ERN} ghbRN Transparent 0,2.35,7.07,0.3 All;Black;1;Solid;False;4;Black GradientBrush,White,DarkGray,90 1.05,0,1.5,0.3 Arial,11,Bold c6c2bb335b3447bda882d9a912f2c678 Center 0,0,0,0 Text7 Date Black Expression Center All;Black;1;Solid;False;4;Black GradientBrush,White,DarkGray,90 2.55,0,1.5,0.3 Arial,11,Bold 7b36cfad84ea4b4081e57a4ceba30cd7 Center 0,0,0,0 Text8 Day Black Expression Center All;Black;1;Solid;False;4;Black GradientBrush,White,DarkGray,90 4.05,0,1.8,0.3 Arial,11,Bold a945abd176394594a2c92fd467b87c00 Center 0,0,0,0 Text9 Paper Black Expression Center {Std.ERN} ghbRN2 Transparent 0,2.95,7.07,0.3 All;Black;1;Solid;False;4;Black Transparent 1.05,0,1.5,0.3 Arial,11 dcb21909959e4afaae81bfd41508ba81 Center 0,0,0,0 Text10 {Std.PDate} Black dd/MM/yyyy DataColumn Center All;Black;1;Solid;False;4;Black Transparent 2.55,0,1.5,0.3 Arial,11 636f8fff51ca497e92ccf5d63ea09158 Center 0,0,0,0 Text11 {Std.WeekDay} Black DataColumn Center All;Black;1;Solid;False;4;Black Transparent 4.05,0,1.8,0.3 Arial,11 4927bc91c75749f28e9d5a9e250745b9 Center 0,0,0,0 Text12 {Std.Sub} Black DataColumn Center Std dbStd ASC PDate ASC SubRank Transparent 0,3.55,7.07,0 gfbRN2 Transparent 0,3.85,7.07,0.32 Transparent 1.05,0.05,4.83,0.24 Arial,11,Bold b4a4ad725fd44d9fa7ab8a7af51b4810 0,0,0,0 Text17 Timing : {Std.STime} - {Std.ETime} Black dd/MM/yyyy Expression Center gfbRN Transparent 0,4.47,7.07,0 gfbCls True True Panel1 Transparent 0,5.84,7.07,5.25 True Clone1 01e9bee8f8824bf28b6c934ce18abee9 0.6,0.6,0.3,0.3 Page1 11.69 8.27 A4 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 Roll No Slips 2/24/2013 9:29:17 AM 9/8/2010 6:39:30 PM D:\Leaf Automation Consultant\ExamSys_New\ExamSys\Reports\rRNSlip.mrt 34b96a5d21224df8951edfe12cee361d Roll No Slips Inches 2011.3.1200 CSharp