OleDbConnection OleDbConnection

header name,System.String project,System.Int32 30 header OleDbConnection SELECT project, name FROM project WHERE project.project IN ( SELECT DISTINCT project FROM trans )

projects Cost,System.Decimal project,System.Int32 30 projects OleDbConnection student1,students.student,3,0 student2,students.student,3,0 True SELECT project, SUM(cost) AS Cost FROM trans WHERE student = ? GROUP BY project UNION SELECT project, 0 AS Cost FROM trans WHERE project NOT IN ( SELECT project FROM trans WHERE student = ? GROUP BY project ) GROUP BY project studentdetails Category,System.String name,System.String student,System.Int32 30 studentdetails OleDbConnection student,students.student,3,0 True SELECT student, name, CASE WHEN student % 2 = 1 THEN 'Odd' ELSE 'Even' END Category FROM student WHERE student = ? students name,System.String student,System.Int32 30 students OleDbConnection SELECT student, name FROM student WHERE student IN ( SELECT DISTINCT student FROM trans ) EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,10.22,0.3 Transparent 0,0,3.2,0.3 Transparent 0,0,1.6,0.3 Arial,10,Bold Center 0,0,0,0 Text1 Student Name Black Expression Center Transparent 1.6,0,1.6,0.3 Arial,10,Bold 7f15085f98084bb9b66f7e3075e5777b Center 0,0,0,0 Text4 Category Black Expression Center 0 0 CrossDataBand1 HeaderBand1 Transparent 0,0.9,10.22,0.3 Transparent 0,0,3.2,0.3 Transparent 0,0,1.6,0.3 Arial,10 10c3e15789704be9aa43ba7049021867 Center 0,0,0,0 Text3 {studentdetails.name} Black Expression Center Transparent 1.6,0,1.6,0.3 Arial,10 afa1f37079a8496883fa489087b7cb26 Center 0,0,0,0 Text5 {studentdetails.Category} Black DataColumn Center studentdetails 0 0 CrossDataBand3 Transparent 3.2,0,0.9,0.3 Transparent 0,0,0.9,0.3 Arial,10 f5749e007a7a4c1ba347aafd0dc7a7ab Center 0,0,0,0 Text6 {projects.Cost} Black , 1 False Expression Center projects 0 0 CrossDataBand4 students Datastudents Transparent 0,1.6,10.22,0.3 Transparent 0,0,3.2,0.3 Transparent 0,0,3.2,0.3 Arial,10,Bold 5367f56f01ed42fa815244ecfe413cb1 Right 0,0,0,0 Text11 Totals: Black , 1 False Expression Center 0 0 CrossDataBand9 Transparent 3.2,0,0.9,0.3 Transparent 0,0,0.9,0.3 Arial,10 ae549f68178e4894907e7e10508ff2c0 Center 0,0,0,0 Text8 {Sum(CrossDataBand4,projects.Cost)} Black , 1 False Totals Center projects af67938620744c93ac31b5b83b699794 0 0 CrossDataBand10 FooterBand1 4c1fb4757d4241e0b9f9cd2b4e9b818f 0.39,0.39,0.39,0.39 Page1 Landscape 8.5 11 Letter 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 Report 1/20/2015 9:17:51 AM 12/23/2014 11:04:28 AM C:\SVN\SS-RPT-Branch\Test\TST-0004.mrt c23e148a59954307949de6ecabd84a93 Report Inches 2011.1.919 CSharp